|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
taking to much time to update oracle 9i/Linux By: tannad on Tue, 23 September 2008 |
7 |
2994 |
Fri, 26 September 2008 00:50 By: Kevin Meade ![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 delete records without generating redo logs? Oracle 10g |
11 |
14458 |
Thu, 25 September 2008 22:55 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) |
|
Slow Execution Stored Procedure with cursors Oracle, 8, Windows 2003 By: sabishs on Thu, 25 September 2008 |
1 |
3962 |
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 |
2211 |
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 |
4104 |
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 |
6260 |
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 |
2130 |
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 |
3041 |
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 |
6865 |
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 |
3759 |
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 |
1876 |
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 |
2456 |
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 |
5757 |
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 |
2913 |
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 |
3117 |
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 |
3197 |
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 |
3593 |
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 |
3167 |
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 |
2515 |
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 |
6900 |
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 |
1741 |
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 |
2073 |
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 |
2773 |
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 |
3235 |
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 |
6821 |
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 |
6731 |
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 |
1843 |
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 |
6589 |
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 |
2664 |
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 |
2462 |
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 |
5498 |
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 |
7359 |
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 |
2028 |
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 |
2073 |
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 |
3750 |
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 |
3711 |
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 |
6612 |
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 |
2681 |
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 |
6594 |
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 |
5138 |
Fri, 12 September 2008 03:24 By: rleishman ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |