|
|
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 |
1993 |
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 |
2659 |
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 |
2606 |
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 |
2863 |
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 |
2137 |
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 |
2174 |
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 |
4062 |
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 |
1698 |
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 |
2058 |
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 |
1642 |
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 |
7174 |
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 |
1990 |
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 |
1799 |
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 |
2486 |
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 |
17671 |
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 |
4246 |
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 |
6744 |
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 |
2921 |
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 |
3200 |
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 |
1996 |
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 |
2746 |
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 |
2730 |
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 |
3306 |
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 |
1767 |
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 |
2734 |
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 |
2005 |
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 |
4561 |
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 |
1731 |
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 |
10968 |
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 |
3358 |
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 |
1819 |
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 |
6355 |
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 |
4680 |
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 |
5105 |
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 |
3594 |
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 |
16076 |
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 |
3119 |
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 |
2377 |
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 |
4271 |
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 |
3358 |
Sun, 28 March 2010 06:16 By: Kevin Meade ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |