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
Deadlock interpretation Oracle 10g By: vipull.sayal on Wed, 23 December 2009	2	3113	Wed, 23 December 2009 15:59 By: vipull.sayal
oracle instance performance oralce 9i , Linux By: chuikingman on Tue, 22 December 2009	1	2084	Tue, 22 December 2009 05:15 By: Michel Cadot
Update statement query tuning 9i By: shiva_jm on Mon, 21 December 2009	7	3583	Tue, 22 December 2009 01:49 By: rleishman
Memory Notification: Library Cache Object loaded into SGA oracle 10g By: gir_sat on Mon, 21 December 2009	2	15930	Mon, 21 December 2009 08:02 By: Michel Cadot
Problem in understanding the autotrace output exectution plan and statistics 10.2.0.4, RHEL4 By: spabolu on Thu, 17 December 2009	3	2998	Sun, 20 December 2009 20:52 By: rleishman
How to configure Oracle on Two Servers in Hot Redundant mode Oracle 10g on Windows Server 2003 By: myinvention99 on Thu, 17 December 2009	1	2605	Fri, 18 December 2009 09:09 By: LKBrwn_DBA
sql tuning help oracle 10g,1,xp By: krajasekhar.v on Fri, 18 December 2009	8	3264	Fri, 18 December 2009 05:39 By: _jum
Why Oracle 10g slows down Copmuter after few days Oracle 10g 10.2.0.1.0 By: myinvention99 on Sat, 21 November 2009	12	5725	Thu, 17 December 2009 15:34 By: myinvention99
Queries in oracle indexing oracle, 10.1.0.5.0, sun solaris By: sathik on Thu, 17 December 2009	4	2881	Thu, 17 December 2009 10:53 By: BlackSwan
select clause 10g By: kish_ulike on Thu, 17 December 2009	2	2322	Thu, 17 December 2009 00:34 By: pablolee
grants running extemely slow Oracle 10.2.0.3 on Linux By: king303 on Tue, 15 December 2009	9	3966	Wed, 16 December 2009 02:55 By: king303
Cost of a Rollback Oracle 10.2.0.4, Windows 2003 server By: Arokh on Fri, 11 December 2009	3	1994	Fri, 11 December 2009 13:48 By: Arokh
Query to be restructured for performance gain Oracle 10G By: bholeuday on Fri, 11 December 2009	2	2291	Fri, 11 December 2009 10:50 By: BlackSwan
APPEND hint in Rule and Cost based optimizer oracle 10g By: ganesh104 on Thu, 10 December 2009	5	3751	Thu, 10 December 2009 19:35 By: rleishman
require to tune a sql query oracle,10.1.0.4.0,Sun solaris 5.10 By: sathik on Wed, 09 December 2009	10	4338	Thu, 10 December 2009 05:58 By: JRowbottom
Index Partitioning local or global or both?? By: nsingh49 on Thu, 19 November 2009	9	3939	Wed, 09 December 2009 06:00 By: rleishman
Need to tune a Query - xjd By: marlon_loyolite on Thu, 03 December 2009	6	3855	Wed, 09 December 2009 00:53 By: michael_bialik
Unindexing foreign key Oracle 10.2G By: wakula on Tue, 08 December 2009	1	1874	Tue, 08 December 2009 06:37 By: JRowbottom
Horizontal vs Vertical data table design Oracle 10.2G By: wakula on Mon, 30 November 2009	6	5329	Tue, 08 December 2009 02:41 By: JRowbottom
Buffer pool Hit% more than 100% oracle 10g, 10.2, soalaris By: DBA_SangramKeshari on Mon, 16 November 2009	13	4914	Tue, 08 December 2009 02:20 By: JRowbottom
Performance issue while pl/sql script execution (merged 3) oracle 10.2.0.4 , Solaris sparc By: lalitm_2003 on Wed, 02 December 2009	19	8833	Mon, 07 December 2009 09:26 By: JRowbottom
retrieve deleted data of user_jobs Oracle 10g, By: spur230 on Sat, 07 November 2009	19	10676	Mon, 07 December 2009 08:32 By: JRowbottom
can we write below query in a better way oracle10g By: chaituu on Fri, 04 December 2009	10	4130	Mon, 07 December 2009 02:52 By: michael_bialik
How to calculate ideal size of log_buffer parameter? 10.2.0.4, sun spark 64 bit By: halim on Thu, 19 November 2009	10	10168	Mon, 07 December 2009 00:47 By: DBA_SangramKeshari
SQL via Crystal Reports and ODBC is very slow, same SQL with toad is fast Oracle Database 10g Enterprise Edition 10.2.0.1.0 By: thomas.weigel on Thu, 03 December 2009	6	10454	Thu, 03 December 2009 21:31 By: wvu1999
How to identify table need resequencing. 10.2.0.3.0 on xp By: misragopal on Thu, 03 December 2009	4	3704	Thu, 03 December 2009 06:07 By: JRowbottom
DBMS_OUTLINE to override HINTS [Merged] Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bi By: spur230 on Fri, 20 November 2009	3	4852	Wed, 02 December 2009 07:20 By: LKBrwn_DBA
Nologging Feature in Archivelog mode : strange Results Oracle 9.2.0.6.0 on HP-UX By: chetanaZ on Mon, 30 November 2009	5	3494	Tue, 01 December 2009 08:56 By: chetanaZ
After Version Enabled (Workspace Manager) Oracle 10g By: rakeshramm on Wed, 25 November 2009	2	2645	Fri, 27 November 2009 00:38 By: Kevin Meade
Very high executions (Parse=Execute) Oracle 10g, Solaris 10 By: trantuananh24hg on Thu, 26 November 2009	2	2956	Fri, 27 November 2009 00:37 By: trantuananh24hg
Performance of a Query 11.5.10, 10g Database By: garylythgoe on Mon, 16 November 2009	22	9093	Mon, 23 November 2009 10:09 By: S.Rajaram
How to tune a update statement Oracle 10g, Solaris 10 By: lucas4394 on Thu, 19 November 2009	9	5547	Mon, 23 November 2009 01:10 By: michael_bialik
how to enable trace for other sessions? By: priyasinha396 on Mon, 16 November 2009	7	7684	Fri, 20 November 2009 04:47 By: trantuananh24hg
query delay 10.2.0.3, Windows 2003 By: newsurfgal on Tue, 17 November 2009	4	3011	Wed, 18 November 2009 22:20 By: Kevin Meade
ORA-00060 Deadlock issue with trigger 10.2.0.4.0, Linux By: KaushalPanjwani on Wed, 09 September 2009	9	11256	Tue, 17 November 2009 09:52 By: BlackSwan
Profile Limits 10.2.0.4.0 - IBM AIX By: user7509 on Mon, 16 November 2009	1	3727	Mon, 16 November 2009 23:11 By: Michel Cadot
.trc files By: priyasinha396 on Mon, 16 November 2009	2	2075	Mon, 16 November 2009 01:09 By: priyasinha396
Does CTAS uses unused space?? By: sameertuladhar on Thu, 12 November 2009	4	2625	Fri, 13 November 2009 17:18 By: rleishman
User statistics Oracle 10.2.0.4 By: gkrishn on Mon, 09 November 2009	3	3145	Mon, 09 November 2009 07:07 By: Michel Cadot
to check for temporary space usage 10.2.0.4 By: ankush_chawla on Wed, 04 November 2009	9	5541	Mon, 09 November 2009 06:35 By: ramoradba