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	4733	Sun, 28 March 2010 06:29 By: Kevin Meade
sql tuning 11g,Solaris 9 By: orafacjublu on Mon, 22 March 2010	6	3653	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	3319	Fri, 26 March 2010 15:10 By: BlackSwan
Swap Partition or Recreate Synonym 10g By: beetel on Tue, 23 March 2010	3	4136	Tue, 23 March 2010 05:06 By: cookiemonster
most accessed 11g, solaris 9 By: orafacjublu on Mon, 08 March 2010	4	3009	Tue, 23 March 2010 04:27 By: michael_bialik
11g sql tuning(urgent) 11g,solaris9 By: orafacjublu on Wed, 10 March 2010	2	3584	Sat, 20 March 2010 09:54 By: Kevin Meade
Optimize the Query Oracle 9i By: virmahi on Fri, 19 March 2010	2	3524	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	16770	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	9153	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	19058	Thu, 11 March 2010 11:51 By: Ricky_1362002
Update statement resulting time out Oracle 10g By: virmahi on Thu, 04 March 2010	37	9313	Wed, 10 March 2010 04:24 By: cookiemonster
Explicit cursor data Oracle10g By: shrinika on Tue, 09 March 2010	3	2933	Tue, 09 March 2010 23:01 By: Michel Cadot
sga 11g,solaris 9 By: orafacjublu on Tue, 09 March 2010	1	2030	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	2384	Tue, 09 March 2010 04:31 By: Michel Cadot
Resource busy during stats gather Oracle 10g By: gkrishn on Sun, 07 March 2010	2	3273	Sun, 07 March 2010 08:48 By: gkrishn
Autotrace (merged by CM) Oracle 9.2, Windows By: visuorac on Wed, 03 March 2010	2	2585	Wed, 03 March 2010 06:43 By: Michel Cadot
Can this query be improved for performance? By: ziggy25 on Tue, 02 March 2010	9	3243	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	1897	Tue, 02 March 2010 04:24 By: Michel Cadot
TEMP TABLESPACE 11G, WINDOWS By: orafacjublu on Tue, 02 March 2010	1	3050	Tue, 02 March 2010 00:25 By: Michel Cadot
ora-1652 11g,solaris 9 By: orafacjublu on Mon, 01 March 2010	9	7608	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	3243	Mon, 01 March 2010 10:11 By: orausern
Performance regression from 8i to 10G Oracle 10G By: Irena on Thu, 25 February 2010	2	2874	Mon, 01 March 2010 01:53 By: michael_bialik
Restructering Oracle, 10g, Windows server 2003 By: getritesh on Thu, 18 February 2010	5	4165	Fri, 26 February 2010 04:31 By: JRowbottom
ORACLE OPTIMIZER Oracle 9.2, Windows By: visuorac on Tue, 23 February 2010	1	2472	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	2123	Tue, 23 February 2010 21:12 By: rahulvb
Query Tuning Oracle 9.2, Windows By: visuorac on Wed, 17 February 2010	10	4564	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	3728	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	2380	Fri, 19 February 2010 05:42 By: ramoradba
11g Result Cache oracle11g, unix By: orafacjublu on Wed, 17 February 2010	7	4922	Fri, 19 February 2010 02:10 By: tahpush
Raplace Group by clause Oracle 9.2, Windows By: visuorac on Thu, 18 February 2010	4	3467	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	1944	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	2784	Wed, 17 February 2010 07:19 By: S.Rajaram
Replace Not Exists Oracle 9.2, UNIX By: visuorac on Wed, 17 February 2010	4	4073	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	3526	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	10524	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	5399	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	6402	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	3744	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	4717	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	4238	Fri, 05 February 2010 02:58 By: Michel Cadot