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
11g- query Performance issue 11g,Release 11.1.0.6.0,windowsXP By: vs0037476 on Sun, 28 March 2010	4	3561	Mon, 29 March 2010 02:14 By: vs0037476
Query fetching time before hand 11g,solaris9 By: orafacjublu on Thu, 25 March 2010	3	2859	Sun, 28 March 2010 08:17 By: Michel Cadot
materialize view 11g, solaris9 By: orafacjublu on Wed, 24 March 2010	13	5299	Sun, 28 March 2010 06:29 By: Kevin Meade
sql tuning 11g,Solaris 9 By: orafacjublu on Mon, 22 March 2010	6	4046	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	3684	Fri, 26 March 2010 15:10 By: BlackSwan
Swap Partition or Recreate Synonym 10g By: beetel on Tue, 23 March 2010	3	4596	Tue, 23 March 2010 05:06 By: cookiemonster
most accessed 11g, solaris 9 By: orafacjublu on Mon, 08 March 2010	4	3349	Tue, 23 March 2010 04:27 By: michael_bialik
11g sql tuning(urgent) 11g,solaris9 By: orafacjublu on Wed, 10 March 2010	2	3832	Sat, 20 March 2010 09:54 By: Kevin Meade
Optimize the Query Oracle 9i By: virmahi on Fri, 19 March 2010	2	3791	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	18140	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	9460	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	19788	Thu, 11 March 2010 11:51 By: Ricky_1362002
Update statement resulting time out Oracle 10g By: virmahi on Thu, 04 March 2010	37	11159	Wed, 10 March 2010 04:24 By: cookiemonster
Explicit cursor data Oracle10g By: shrinika on Tue, 09 March 2010	3	3243	Tue, 09 March 2010 23:01 By: Michel Cadot
sga 11g,solaris 9 By: orafacjublu on Tue, 09 March 2010	1	2253	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	2631	Tue, 09 March 2010 04:31 By: Michel Cadot
Resource busy during stats gather Oracle 10g By: gkrishn on Sun, 07 March 2010	2	3517	Sun, 07 March 2010 08:48 By: gkrishn
Autotrace (merged by CM) Oracle 9.2, Windows By: visuorac on Wed, 03 March 2010	2	2815	Wed, 03 March 2010 06:43 By: Michel Cadot
Can this query be improved for performance? By: ziggy25 on Tue, 02 March 2010	9	3878	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	2224	Tue, 02 March 2010 04:24 By: Michel Cadot
TEMP TABLESPACE 11G, WINDOWS By: orafacjublu on Tue, 02 March 2010	1	3331	Tue, 02 March 2010 00:25 By: Michel Cadot
ora-1652 11g,solaris 9 By: orafacjublu on Mon, 01 March 2010	9	8130	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	3710	Mon, 01 March 2010 10:11 By: orausern
Performance regression from 8i to 10G Oracle 10G By: Irena on Thu, 25 February 2010	2	3177	Mon, 01 March 2010 01:53 By: michael_bialik
Restructering Oracle, 10g, Windows server 2003 By: getritesh on Thu, 18 February 2010	5	4594	Fri, 26 February 2010 04:31 By: JRowbottom
ORACLE OPTIMIZER Oracle 9.2, Windows By: visuorac on Tue, 23 February 2010	1	2689	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	2358	Tue, 23 February 2010 21:12 By: rahulvb
Query Tuning Oracle 9.2, Windows By: visuorac on Wed, 17 February 2010	10	5164	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	4155	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	2582	Fri, 19 February 2010 05:42 By: ramoradba
11g Result Cache oracle11g, unix By: orafacjublu on Wed, 17 February 2010	7	5498	Fri, 19 February 2010 02:10 By: tahpush
Raplace Group by clause Oracle 9.2, Windows By: visuorac on Thu, 18 February 2010	4	3840	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	2133	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	2997	Wed, 17 February 2010 07:19 By: S.Rajaram
Replace Not Exists Oracle 9.2, UNIX By: visuorac on Wed, 17 February 2010	4	4478	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	3847	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	11282	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	6200	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	6826	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	4097	Fri, 05 February 2010 15:06 By: BlackSwan