|
|
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 |
1431 |
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 |
2049 |
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 |
1702 |
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 |
2192 |
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 |
3461 |
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 |
2047 |
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 |
2733 |
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 |
2431 |
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 |
4739 |
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 |
2247 |
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 |
2193 |
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 |
1885 |
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 |
2879 |
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 |
6313 |
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 |
6235 |
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 |
1476 |
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 |
2457 |
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 |
3895 |
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 |
4286 |
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 |
5384 |
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 |
1397 |
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 |
2591 |
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 |
1608 |
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 |
1773 |
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 |
1589 |
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 |
2295 |
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 |
2918 |
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 |
4052 |
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 |
1448 |
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 |
2539 |
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 |
23183 |
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 |
4055 |
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 |
7495 |
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 |
1842 |
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 |
7376 |
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 |
5860 |
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 |
1462 |
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 |
8168 |
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 |
2607 |
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 |
13972 |
Thu, 25 September 2008 22:55 By: rleishman ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |