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
materialize view 11g, solaris9 By: orafacjublu on Wed, 24 March 2010	13	4388	Sun, 28 March 2010 06:29 By: Kevin Meade
sql tuning 11g,Solaris 9 By: orafacjublu on Mon, 22 March 2010	6	3470	Sun, 28 March 2010 06:16 By: Kevin Meade
Index Hit Retio Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production By: rahulvb on Thu, 25 March 2010	8	3234	Fri, 26 March 2010 15:10 By: BlackSwan
Swap Partition or Recreate Synonym 10g By: beetel on Tue, 23 March 2010	3	3777	Tue, 23 March 2010 05:06 By: cookiemonster
most accessed 11g, solaris 9 By: orafacjublu on Mon, 08 March 2010	4	2840	Tue, 23 March 2010 04:27 By: michael_bialik
11g sql tuning(urgent) 11g,solaris9 By: orafacjublu on Wed, 10 March 2010	2	3084	Sat, 20 March 2010 09:54 By: Kevin Meade
Optimize the Query Oracle 9i By: virmahi on Fri, 19 March 2010	2	3477	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	16502	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	9103	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	18946	Thu, 11 March 2010 11:51 By: Ricky_1362002
Update statement resulting time out Oracle 10g By: virmahi on Thu, 04 March 2010	37	8966	Wed, 10 March 2010 04:24 By: cookiemonster
Explicit cursor data Oracle10g By: shrinika on Tue, 09 March 2010	3	2188	Tue, 09 March 2010 23:01 By: Michel Cadot
sga 11g,solaris 9 By: orafacjublu on Tue, 09 March 2010	1	1859	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	2254	Tue, 09 March 2010 04:31 By: Michel Cadot
Resource busy during stats gather Oracle 10g By: gkrishn on Sun, 07 March 2010	2	3014	Sun, 07 March 2010 08:48 By: gkrishn
Autotrace (merged by CM) Oracle 9.2, Windows By: visuorac on Wed, 03 March 2010	2	2154	Wed, 03 March 2010 06:43 By: Michel Cadot
Can this query be improved for performance? By: ziggy25 on Tue, 02 March 2010	9	3137	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	1851	Tue, 02 March 2010 04:24 By: Michel Cadot
TEMP TABLESPACE 11G, WINDOWS By: orafacjublu on Tue, 02 March 2010	1	2872	Tue, 02 March 2010 00:25 By: Michel Cadot
ora-1652 11g,solaris 9 By: orafacjublu on Mon, 01 March 2010	9	7375	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	3192	Mon, 01 March 2010 10:11 By: orausern
Performance regression from 8i to 10G Oracle 10G By: Irena on Thu, 25 February 2010	2	2328	Mon, 01 March 2010 01:53 By: michael_bialik
Restructering Oracle, 10g, Windows server 2003 By: getritesh on Thu, 18 February 2010	5	4089	Fri, 26 February 2010 04:31 By: JRowbottom
ORACLE OPTIMIZER Oracle 9.2, Windows By: visuorac on Tue, 23 February 2010	1	2152	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	1952	Tue, 23 February 2010 21:12 By: rahulvb
Query Tuning Oracle 9.2, Windows By: visuorac on Wed, 17 February 2010	10	4500	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	3665	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	2155	Fri, 19 February 2010 05:42 By: ramoradba
11g Result Cache oracle11g, unix By: orafacjublu on Wed, 17 February 2010	7	4803	Fri, 19 February 2010 02:10 By: tahpush
Raplace Group by clause Oracle 9.2, Windows By: visuorac on Thu, 18 February 2010	4	3227	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	1815	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	2535	Wed, 17 February 2010 07:19 By: S.Rajaram
Replace Not Exists Oracle 9.2, UNIX By: visuorac on Wed, 17 February 2010	4	3964	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	3366	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	10282	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	5253	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	6200	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	3296	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	4654	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	4187	Fri, 05 February 2010 02:58 By: Michel Cadot