|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Oracle UNION ALL performance issue Oracle 10g |
33 |
25581 |
Mon, 20 September 2010 03:17 By: Roachcoach ![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) |
|
nested loops 10.2.0.1 linux 32 bit |
10 |
3321 |
Wed, 15 September 2010 08:02 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) |
|
Sql Tunning Concept Oracle 10g |
5 |
2512 |
Wed, 15 September 2010 06:16 By: Roachcoach ![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) |
|
To find the indexes (used and unused on the table Oracle 10g on "Windows XP" and "Sun Solaris" |
3 |
2425 |
Wed, 15 September 2010 05:36 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 performance gain using statistics |
6 |
4730 |
Tue, 14 September 2010 10:08 By: jackman1 ![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 to tune query Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production |
15 |
3849 |
Tue, 14 September 2010 03:46 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) |
|
Procedures not getting executed Oracle 9.2.0.8 (HP-UX) |
3 |
2174 |
Mon, 13 September 2010 09: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) |
|
Standard vs Advanced Compression Windows Server 2008, Oracle 11g R2 |
3 |
3955 |
Sun, 12 September 2010 18:45 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) |
|
Is there a better way to rewrite this query? Oracle 11g , Linux |
8 |
3148 |
Sun, 12 September 2010 18:13 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) |
|
Obtaining 10046 Wait Events for Parallel Slaves 10.2.0.4 / Sparc / Solaris |
0 |
5795 |
Fri, 10 September 2010 01: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) |
|
Same plan, same data but different performance results Oracle 10 |
10 |
3231 |
Mon, 06 September 2010 03:11 By: Yasir Hashmi ![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) |
|
Cost of Query is brought down, but taking same time.(merged) Oracle 10g, Windows 2000 |
7 |
2811 |
Fri, 03 September 2010 01:29 By: Its_me_ved ![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) |
|
Please tune this query |
8 |
3153 |
Thu, 02 September 2010 07:27 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) |
|
Top 5 timed events Windows server,10.2.0.3 |
4 |
3476 |
Tue, 31 August 2010 12:04 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 slow oracle 10g |
25 |
6208 |
Tue, 31 August 2010 01:28 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) |
|
How to fine tune this query ? Oracle 11g R2 |
11 |
3317 |
Tue, 31 August 2010 01:06 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) |
|
search query oracle 10g |
21 |
4426 |
Mon, 30 August 2010 09:37 By: prashant_ora ![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) |
|
AWR and ADDM Windows server,10.2.0.3 |
1 |
1965 |
Mon, 30 August 2010 02:31 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) |
|
Perfomance issue while extracting XML data |
8 |
4400 |
Thu, 26 August 2010 16:39 By: harshalonline22 ![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) |
|
Get No of rows Processed while Update statment is still running 10.2 |
2 |
1793 |
Thu, 26 August 2010 00:44 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) |
|
No Redo for DML? |
25 |
10151 |
Wed, 25 August 2010 06:15 By: Roachcoach ![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) |
|
materalized view |
4 |
4722 |
Mon, 23 August 2010 09: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) |
|
Query Oracle 9i |
4 |
2191 |
Thu, 19 August 2010 16:56 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) |
|
Password profile Oracle 9i.2, Windows. |
4 |
2083 |
Tue, 17 August 2010 14: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) |
|
Index creation oracle 10g |
2 |
1836 |
Tue, 17 August 2010 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) |
|
TPC-E benchmarking Oracle 11g/r2 By: dsub42 on Sat, 14 August 2010 |
1 |
3271 |
Sat, 14 August 2010 21:32 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) |
|
redo logs generating after every 3 min oracle 10.0.2.4/Win 2k3 |
2 |
2866 |
Sat, 14 August 2010 00:51 By: hussain_dilshad ![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 performing query 10.1.0.5.0 - 64bit, AIX 6 By: cherry on Sun, 23 May 2010 |
20 |
11761 |
Fri, 13 August 2010 11:16 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) |
|
Requie help to tune the process Oracle,9.2.0.5.0,SunOS 5.9 By: sathik on Thu, 12 August 2010 |
15 |
8588 |
Fri, 13 August 2010 10:11 By: sathik ![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 get explain plan oracle 10g |
27 |
6153 |
Wed, 11 August 2010 02:31 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) |
|
Query tuning Oracle,9.0.2.0.5,Sunsolaris By: sathik on Mon, 09 August 2010 |
20 |
3538 |
Wed, 11 August 2010 01:21 By: sathik ![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 Update Oracle 10g on Win 2008 R2 SP2 |
32 |
6992 |
Tue, 10 August 2010 04:39 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) |
|
index creation oracle 10g unix |
7 |
2307 |
Mon, 09 August 2010 12:39 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) |
|
Table Partitioned with Primary key oracle 10.0.2 |
10 |
3446 |
Sat, 07 August 2010 23:12 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) |
|
create table statement with union |
27 |
4236 |
Fri, 06 August 2010 13:50 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) |
|
create table statement ( 1 2) |
43 |
6322 |
Fri, 06 August 2010 05:58 By: Roachcoach ![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) |
|
Partitions Oracle 11g |
10 |
2471 |
Thu, 05 August 2010 21:34 By: rahulvb ![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) |
|
Force Subquery To Use index Oracle 11g, CentOS 5 By: Vackar on Thu, 05 August 2010 |
5 |
2984 |
Thu, 05 August 2010 05:34 By: Vackar ![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 - Views inside a view Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 |
16 |
17761 |
Thu, 05 August 2010 04:09 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) |
|
Difference between cost and bytes 10g |
1 |
3963 |
Wed, 04 August 2010 01:40 By: BlackSwan ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |