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
delete no of records By: prashant_ora on Tue, 03 August 2010	14	3002	Wed, 04 August 2010 00:07 By: BlackSwan
Query doesn't use Materialized View Oracle 10g By: bustaliz on Tue, 03 August 2010	1	1728	Tue, 03 August 2010 10:19 By: Michel Cadot
run explain plan syntax , show error window series By: JADYCHEN on Tue, 03 August 2010	4	7236	Tue, 03 August 2010 02:44 By: JADYCHEN
Need help with shared pool sizing 8.0.6, windows 2000 server By: ultgnp on Mon, 02 August 2010	10	2125	Mon, 02 August 2010 22:13 By: rahulvb
Query Oracle 9i By: ramesh55.sse on Sun, 01 August 2010	4	2177	Mon, 02 August 2010 00:46 By: rahulvb
Table Partition Oracle 9i By: amit_kiran on Fri, 30 July 2010	5	2473	Sat, 31 July 2010 05:32 By: michael_bialik
An observation Oracle 10.2.0.3 By: Its_me_ved on Fri, 30 July 2010	14	3224	Fri, 30 July 2010 22:01 By: rleishman
Which application (software, utility) do I choose for report? Windows platform, Oracle 9,10,11 By: trantuananh24hg on Wed, 28 July 2010	4	2004	Thu, 29 July 2010 03:25 By: trantuananh24hg
Cost of a query Oracle 10.2.0.3 By: Its_me_ved on Wed, 28 July 2010	3	2349	Wed, 28 July 2010 10:30 By: Its_me_ved
Tuning Schemas Oracle, 10.2.0.2.0 , unix By: Database admin on Tue, 27 July 2010	1	1672	Tue, 27 July 2010 08:25 By: rahulvb
REDO LOG GENERTION By: prashant_ora on Mon, 19 July 2010	17	4968	Mon, 26 July 2010 02:59 By: hkchital
low cost and high cpu cost By: prashant_ora on Fri, 23 July 2010	17	7128	Sun, 25 July 2010 22:43 By: rleishman
SETTING PARAMETER By: prashant_ora on Fri, 23 July 2010	2	1775	Fri, 23 July 2010 12:33 By: prashant_ora
sql hint By: prashant_ora on Wed, 21 July 2010	8	3266	Fri, 23 July 2010 00:18 By: rleishman
CPU used by user SQLs 11g RHEL 5 By: asangapradeep on Thu, 22 July 2010	2	1931	Thu, 22 July 2010 15:03 By: Michel Cadot
index on foreign keys By: prashant_ora on Thu, 22 July 2010	17	3412	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	4025	Thu, 22 July 2010 10:15 By: prashant_ora
reduce the elapsed time By: akilabaskaran on Tue, 22 June 2010	9	2184	Thu, 22 July 2010 08:25 By: prashant_ora
index monitoring By: prashant_ora on Thu, 22 July 2010	4	1895	Thu, 22 July 2010 07:47 By: John Watson
INVISIBLE INDEX-11g By: akilabaskaran on Thu, 22 July 2010	9	5998	Thu, 22 July 2010 05:27 By: akilabaskaran
query writing By: prashant_ora on Thu, 22 July 2010	1	1348	Thu, 22 July 2010 05:09 By: cookiemonster
Explain Plan Analysis - Execution ordering Oralce 11g, CentOS5 By: Vackar on Wed, 21 July 2010	15	6491	Thu, 22 July 2010 03:59 By: Vackar
optimised query By: prashant_ora on Thu, 22 July 2010	1	1375	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	2883	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	2852	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	1871	Thu, 22 July 2010 01:50 By: akj_dk
Query Optimization 11g By: prax_14 on Mon, 19 July 2010	13	4537	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	7248	Tue, 20 July 2010 04:28 By: kvelrajan@gmail.com
Oracle server Tuning 11g By: prax_14 on Tue, 13 July 2010	8	3389	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	2286	Mon, 19 July 2010 01:10 By: hkchital
Oracle Fragmentation script By: prashant_ora on Sun, 18 July 2010	23	12675	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	6015	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	10617	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	1368	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	4315	Sun, 11 July 2010 00:18 By: rleishman
Query Performance trace Oracle 10g, By: freakabhi on Sat, 10 July 2010	1	1534	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	2621	Fri, 09 July 2010 01:44 By: Kevin Meade
parallel DDL oracle 10g By: arunprasad_bh on Thu, 08 July 2010	3	2497	Thu, 08 July 2010 10:46 By: arunprasad_bh
excess redo generation By: dalu on Thu, 01 July 2010	3	3060	Tue, 06 July 2010 21:55 By: Kevin Meade
Description of Events Windows Server 2003 By: saharookiedba on Tue, 28 July 2009	2	2554	Tue, 06 July 2010 04:19 By: Michel Cadot