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
Partitions Oracle 11g By: ravi214u on Thu, 05 August 2010	10	3796	Thu, 05 August 2010 21:34 By: rahulvb
Force Subquery To Use index Oracle 11g, CentOS 5 By: Vackar on Thu, 05 August 2010	5	3879	Thu, 05 August 2010 05:34 By: Vackar
Performance issue - Views inside a view Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 By: dharmspeakz on Tue, 03 August 2010	16	19507	Thu, 05 August 2010 04:09 By: cookiemonster
Difference between cost and bytes 10g By: soraociscocom on Wed, 04 August 2010	1	4715	Wed, 04 August 2010 01:40 By: BlackSwan
delete no of records By: prashant_ora on Tue, 03 August 2010	14	4695	Wed, 04 August 2010 00:07 By: BlackSwan
Query doesn't use Materialized View Oracle 10g By: bustaliz on Tue, 03 August 2010	1	2428	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	8588	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	3687	Mon, 02 August 2010 22:13 By: rahulvb
Query Oracle 9i By: ramesh55.sse on Sun, 01 August 2010	4	3113	Mon, 02 August 2010 00:46 By: rahulvb
Table Partition Oracle 9i By: amit_kiran on Fri, 30 July 2010	5	4494	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	5058	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	3062	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	3773	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	2620	Tue, 27 July 2010 08:25 By: rahulvb
REDO LOG GENERTION By: prashant_ora on Mon, 19 July 2010	17	7606	Mon, 26 July 2010 02:59 By: hkchital
low cost and high cpu cost By: prashant_ora on Fri, 23 July 2010	17	10452	Sun, 25 July 2010 22:43 By: rleishman
SETTING PARAMETER By: prashant_ora on Fri, 23 July 2010	2	2817	Fri, 23 July 2010 12:33 By: prashant_ora
sql hint By: prashant_ora on Wed, 21 July 2010	8	4703	Fri, 23 July 2010 00:18 By: rleishman
CPU used by user SQLs 11g RHEL 5 By: asangapradeep on Thu, 22 July 2010	2	2784	Thu, 22 July 2010 15:03 By: Michel Cadot
index on foreign keys By: prashant_ora on Thu, 22 July 2010	17	5623	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	5323	Thu, 22 July 2010 10:15 By: prashant_ora
reduce the elapsed time By: akilabaskaran on Tue, 22 June 2010	9	3586	Thu, 22 July 2010 08:25 By: prashant_ora
index monitoring By: prashant_ora on Thu, 22 July 2010	4	2907	Thu, 22 July 2010 07:47 By: John Watson
INVISIBLE INDEX-11g By: akilabaskaran on Thu, 22 July 2010	9	7318	Thu, 22 July 2010 05:27 By: akilabaskaran
query writing By: prashant_ora on Thu, 22 July 2010	1	2130	Thu, 22 July 2010 05:09 By: cookiemonster
Explain Plan Analysis - Execution ordering Oralce 11g, CentOS5 By: Vackar on Wed, 21 July 2010	15	8499	Thu, 22 July 2010 03:59 By: Vackar
optimised query By: prashant_ora on Thu, 22 July 2010	1	2205	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	4737	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	4929	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	2650	Thu, 22 July 2010 01:50 By: akj_dk
Query Optimization 11g By: prax_14 on Mon, 19 July 2010	13	6713	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	9247	Tue, 20 July 2010 04:28 By: kvelrajan@gmail.com
Oracle server Tuning 11g By: prax_14 on Tue, 13 July 2010	8	5043	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	3280	Mon, 19 July 2010 01:10 By: hkchital
Oracle Fragmentation script By: prashant_ora on Sun, 18 July 2010	23	15701	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	7569	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	11951	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	2033	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	5730	Sun, 11 July 2010 00:18 By: rleishman
Query Performance trace Oracle 10g, By: freakabhi on Sat, 10 July 2010	1	2460	Sat, 10 July 2010 11:54 By: BlackSwan