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 :: Show Polls :: Message Navigator

Topic	Replies	Views	Last message
Cost of a query Oracle 10.2.0.3 By: Its_me_ved on Wed, 28 July 2010	3	488	Wed, 28 July 2010 10:30 By: Its_me_ved
Tuning Schemas Oracle, 10.2.0.2.0 , unix By: balaji14 on Tue, 27 July 2010	1	468	Tue, 27 July 2010 08:25 By: rahulvb
REDO LOG GENERTION By: prashant_ora on Mon, 19 July 2010	17	760	Mon, 26 July 2010 02:59 By: hkchital
low cost and high cpu cost By: prashant_ora on Fri, 23 July 2010	17	1108	Sun, 25 July 2010 22:43 By: rleishman
SETTING PARAMETER By: prashant_ora on Fri, 23 July 2010	2	511	Fri, 23 July 2010 12:33 By: prashant_ora
sql hint By: prashant_ora on Wed, 21 July 2010	8	681	Fri, 23 July 2010 00:18 By: rleishman
CPU used by user SQLs 11g RHEL 5 By: asangapradeep on Thu, 22 July 2010	2	488	Thu, 22 July 2010 15:03 By: Michel Cadot
index on foreign keys By: prashant_ora on Thu, 22 July 2010	17	528	Thu, 22 July 2010 10:53 By: John Watson
Delete statement is taking more time for execution By: akash.nathile on Tue, 09 March 2010	4	1654	Thu, 22 July 2010 10:15 By: prashant_ora
reduce the elapsed time By: akilabaskaran on Tue, 22 June 2010	9	464	Thu, 22 July 2010 08:25 By: prashant_ora
index monitoring By: prashant_ora on Thu, 22 July 2010	4	724	Thu, 22 July 2010 07:47 By: John Watson
INVISIBLE INDEX-11g By: akilabaskaran on Thu, 22 July 2010	9	1033	Thu, 22 July 2010 05:27 By: akilabaskaran
query writing By: prashant_ora on Thu, 22 July 2010	1	412	Thu, 22 July 2010 05:09 By: cookiemonster
Explain Plan Analysis - Execution ordering Oralce 11g, CentOS5 By: Vackar on Wed, 21 July 2010	15	1351	Thu, 22 July 2010 03:59 By: Vackar
optimised query By: prashant_ora on Thu, 22 July 2010	1	440	Thu, 22 July 2010 03:51 By: Michel Cadot
What is the use of DBM STATS PACKAGE? Oracle Database 10.2.0.1 on AIX 5.3 By: vcm643 on Wed, 21 July 2010	4	760	Thu, 22 July 2010 03:16 By: trantuananh24hg
Hint is not working properly 9.2.0.8, HP-UX By: indrajit2002 on Wed, 14 July 2010	14	573	Thu, 22 July 2010 02:29 By: indrajit2002
performance of cursor embedded in select Oracle 10, sqldeveloper 2.1.0.63 By: akj_dk on Wed, 21 July 2010	2	602	Thu, 22 July 2010 01:50 By: akj_dk
Query Optimization 11g By: prax_14 on Mon, 19 July 2010	13	951	Tue, 20 July 2010 22:58 By: rleishman
High CPU Cost and low optimizer cost Oracle 10G /Linux By: dhanamukesh on Thu, 22 January 2009	10	3360	Tue, 20 July 2010 04:28 By: kvelrajan@gmail.com
Oracle server Tuning 11g By: prax_14 on Tue, 13 July 2010	8	878	Mon, 19 July 2010 18:13 By: Kevin Meade
points to ponder while having Index against any column Oracle 10.X By: khurramforum on Thu, 15 July 2010	3	457	Mon, 19 July 2010 01:10 By: hkchital
Oracle Fragmentation script By: prashant_ora on Sun, 18 July 2010	23	4732	Mon, 19 July 2010 00:58 By: Michel Cadot
TRACE SESSION USING DBMS_APPLICATION_INFO ORACLE 10G AND JAVA ON WEBLOGIC AND JBOSS By: prashant_ora on Sun, 18 July 2010	11	2357	Sun, 18 July 2010 12:19 By: BlackSwan
auto execute of job_error_ORA-12012,ORA-04031 oracle,10.2.0.4.0,Linux By: sathik on Tue, 13 July 2010	7	4818	Wed, 14 July 2010 01:43 By: Michel Cadot
Tools for Database Tuning v/s Instance Tuning Oracle 10g, 11g By: ora_dba_2000 on Mon, 12 July 2010	1	464	Mon, 12 July 2010 20:54 By: rahulvb
SQL statment running for ever Oracle server 11g Enterprise Edition Release 11.1.0.7.0 - 64bit , Linux x86_64 GNU/Linux By: samiraly on Sat, 10 July 2010	9	792	Sun, 11 July 2010 00:18 By: rleishman
Query Performance trace Oracle 10g, By: freakabhi on Sat, 10 July 2010	1	520	Sat, 10 July 2010 11:54 By: BlackSwan
SQL Query Help Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bi By: marlon_loyolite on Thu, 08 July 2010	7	640	Fri, 09 July 2010 01:44 By: Kevin Meade
parallel DDL oracle 10g By: arunprasad_bh on Thu, 08 July 2010	3	1152	Thu, 08 July 2010 10:46 By: arunprasad_bh
excess redo generation By: dalu on Thu, 01 July 2010	3	1232	Tue, 06 July 2010 21:55 By: Kevin Meade
Description of Events Windows Server 2003 By: saharookiedba on Tue, 28 July 2009	2	1376	Tue, 06 July 2010 04:19 By: Michel Cadot
need to know about shared pool sizing 8.1.7,win 2003 server By: ultgnp on Mon, 05 July 2010	1	430	Mon, 05 July 2010 01:32 By: BlackSwan
Logwriter processes Hp Unix,11.3 By: sekar52 on Fri, 02 July 2010	3	1125	Fri, 02 July 2010 04:32 By: Michel Cadot
parition of table 10.2.0.4 By: ankush_chawla on Mon, 28 June 2010	2	487	Mon, 28 June 2010 08:09 By: Michel Cadot
select partition table with non partition key condition By: ekopur on Sat, 26 June 2010	3	1325	Sat, 26 June 2010 09:20 By: Michel Cadot
Help proving a database is slow 10.2 / Solaris By: rleishman on Tue, 01 June 2010	16	2192	Sat, 26 June 2010 05:13 By: rleishman
Pin Sql query in shared pool By: paradoxkhan on Fri, 25 June 2010	3	2020	Fri, 25 June 2010 08:02 By: cookiemonster
need help tuning this query 8.1.6, win2000 server By: ultgnp on Sun, 20 June 2010	17	689	Wed, 23 June 2010 08:36 By: ultgnp
How to tune order by clause without changing sort area Oracle 9i,9.2.0.6.0,Windows XP By: rajatratewal on Thu, 01 May 2008	10	2715	Wed, 23 June 2010 03:36 By: Kevin Meade