|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Slow Execution Stored Procedure with cursors Oracle, 8, Windows 2003 By: sabishs on Thu, 25 September 2008 |
1 |
3663 |
Thu, 25 September 2008 09:36 By: JRowbottom ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Index Creation with Parallel Option Oracle 10g Rel 2 |
3 |
1899 |
Thu, 25 September 2008 09:09 By: faiz_hyd ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Improve in-memory sort performance Oracle 10g on Linux |
3 |
3608 |
Thu, 25 September 2008 05:15 By: rleishman ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Stroring Hierarchical Data(XML) into relational Table Oracle 9.2,XP |
21 |
5581 |
Wed, 24 September 2008 17:11 By: guru_karnam ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
procedure tuning oracle 10g |
3 |
1924 |
Wed, 24 September 2008 11:01 By: JRowbottom ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Query performance Oracle 10g |
9 |
2705 |
Tue, 23 September 2008 13:13 By: Kriptas ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
First_rows Versus All_rows Oracle 9.2.0.8 |
3 |
6553 |
Tue, 23 September 2008 08:48 By: shrinika ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
v$sess_io info is not changing. oracle 9.2.0.8 |
2 |
3447 |
Mon, 22 September 2008 14:17 By: shrinika ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Parallel inserts Oracle 10g,Rel 2 ,Linux AS4 |
1 |
1376 |
Mon, 22 September 2008 09:00 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Query taking long time |
4 |
1828 |
Mon, 22 September 2008 05:27 By: joshirish ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Why This Execution Plan |
22 |
4990 |
Mon, 22 September 2008 00:54 By: scottwmackey ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
How to change value of CLUSTERING_FACTOR of index oracle 10g hpux11 By: reyazan on Thu, 18 September 2008 |
4 |
2606 |
Sun, 21 September 2008 14:38 By: harrysmall3 ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Relationsip between Parallel Degree & Clustering Factor Oracle 10g Rel 2 ( 2 Node RAC ) , Solaris 10 By: feroze on Wed, 10 September 2008 |
4 |
2432 |
Sun, 21 September 2008 09:45 By: VivekSharma ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
![icon8.gif](/forum/images/message_icons/icon8.gif) |
Partitioned table growing too fast 10.2.0.3 on Solaris 8 |
5 |
2064 |
Sat, 20 September 2008 13:27 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Tuning query approach Oracle 9i By: Olivia on Mon, 15 September 2008 |
11 |
3220 |
Sat, 20 September 2008 02:16 By: Kriptas ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
How to avoid TableAccessFull Performance Tuning |
5 |
2188 |
Fri, 19 September 2008 15:20 By: harrysmall3 ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Find out what query is running for specific session? oracle 9.2.0.8 |
2 |
1770 |
Fri, 19 September 2008 14:32 By: shrinika ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
SQL query performance issue By: kirtani on Thu, 11 September 2008 |
31 |
6242 |
Thu, 18 September 2008 17:12 By: harrysmall3 ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
How the Query works By: basmraj on Thu, 18 September 2008 |
1 |
1313 |
Thu, 18 September 2008 08:46 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
dbms_stats 10.2.0.1 Solaris |
2 |
1850 |
Thu, 18 September 2008 08:38 By: varunvir ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
query performance related |
10 |
2535 |
Thu, 18 September 2008 07:54 By: Kriptas ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Help in tuning query |
11 |
2908 |
Wed, 17 September 2008 23:23 By: trupti111 ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Performance Test: IS NOT NULL check Oracle 9.2.0.3 Unix |
0 |
6681 |
Wed, 17 September 2008 18:48 By: harrysmall3 ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Run time versus Elapsed time Oracle 9.2.0.8 |
2 |
6559 |
Wed, 17 September 2008 15:40 By: shrinika ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Index rebuild AIX 9.2.0.6 |
1 |
1492 |
Wed, 17 September 2008 00:55 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Low oracle performance oracle 10g r2, HPUX |
29 |
6077 |
Tue, 16 September 2008 10:51 By: Kriptas ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Database buffer cache monitoring Oracle 10g,solaris |
5 |
2299 |
Tue, 16 September 2008 04:18 By: JRowbottom ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Problem with SQL Plan |
6 |
2188 |
Tue, 16 September 2008 04:09 By: JRowbottom ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Statspack Report - Suggestion 9.2.0.7 |
8 |
5154 |
Tue, 16 September 2008 01:21 By: Brayan ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Help - To get Row Source Operation in Tkprof Oracle 10g R2 on RHEL 4 |
0 |
7060 |
Mon, 15 September 2008 08:54 By: orasaket ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
How to SQL Tuning? Explain Steps |
2 |
1554 |
Mon, 15 September 2008 04:01 By: Alessandro Rossi ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
temporary tablespace growing Oracle 10 R1-Linux By: dirish on Sun, 14 September 2008 |
3 |
1603 |
Sun, 14 September 2008 23:42 By: BlackSwan ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
TKPROF Fetch stats 10g |
2 |
3404 |
Sun, 14 September 2008 14:05 By: ehegagoka ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
NumNull Stats |
8 |
2428 |
Sat, 13 September 2008 15:26 By: ehegagoka ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Interpreting Histograms 10g |
0 |
6404 |
Sat, 13 September 2008 14:14 By: ehegagoka ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
New predicate increasing response time from 30 sec to 6 min Oracle 10.2.0.3.0 |
5 |
2443 |
Fri, 12 September 2008 11:18 By: harrysmall3 ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Index not being used in Oracle 10g Oracle 10g |
2 |
5887 |
Fri, 12 September 2008 09:12 By: BlackSwan ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
TKPROF - High scattered read 9.2.0.7 By: Brayan on Fri, 12 September 2008 |
3 |
4775 |
Fri, 12 September 2008 03:24 By: rleishman ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
SUSE Oracle high CPU usgae problem Linux SUSE x86_64 GNU/Linux 2.6.5-7.97-smp/ Oracle Enterprise Edition 64 bit 10.2.3 |
6 |
5274 |
Fri, 12 September 2008 02:57 By: crazypeter2005 ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Doumentation of wait events Oracle 10.2 documentation By: martijn on Wed, 10 September 2008 |
4 |
2962 |
Fri, 12 September 2008 02:23 By: harrysmall3 ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |