|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Sql Trace and tkprof |
1 |
1885 |
Fri, 14 May 2010 01:13 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) |
|
Tune sql query oracle 10.2.0.4 |
5 |
2532 |
Fri, 14 May 2010 00:45 By: nitinkrmishra ![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) |
|
Function based index Oracle, 10g, Windows Server 2003 |
8 |
2460 |
Thu, 13 May 2010 12:07 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) |
|
Help required to tune a query Oralce,9.2.0.8.0,sun solaris 5.2 By: sathik on Wed, 05 May 2010 |
13 |
2707 |
Thu, 13 May 2010 04:02 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) |
|
Consistent gets reduced but Elapsed time increased.. please help. |
4 |
2003 |
Wed, 12 May 2010 08:55 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) |
|
performance problem oracle 10g, windows By: klinki on Thu, 06 May 2010 |
4 |
2050 |
Tue, 11 May 2010 01:37 By: klinki ![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) |
![icon4.gif](/forum/images/message_icons/icon4.gif) |
Optimisation Strategies Oracle 11g Enterprise R1 By: dsub42 on Fri, 07 May 2010 |
26 |
3856 |
Mon, 10 May 2010 01:25 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) |
|
AWR report 10.2.0.4 |
1 |
1581 |
Thu, 06 May 2010 07:12 By: John Watson ![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 Oracle, 10g, Windows Server 2003 |
4 |
1942 |
Wed, 05 May 2010 03:07 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) |
|
simultaneous query processing 11g,solaris (urgent) |
1 |
1514 |
Mon, 03 May 2010 03: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) |
|
Interpreting tuning task Report Oracle 10.2.0.4,AIX By: dbcop on Wed, 28 April 2010 |
4 |
7001 |
Sun, 02 May 2010 05:58 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) |
|
execution time versus plan cost 10.2.0.4 |
2 |
1876 |
Fri, 30 April 2010 07:14 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) |
|
Updating a huge table of size 750Gb Oracle 10g, Linux |
1 |
1679 |
Fri, 30 April 2010 00: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) |
|
alter table to add list partition oracle 10g |
1 |
2362 |
Thu, 29 April 2010 02:37 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) |
|
awr report |
3 |
17469 |
Wed, 28 April 2010 01:31 By: zodiacsom ![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 SQL Tuning Advisor 10.2.0.4 |
3 |
4082 |
Tue, 27 April 2010 01:03 By: John Watson ![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 SQL TUNE Problem Oracle 10.2.0.4/AIX 5 By: dbcop on Mon, 26 April 2010 |
1 |
6583 |
Mon, 26 April 2010 10:47 By: mherlindo ![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 having not exists clause. Oracle Database 10g Release 10.2.0.4.0 - 64bit Production. |
3 |
2747 |
Thu, 22 April 2010 04:55 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) |
|
Tune sql query 10.2.0.4 |
9 |
2995 |
Wed, 21 April 2010 06:29 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) |
|
Analse tables Oracle 9i ,AIx 5.2 |
3 |
1838 |
Tue, 20 April 2010 07:57 By: soundar ![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) |
|
Parsing of sql-statements Oracle rdbms / 11.2.0.1.0 / Linux / FC 12 32 bit |
5 |
2573 |
Sun, 18 April 2010 08:29 By: mnitu ![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) |
|
Compare Query Performance Oracle 10.2.0.4.0 on windows and HP-UX |
3 |
2561 |
Fri, 16 April 2010 01:04 By: hkchital ![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 query different explain plan 11g ,solaris |
2 |
3170 |
Wed, 14 April 2010 09:01 By: mjohanss ![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 Logic (merged by CM) Oracle9i |
1 |
1639 |
Wed, 14 April 2010 05:47 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) |
|
Using 9i stored outlines by 11g SPM 11g , solaris9 |
3 |
2586 |
Mon, 12 April 2010 13:09 By: John Watson ![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 snapshots oracle 10g,unix |
3 |
1851 |
Fri, 09 April 2010 14: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) |
|
hash join vs nested loops 11g |
3 |
4387 |
Thu, 08 April 2010 08:02 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) |
|
Using SQL Tuning Advisor Interactively on already running task/job/batch |
2 |
1606 |
Thu, 08 April 2010 04:51 By: samg4ug ![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) |
|
Resolving Latch Free Waits Oracle 9.2.0.6.0 and 9.2.0.8.0 on HP-UX |
12 |
10643 |
Wed, 07 April 2010 05:44 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) |
|
Please help me in tuning below query |
8 |
3220 |
Wed, 07 April 2010 04:44 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 benchmarking Oracle 10gR2 RHEL 4 |
1 |
1702 |
Wed, 07 April 2010 03:23 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 tuning with date comparison oracle 10g |
18 |
6129 |
Fri, 02 April 2010 02:05 By: mnitu ![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) |
|
Inline View Oracle 10G |
6 |
4515 |
Thu, 01 April 2010 08:02 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 in Cardinality, Cost, Temp Space Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bi |
16 |
4906 |
Wed, 31 March 2010 04:44 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) |
|
Missing Index but strange column Oracle 10.2.0.1, Sun Solaris 10 |
4 |
3445 |
Wed, 31 March 2010 04:07 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) |
|
Full Table Scan Instead of Index Usage Oracle 10g |
34 |
15701 |
Tue, 30 March 2010 07: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) |
|
11g- query Performance issue 11g,Release 11.1.0.6.0,windowsXP |
4 |
2980 |
Mon, 29 March 2010 02:14 By: vs0037476 ![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 fetching time before hand 11g,solaris9 |
3 |
2228 |
Sun, 28 March 2010 08:17 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) |
|
materialize view 11g, solaris9 |
13 |
4027 |
Sun, 28 March 2010 06:29 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) |
|
sql tuning 11g,Solaris 9 |
6 |
3144 |
Sun, 28 March 2010 06:16 By: Kevin Meade ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |