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
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	18083	Thu, 05 August 2010 04:09 By: cookiemonster
Difference between cost and bytes 10g By: soraociscocom on Wed, 04 August 2010	1	4299	Wed, 04 August 2010 01:40 By: BlackSwan
delete no of records By: prashant_ora on Tue, 03 August 2010	14	3519	Wed, 04 August 2010 00:07 By: BlackSwan
Query doesn't use Materialized View Oracle 10g By: bustaliz on Tue, 03 August 2010	1	2007	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	7707	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	2646	Mon, 02 August 2010 22:13 By: rahulvb
Query Oracle 9i By: ramesh55.sse on Sun, 01 August 2010	4	2541	Mon, 02 August 2010 00:46 By: rahulvb
Table Partition Oracle 9i By: amit_kiran on Fri, 30 July 2010	5	3745	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	3832	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	2426	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	3207	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	2170	Tue, 27 July 2010 08:25 By: rahulvb
REDO LOG GENERTION By: prashant_ora on Mon, 19 July 2010	17	5905	Mon, 26 July 2010 02:59 By: hkchital
low cost and high cpu cost By: prashant_ora on Fri, 23 July 2010	17	8027	Sun, 25 July 2010 22:43 By: rleishman
SETTING PARAMETER By: prashant_ora on Fri, 23 July 2010	2	2353	Fri, 23 July 2010 12:33 By: prashant_ora
sql hint By: prashant_ora on Wed, 21 July 2010	8	3801	Fri, 23 July 2010 00:18 By: rleishman
CPU used by user SQLs 11g RHEL 5 By: asangapradeep on Thu, 22 July 2010	2	2266	Thu, 22 July 2010 15:03 By: Michel Cadot
index on foreign keys By: prashant_ora on Thu, 22 July 2010	17	4205	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	4479	Thu, 22 July 2010 10:15 By: prashant_ora
reduce the elapsed time By: akilabaskaran on Tue, 22 June 2010	9	2591	Thu, 22 July 2010 08:25 By: prashant_ora
index monitoring By: prashant_ora on Thu, 22 July 2010	4	2238	Thu, 22 July 2010 07:47 By: John Watson
INVISIBLE INDEX-11g By: akilabaskaran on Thu, 22 July 2010	9	6348	Thu, 22 July 2010 05:27 By: akilabaskaran
query writing By: prashant_ora on Thu, 22 July 2010	1	1764	Thu, 22 July 2010 05:09 By: cookiemonster
Explain Plan Analysis - Execution ordering Oralce 11g, CentOS5 By: Vackar on Wed, 21 July 2010	15	7128	Thu, 22 July 2010 03:59 By: Vackar
optimised query By: prashant_ora on Thu, 22 July 2010	1	1832	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	4055	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	3424	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	2136	Thu, 22 July 2010 01:50 By: akj_dk
Query Optimization 11g By: prax_14 on Mon, 19 July 2010	13	5248	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	7710	Tue, 20 July 2010 04:28 By: kvelrajan@gmail.com
Oracle server Tuning 11g By: prax_14 on Tue, 13 July 2010	8	3869	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	2687	Mon, 19 July 2010 01:10 By: hkchital
Oracle Fragmentation script By: prashant_ora on Sun, 18 July 2010	23	13457	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	6461	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	10977	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	1620	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	4742	Sun, 11 July 2010 00:18 By: rleishman
Query Performance trace Oracle 10g, By: freakabhi on Sat, 10 July 2010	1	2058	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	2999	Fri, 09 July 2010 01:44 By: Kevin Meade
parallel DDL oracle 10g By: arunprasad_bh on Thu, 08 July 2010	3	3305	Thu, 08 July 2010 10:46 By: arunprasad_bh