|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Stale Stats for Partitoined table |
2 |
3176 |
Tue, 27 January 2009 10:40 By: sonumalhi ![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) |
|
Multiple schemas against single schema - ERP Oracle 10g |
5 |
3543 |
Tue, 27 January 2009 04:53 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) |
|
Not able to reduce the optimizer cost after creating index |
2 |
1399 |
Tue, 27 January 2009 04:08 By: flyboy ![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) |
|
Going for full table scan Oracle 10G /Linux |
3 |
1669 |
Mon, 26 January 2009 23:52 By: dhanamukesh ![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 tune |
10 |
3218 |
Mon, 26 January 2009 03:33 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) |
|
Not sure what is causing the slow performance 10.2.0.1, Windows 2003 |
4 |
2117 |
Sun, 25 January 2009 19:46 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) |
|
How to interpret the tkprof output Oracle 9.2.0.8.0 - 64bit on HP-UX B.11.11 U |
5 |
5076 |
Sun, 25 January 2009 19:42 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) |
|
high water mark (merged) |
4 |
2503 |
Fri, 23 January 2009 19:58 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) |
|
HOW to tune this query By: chaituu on Wed, 21 January 2009 |
5 |
2354 |
Fri, 23 January 2009 06:55 By: chaituu ![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) |
|
Io cost too high Oracle 10G/Linux |
4 |
1473 |
Wed, 21 January 2009 10:25 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) |
|
Concurrency and row cache lock problem in oracle10.2 oracle10.2 ,suse linux |
1 |
3844 |
Wed, 21 January 2009 06:53 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) |
![icon5.gif](/forum/images/message_icons/icon5.gif) |
converting Normal Table to Partitioned Table Oracle 10.2.0.4, SUSE linux 64 bit |
3 |
3147 |
Mon, 19 January 2009 02:43 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) |
|
Who is faster Cursor or Recored |
7 |
2269 |
Sun, 18 January 2009 01:57 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) |
|
Performance Issue with FORALL BULK COLLECT |
2 |
1436 |
Sat, 17 January 2009 13: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) |
|
Working slowley after 6 to 7hrs oracle 10g XP |
2 |
1386 |
Sat, 17 January 2009 02:10 By: dhanuka.rajesh ![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 i can increase the performance of my query |
10 |
2331 |
Sat, 17 January 2009 01:13 By: eng.oracle ![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) |
|
Slowness of sql query (merged) |
2 |
1424 |
Fri, 16 January 2009 02:45 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 lot of time oracle 10g |
4 |
1837 |
Fri, 16 January 2009 02:35 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) |
|
Qurey taking much cost 10GR2 |
2 |
1535 |
Fri, 16 January 2009 02:29 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) |
|
Database slow after attaching new storage 9.2.0.6.0 on Solaris |
2 |
1636 |
Thu, 15 January 2009 05:57 By: rakeshgj_36 ![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 issues 10gR2 By: nani_ar on Sun, 04 January 2009 |
9 |
4308 |
Thu, 15 January 2009 05:50 By: rakeshgj_36 ![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) |
|
Tempfile readtime and Writetime DB version 9.2.0.7 AIX By: dbcop on Tue, 13 January 2009 |
1 |
1408 |
Tue, 13 January 2009 10:45 By: Mahesh Rajendran ![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 lot of time 10.2.0.2 |
6 |
2096 |
Tue, 13 January 2009 10:23 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) |
|
Speed of query 10g |
3 |
2090 |
Sun, 11 January 2009 18:07 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) |
|
Performance Prob with Group and Orader by clause Oracle DB version 9.2.0.7 on AIX By: dbcop on Thu, 08 January 2009 |
2 |
2592 |
Sun, 11 January 2009 18:04 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) |
|
Need help in Optimizing this query oracle 8i By: RiverX on Thu, 08 January 2009 |
5 |
1875 |
Sun, 11 January 2009 08:05 By: michael_bialik ![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) |
|
Purge recyclebin |
3 |
4317 |
Sun, 11 January 2009 01:09 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) |
|
Oracle 9i SQL not using MV. |
21 |
5649 |
Fri, 09 January 2009 11:54 By: chintu00 ![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 sql query 10.2.0.2 |
8 |
4232 |
Fri, 09 January 2009 03:20 By: cookiemonster ![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) |
|
Select statement is causing performance issue By: ind9 on Thu, 08 January 2009 |
16 |
3444 |
Fri, 09 January 2009 03:10 By: cookiemonster ![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) |
|
cpu usage during backup 10.2.0.2 |
6 |
2075 |
Thu, 08 January 2009 21:24 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) |
|
Optimized Query with LIKE Operator (merged) |
8 |
5428 |
Thu, 08 January 2009 09:54 By: shankhan ![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) |
|
Pga hit ratio Oracle 10g R2,Linux AS4 |
1 |
3860 |
Thu, 08 January 2009 00:47 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) |
|
PGA MEMORY LEAK Oracle Database 11g, 11.1.0.6, RHEL x86_64 By: andydba on Mon, 05 January 2009 |
1 |
3991 |
Tue, 06 January 2009 02:26 By: Frank Naude ![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) |
|
Primary key index not working proper after import oracle 8.1.7.0.0 |
4 |
2455 |
Tue, 06 January 2009 02:02 By: michael_bialik ![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 problem (Merged) By: mamalik on Mon, 05 January 2009 |
9 |
2255 |
Mon, 05 January 2009 06:00 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) |
|
Db writer Process By: dbcop on Fri, 02 January 2009 |
6 |
6311 |
Sat, 03 January 2009 10:16 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) |
|
Performance issue in procedure due to cursors Oracle 9i By: vps_25 on Fri, 02 January 2009 |
2 |
2248 |
Fri, 02 January 2009 19:25 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) |
|
sql tuning oracle 10g |
10 |
3828 |
Fri, 02 January 2009 08:26 By: S.Rajaram ![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/PL/SQL Tunning Hints Connected to Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 By: sonalir on Fri, 02 January 2009 |
1 |
4225 |
Fri, 02 January 2009 04:01 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |