|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
can oracle access table in parallel with index? oracle 10g r2 By: Kriptas on Tue, 21 October 2008 |
1 |
1403 |
Tue, 21 October 2008 13: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 Optimization (merged) |
4 |
2024 |
Tue, 21 October 2008 13:38 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) |
|
Query running more timeand then time out message Oracle, 9i ,window xp |
1 |
1676 |
Tue, 21 October 2008 06: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) |
|
ORA-03113 after performance tuning Oracle 9.2.0.3, Windows 2003 By: dzavy on Mon, 20 October 2008 |
2 |
2172 |
Mon, 20 October 2008 20:38 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) |
|
Slow query - Please help. |
16 |
3419 |
Sat, 18 October 2008 22:07 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) |
![icon5.gif](/forum/images/message_icons/icon5.gif) |
Slow cpu-bound hard parse in one environment, fast in another By: pmc123 on Fri, 17 October 2008 |
3 |
2027 |
Sat, 18 October 2008 21:57 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) |
|
tuning a view Oracle 10g, Windows |
4 |
2684 |
Sat, 18 October 2008 12:47 By: getritesh ![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) |
|
optimize query 10g |
5 |
2382 |
Thu, 16 October 2008 09:24 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) |
|
Getting Plan of SQL query executed in the past (merged) By: kumarsz on Thu, 16 October 2008 |
1 |
4713 |
Thu, 16 October 2008 08:18 By: kumarsz ![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) |
|
Very Strange and Interesting Oracle Issue 10g R2 |
3 |
2215 |
Thu, 16 October 2008 08:12 By: nsteblay ![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 to tune the query solaris 10 oracle 10.2.0.3 |
4 |
2162 |
Thu, 16 October 2008 07:57 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) |
|
Which is faster 10g |
4 |
1864 |
Thu, 16 October 2008 06:45 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) |
![icon5.gif](/forum/images/message_icons/icon5.gif) |
Performance issue with RETURNING BULK COLLECT clause Oracle 10g on Linux By: snomula on Thu, 09 October 2008 |
3 |
2872 |
Thu, 16 October 2008 06: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) |
|
OEM performance issue oracle 10G on RHEL 4 |
0 |
6303 |
Wed, 15 October 2008 22:36 By: bangalibor ![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 on RAC Linux Redhat 4 AS/ES |
19 |
6221 |
Wed, 15 October 2008 02:14 By: altafhk ![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) |
|
MAJOR performance issues since upgrade to 10G 10.2.0.3.0 By: kenton on Tue, 14 October 2008 |
2 |
1469 |
Tue, 14 October 2008 16:35 By: kenton ![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) |
|
TRIGGERS/PROCEDURES running too slow after index rebuild ORACLE 8i |
4 |
2448 |
Tue, 14 October 2008 01:39 By: ajaysharma2907 ![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) |
|
Bulk insert Oracle 9i,windows |
4 |
3860 |
Mon, 13 October 2008 05:36 By: balaji1482 ![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) |
|
about sql access advisor oracle10g, 10.2.0, RHEL AS4 |
5 |
4255 |
Sun, 12 October 2008 03:45 By: Arju ![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 slow after 10g upgrade 10.2.0.3 on hp-ux |
10 |
5344 |
Sun, 12 October 2008 03:38 By: Arju ![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) |
|
After Defining Index 10.2.0.1 By: pmapc on Fri, 10 October 2008 |
2 |
1378 |
Fri, 10 October 2008 02:02 By: pmapc ![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) |
|
General Question 9i By: MrSethT on Mon, 06 October 2008 |
8 |
2583 |
Thu, 09 October 2008 22:58 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 tuning |
2 |
1591 |
Thu, 09 October 2008 15:33 By: ArvindBhope ![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) |
|
10.2..0..2 solaris9 |
3 |
1761 |
Thu, 09 October 2008 12:01 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) |
|
segment tuning 10.2.0.1 |
2 |
1570 |
Thu, 09 October 2008 10:33 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) |
|
Index creation- Performance impact Oracle 10g |
4 |
2272 |
Thu, 09 October 2008 09:47 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 tune UNION Oracle,10g,Windows XP |
7 |
2879 |
Thu, 09 October 2008 09:26 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 Assistance in Fine tuning the SQL |
2 |
4039 |
Tue, 07 October 2008 07:43 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) |
|
Fine tuning |
1 |
1438 |
Mon, 06 October 2008 05:30 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) |
|
need assistance to optimize the query oracle 10.2.0.3 |
3 |
2521 |
Sat, 04 October 2008 21:09 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 Due to Buffer Sort Oracle 10.2.0.2.0 By: senaka on Tue, 30 September 2008 |
9 |
23117 |
Sat, 04 October 2008 00:16 By: senaka ![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) |
|
Dictionary Cache Hit ratio Oracle 9.2.0.8 |
1 |
4031 |
Thu, 02 October 2008 10:19 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) |
![icon9.gif](/forum/images/message_icons/icon9.gif) |
Need to improve query performance Oracle 10g ( 1 2) |
44 |
7410 |
Wed, 01 October 2008 02:50 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) |
|
Pagination in big result sets Oracle 10g |
1 |
1833 |
Mon, 29 September 2008 22:41 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) |
|
Why does t.rowid = t.rowid improves performance? Oracle Enterprise Edition Release 9.2.0.6.0 By: emil_m on Fri, 26 September 2008 |
13 |
7312 |
Mon, 29 September 2008 12:29 By: coleing ![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) |
|
Two 30 million records tables join query needs tuning Oracle 10g,AIX |
9 |
5826 |
Sat, 27 September 2008 12: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) |
|
a locking scenario Generic By: gkrishn on Fri, 26 September 2008 |
1 |
1451 |
Fri, 26 September 2008 10:14 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) |
|
SQL execution time based on ash history 10g release 2 |
0 |
8156 |
Fri, 26 September 2008 04:23 By: John Charles ![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) |
|
taking to much time to update oracle 9i/Linux By: tannad on Tue, 23 September 2008 |
7 |
2579 |
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 |
13937 |
Thu, 25 September 2008 22:55 By: rleishman ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |