OraFAQ Forum: Performance Tuning

Home » RDBMS Server » Performance Tuning

Please read the OraFAQ Forum Guide before posting.

Please contribute good answers to the wiki.

Show: Today's Messages :: Unanswered Messages :: Polls :: Message Navigator

Topic	Replies	Views	Last message
Issue with bulk collect over a db link oracle,10.2.0.3,HP-UX By: vishith13 on Thu, 23 February 2012	4	3170	Fri, 24 February 2012 06:03 By: vishith
Function Based Index is not being used Oracle 10.2.0.4 By: orapratap on Wed, 22 February 2012	7	2581	Thu, 23 February 2012 03:45 By: Roachcoach
how to find top query running on a table Oracle EE 10.2.0.3 Linux 64-bit By: freak_vss on Sun, 19 February 2012	2	3124	Mon, 20 February 2012 13:16 By: LNossov
Oracle parameters - processes, session, and transactions Oracle 11.2.0.1 By: djmartin on Mon, 13 February 2012	7	17528	Sun, 19 February 2012 23:07 By: djmartin
application is slow? what to check immediately oracle 11.2.0.1 RAC of two nodes,solaris10 By: janakors on Thu, 16 February 2012	4	1834	Sat, 18 February 2012 16:04 By: LNossov
need help to understand this execution plan oracle 10.2.0.5 By: n2fontenay on Mon, 13 February 2012	5	2077	Thu, 16 February 2012 10:51 By: S.Rajaram
Help - dropping partitions(2 Merged) Oracle, 10.2.0.4 By: sathik on Fri, 10 February 2012	7	3436	Thu, 16 February 2012 10:45 By: S.Rajaram
Handling NULL values in the Database Oracle 10.2.0.4 By: orapratap on Mon, 06 February 2012	3	3348	Fri, 10 February 2012 19:56 By: rleishman
Options for querying on the skewed data Oracle 10.2.0.4 on RHEL By: orapratap on Fri, 10 February 2012	3	2954	Fri, 10 February 2012 19:42 By: rleishman
Query Rewrite Oracle 10g, windows By: oraranjangmailcom on Tue, 07 February 2012	13	3055	Wed, 08 February 2012 05:14 By: cookiemonster
comparing SQL plans between 2 DB's Oracle 11203 Solaris 2.10 By: BeefStu on Fri, 03 February 2012	4	3306	Mon, 06 February 2012 09:05 By: BeefStu
What info should be gathered while doing sql tuning? Oracle 10.2.0.4, Redhat Enterprise Linux 5 64bit By: snowball on Tue, 10 January 2012	19	4092	Sat, 04 February 2012 02:14 By: snowball
Materialized view to improve Search queries Oracle 10g R2 on RHEL By: orapratap on Tue, 31 January 2012	2	2584	Wed, 01 February 2012 10:43 By: orapratap
How to find Literal SQL statement Oracle 10g Hp-UX By: pokhraj_d on Mon, 30 January 2012	4	4277	Mon, 30 January 2012 05:27 By: LNossov
Performance tuning in View Oracle By: bamugan81 on Mon, 30 January 2012	1	1695	Mon, 30 January 2012 04:07 By: cookiemonster
scripts on tablespaces,Indexes and DBJobs linux 4.0 with oracle 10g By: faiz123 on Thu, 19 January 2012	4	2108	Sun, 29 January 2012 02:53 By: John Watson
Subquery Transformation 11gR2, win-xp By: Rahm on Fri, 27 January 2012	14	2848	Fri, 27 January 2012 23:53 By: Michel Cadot
Is it possible to display alternate execution plans ? 11gR2, win-xp By: Rahm on Fri, 27 January 2012	1	1428	Fri, 27 January 2012 09:31 By: BlackSwan
Tune Query or Modify Index or Partition By: p2004 on Fri, 27 January 2012	1	1628	Fri, 27 January 2012 02:29 By: Michel Cadot
PLSQL and related cursors generated in v$sql 10gr2 By: nikko on Thu, 26 January 2012	1	1502	Thu, 26 January 2012 03:01 By: Michel Cadot
Can anyone help to do some tuning on ORACLE 9i? ORACLE 9i By: cooldude_no1 on Wed, 25 January 2012	1	1375	Wed, 25 January 2012 04:28 By: Michel Cadot
Primary key - unusable Oracle - 10g By: sathik on Fri, 20 January 2012	10	7104	Tue, 24 January 2012 05:34 By: Michel Cadot
Query execution path 11gR2 Linux By: gkrishn on Sat, 21 January 2012	8	4651	Sun, 22 January 2012 02:56 By: John Watson
CBO Query re-write Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit, HP-UX By: manubatham20 on Sat, 21 January 2012	2	1996	Sun, 22 January 2012 00:40 By: Michel Cadot
Please help me tune this sql Oracle 10g By: manoveg on Tue, 18 January 2011	9	4500	Sat, 21 January 2012 09:18 By: Michel Cadot
Problem Index with IN Statement (merged) Oracle 10g Enterprise Edition Release 10.2.0.1.0, Solaris 10 By: MarkusW on Wed, 18 January 2012	12	2119	Fri, 20 January 2012 01:17 By: Michel Cadot
Undo space By: jack55 on Sun, 15 January 2012	3	2169	Thu, 19 January 2012 07:01 By: Michel Cadot
Join with 30 tables Sun, Oracle 10 By: RMSoares on Mon, 16 January 2012	15	3488	Thu, 19 January 2012 02:57 By: RMSoares
SQl ID from peoplesoft process Oracle 10g Hp-UX By: pokhraj_d on Wed, 18 January 2012	5	2136	Wed, 18 January 2012 03:51 By: Michel Cadot
finding changed sql plans By: BeefStu on Tue, 17 January 2012	4	2513	Tue, 17 January 2012 15:09 By: LNossov
AWR report windows By: sandeip on Tue, 17 January 2012	6	2945	Tue, 17 January 2012 07:07 By: Michel Cadot
Best Practices to optimize a FAST REFRESH Materialized View? Oracle 11g By: tsteinmaurer on Mon, 16 January 2012	2	6856	Tue, 17 January 2012 05:53 By: rleishman
Wait events for a query Oracle 10.2.0.4 By: himabija on Tue, 17 January 2012	1	1032	Tue, 17 January 2012 04:52 By: Michel Cadot
Oracle10g Standard Edition on Linux machine SGA Tuning By: gauravsrivastava on Mon, 16 January 2012	5	2188	Mon, 16 January 2012 02:17 By: himabija
truncate table Linux 2.6.18-92.1.13.el5 By: dba_7722 on Fri, 13 January 2012	4	1688	Fri, 13 January 2012 04:50 By: Michel Cadot
Query running more time Oracle 11g standard Version By: sank on Mon, 09 January 2012	4	4197	Tue, 10 January 2012 14:50 By: sank
HTML AWR Report Red Hat Linux 5.3 and oracle 10g By: morad_dba on Tue, 10 January 2012	9	11847	Tue, 10 January 2012 09:13 By: ramoradba
Explain Plan Oracle 10g Hp-UX By: pokhraj_d on Thu, 05 January 2012	3	2456	Thu, 05 January 2012 06:05 By: rleishman
Query taking long time on MVs Oracle 11g, UNIX By: ind9 on Thu, 29 December 2011	4	1951	Wed, 04 January 2012 12:00 By: LNossov
Same query using different execution plans, why?? Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 By: manubatham20 on Mon, 26 December 2011	8	2976	Wed, 04 January 2012 09:15 By: LNossov