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
Index Hit Retio Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production By: rahulvb on Thu, 25 March 2010	8	2850	Fri, 26 March 2010 15:10 By: BlackSwan
Swap Partition or Recreate Synonym 10g By: beetel on Tue, 23 March 2010	3	3474	Tue, 23 March 2010 05:06 By: cookiemonster
most accessed 11g, solaris 9 By: orafacjublu on Mon, 08 March 2010	4	2527	Tue, 23 March 2010 04:27 By: michael_bialik
11g sql tuning(urgent) 11g,solaris9 By: orafacjublu on Wed, 10 March 2010	2	2835	Sat, 20 March 2010 09:54 By: Kevin Meade
Optimize the Query Oracle 9i By: virmahi on Fri, 19 March 2010	2	3250	Fri, 19 March 2010 08:30 By: Kevin Meade
Slow connection in Linux 64 bit oracle 9i Oracle 9.2.0.6, Linux 64 bit By: naren.sarkar on Sat, 13 March 2010	19	15968	Thu, 18 March 2010 11:25 By: BlackSwan
11g index can't be rebuild 11g, solaris 9 By: orafacjublu on Thu, 18 March 2010	3	8873	Thu, 18 March 2010 05:25 By: Michel Cadot
Lot of Trace files under udump,bdump with error: Ioctl ASYNC_CONFIG error, errno = 1 Oracle 10.2.0.4 on HP-UX By: Ricky_1362002 on Wed, 10 March 2010	8	18581	Thu, 11 March 2010 11:51 By: Ricky_1362002
Update statement resulting time out Oracle 10g By: virmahi on Thu, 04 March 2010	37	8198	Wed, 10 March 2010 04:24 By: cookiemonster
Explicit cursor data Oracle10g By: shrinika on Tue, 09 March 2010	3	1943	Tue, 09 March 2010 23:01 By: Michel Cadot
sga 11g,solaris 9 By: orafacjublu on Tue, 09 March 2010	1	1647	Tue, 09 March 2010 05:56 By: Michel Cadot
Tune "where col in (val1,val2,val3) oracle 10g By: harshalonline22 on Tue, 09 March 2010	2	2014	Tue, 09 March 2010 04:31 By: Michel Cadot
Resource busy during stats gather Oracle 10g By: gkrishn on Sun, 07 March 2010	2	2761	Sun, 07 March 2010 08:48 By: gkrishn
Autotrace (merged by CM) Oracle 9.2, Windows By: visuorac on Wed, 03 March 2010	2	1921	Wed, 03 March 2010 06:43 By: Michel Cadot
Can this query be improved for performance? By: ziggy25 on Tue, 02 March 2010	9	2888	Tue, 02 March 2010 08:32 By: Michel Cadot
Should an index be rebuilt or recreated during data load. By: ziggy25 on Tue, 02 March 2010	1	1654	Tue, 02 March 2010 04:24 By: Michel Cadot
TEMP TABLESPACE 11G, WINDOWS By: orafacjublu on Tue, 02 March 2010	1	2675	Tue, 02 March 2010 00:25 By: Michel Cadot
ora-1652 11g,solaris 9 By: orafacjublu on Mon, 01 March 2010	9	7088	Tue, 02 March 2010 00:02 By: orafacjublu
question about stats oracle 10.2.0.4 on solaris 8 By: orausern on Mon, 01 March 2010	5	2977	Mon, 01 March 2010 10:11 By: orausern
Performance regression from 8i to 10G Oracle 10G By: Irena on Thu, 25 February 2010	2	2125	Mon, 01 March 2010 01:53 By: michael_bialik
Restructering Oracle, 10g, Windows server 2003 By: getritesh on Thu, 18 February 2010	5	3904	Fri, 26 February 2010 04:31 By: JRowbottom
ORACLE OPTIMIZER Oracle 9.2, Windows By: visuorac on Tue, 23 February 2010	1	1973	Tue, 23 February 2010 22:14 By: BlackSwan
Migration to Oracle 10 Performance issues Oracle 10g Database By: gmakinana on Mon, 22 February 2010	2	1718	Tue, 23 February 2010 21:12 By: rahulvb
Query Tuning Oracle 9.2, Windows By: visuorac on Wed, 17 February 2010	10	4198	Mon, 22 February 2010 10:15 By: cookiemonster
Improve Performance (Merged RL) Oracle, 10g, Windows server 2003 By: getritesh on Sat, 20 February 2010	9	3382	Sun, 21 February 2010 09:56 By: Michel Cadot
Copy history from db1 to db 2 oracle 10, unix By: elnbado on Fri, 19 February 2010	1	1944	Fri, 19 February 2010 05:42 By: ramoradba
11g Result Cache oracle11g, unix By: orafacjublu on Wed, 17 February 2010	7	4535	Fri, 19 February 2010 02:10 By: tahpush
Raplace Group by clause Oracle 9.2, Windows By: visuorac on Thu, 18 February 2010	4	3003	Thu, 18 February 2010 04:03 By: Michel Cadot
Pls tell me, what I need to check before tuning the SQL code? Windows By: victoryhendry on Wed, 17 February 2010	1	1597	Wed, 17 February 2010 08:36 By: Michel Cadot
Can some review my materialized view? Oracle 9i By: pdaalder on Wed, 17 February 2010	1	2326	Wed, 17 February 2010 07:19 By: S.Rajaram
Replace Not Exists Oracle 9.2, UNIX By: visuorac on Wed, 17 February 2010	4	3720	Wed, 17 February 2010 06:42 By: S.Rajaram
Tuning Distributed Queries oracle 11g with windows server2003 64bit By: Adeelusman on Tue, 16 February 2010	4	3137	Tue, 16 February 2010 23:25 By: Adeelusman
High enqueue waits in statspack - lock contention on Primary key index showing 98% of db wait time 9.2.0.6 By: mwansa on Thu, 11 February 2010	22	9867	Mon, 15 February 2010 11:58 By: S.Rajaram
Performance Pruning on fact table 10.2.0.4 By: summoner on Wed, 10 February 2010	10	4937	Fri, 12 February 2010 07:48 By: Kevin Meade
Index is not used after running dbms_stats.gather_table_stats Oracle Database 10g in Sun Solaris 64bit By: katripon on Sat, 06 February 2010	7	5915	Tue, 09 February 2010 07:51 By: raselvista
Long run time of query with Order by clause Oracle 10g By: ganesh104 on Fri, 05 February 2010	3	3002	Fri, 05 February 2010 15:06 By: BlackSwan
HASH cluster building very Slow Oracle 10g R2 By: sky_lt on Tue, 02 February 2010	7	4320	Fri, 05 February 2010 03:05 By: John Watson
Performance issue in Oracle 10g using Bulk Collect Oracle 10.2.0.3.0 By: venkat_bollu on Fri, 05 February 2010	3	3927	Fri, 05 February 2010 02:58 By: Michel Cadot
Function Based Indexes By: navin_deep on Wed, 03 February 2010	2	2367	Wed, 03 February 2010 12:09 By: Michel Cadot
Oracle Segment Tuning Oracle10g By: salora on Tue, 02 February 2010	2	8522	Tue, 02 February 2010 02:59 By: rahulvb