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	18107	Thu, 05 August 2010 04:09 By: cookiemonster
Difference between cost and bytes 10g By: soraociscocom on Wed, 04 August 2010	1	4318	Wed, 04 August 2010 01:40 By: BlackSwan
delete no of records By: prashant_ora on Tue, 03 August 2010	14	3553	Wed, 04 August 2010 00:07 By: BlackSwan
Query doesn't use Materialized View Oracle 10g By: bustaliz on Tue, 03 August 2010	1	2024	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	7751	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	2675	Mon, 02 August 2010 22:13 By: rahulvb
Query Oracle 9i By: ramesh55.sse on Sun, 01 August 2010	4	2560	Mon, 02 August 2010 00:46 By: rahulvb
Table Partition Oracle 9i By: amit_kiran on Fri, 30 July 2010	5	3761	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	3858	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	2443	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	3222	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	2188	Tue, 27 July 2010 08:25 By: rahulvb
REDO LOG GENERTION By: prashant_ora on Mon, 19 July 2010	17	5956	Mon, 26 July 2010 02:59 By: hkchital
low cost and high cpu cost By: prashant_ora on Fri, 23 July 2010	17	8105	Sun, 25 July 2010 22:43 By: rleishman
SETTING PARAMETER By: prashant_ora on Fri, 23 July 2010	2	2373	Fri, 23 July 2010 12:33 By: prashant_ora
sql hint By: prashant_ora on Wed, 21 July 2010	8	3819	Fri, 23 July 2010 00:18 By: rleishman
CPU used by user SQLs 11g RHEL 5 By: asangapradeep on Thu, 22 July 2010	2	2281	Thu, 22 July 2010 15:03 By: Michel Cadot
index on foreign keys By: prashant_ora on Thu, 22 July 2010	17	4223	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	4501	Thu, 22 July 2010 10:15 By: prashant_ora
reduce the elapsed time By: akilabaskaran on Tue, 22 June 2010	9	2617	Thu, 22 July 2010 08:25 By: prashant_ora
index monitoring By: prashant_ora on Thu, 22 July 2010	4	2255	Thu, 22 July 2010 07:47 By: John Watson
INVISIBLE INDEX-11g By: akilabaskaran on Thu, 22 July 2010	9	6378	Thu, 22 July 2010 05:27 By: akilabaskaran
query writing By: prashant_ora on Thu, 22 July 2010	1	1783	Thu, 22 July 2010 05:09 By: cookiemonster
Explain Plan Analysis - Execution ordering Oralce 11g, CentOS5 By: Vackar on Wed, 21 July 2010	15	7157	Thu, 22 July 2010 03:59 By: Vackar
optimised query By: prashant_ora on Thu, 22 July 2010	1	1846	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	4071	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	3470	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	2153	Thu, 22 July 2010 01:50 By: akj_dk
Query Optimization 11g By: prax_14 on Mon, 19 July 2010	13	5266	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	7755	Tue, 20 July 2010 04:28 By: kvelrajan@gmail.com
Oracle server Tuning 11g By: prax_14 on Tue, 13 July 2010	8	3891	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	2711	Mon, 19 July 2010 01:10 By: hkchital
Oracle Fragmentation script By: prashant_ora on Sun, 18 July 2010	23	13552	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	6482	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	11003	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	1633	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	4757	Sun, 11 July 2010 00:18 By: rleishman
Query Performance trace Oracle 10g, By: freakabhi on Sat, 10 July 2010	1	2071	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	3028	Fri, 09 July 2010 01:44 By: Kevin Meade
parallel DDL oracle 10g By: arunprasad_bh on Thu, 08 July 2010	3	3328	Thu, 08 July 2010 10:46 By: arunprasad_bh