|
|
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 |
3697 |
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 |
1938 |
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 |
3639 |
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 |
5701 |
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 |
1957 |
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 |
2774 |
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 |
6591 |
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 |
3474 |
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 |
1394 |
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 |
1868 |
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 |
5153 |
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 |
2644 |
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 |
2466 |
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 |
2095 |
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 |
3288 |
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 |
2223 |
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 |
1797 |
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 |
6376 |
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 |
1334 |
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 |
1869 |
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 |
2581 |
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 |
2970 |
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 |
6714 |
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 |
6587 |
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 |
1516 |
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 |
6180 |
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 |
2335 |
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 |
2251 |
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 |
5226 |
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 |
7080 |
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 |
1587 |
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 |
1634 |
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 |
3439 |
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 |
2491 |
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 |
6428 |
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 |
2497 |
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 |
5922 |
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 |
4825 |
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 |
5325 |
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 |
2998 |
Fri, 12 September 2008 02:23 By: harrysmall3 ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |