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
AWR report windows By: sandeip on Tue, 17 January 2012	6	3201	Tue, 17 January 2012 07:07 By: Michel Cadot
Best Practices to optimize a FAST REFRESH Materialized View? Oracle 11g By: tsteinmaurer on Mon, 16 January 2012	2	7183	Tue, 17 January 2012 05:53 By: rleishman
Wait events for a query Oracle 10.2.0.4 By: himabija on Tue, 17 January 2012	1	1192	Tue, 17 January 2012 04:52 By: Michel Cadot
Oracle10g Standard Edition on Linux machine SGA Tuning By: gauravsrivastava on Mon, 16 January 2012	5	2339	Mon, 16 January 2012 02:17 By: himabija
truncate table Linux 2.6.18-92.1.13.el5 By: dba_7722 on Fri, 13 January 2012	4	1839	Fri, 13 January 2012 04:50 By: Michel Cadot
Query running more time Oracle 11g standard Version By: sank on Mon, 09 January 2012	4	4480	Tue, 10 January 2012 14:50 By: sank
HTML AWR Report Red Hat Linux 5.3 and oracle 10g By: morad_dba on Tue, 10 January 2012	9	12503	Tue, 10 January 2012 09:13 By: ramoradba
Explain Plan Oracle 10g Hp-UX By: pokhraj_d on Thu, 05 January 2012	3	2884	Thu, 05 January 2012 06:05 By: rleishman
Query taking long time on MVs Oracle 11g, UNIX By: ind9 on Thu, 29 December 2011	4	2182	Wed, 04 January 2012 12:00 By: LNossov
Same query using different execution plans, why?? Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 By: manubatham20 on Mon, 26 December 2011	8	3400	Wed, 04 January 2012 09:15 By: LNossov
Performance problem with table when using one column as reserved word METHOD Oracle 10g,Windows XP By: shajat on Thu, 29 December 2011	2	1329	Fri, 30 December 2011 05:58 By: shajat
Remove Table Fragmentation oracle 11.2.0 , linux X86 By: crussed_sonu on Thu, 29 December 2011	7	3522	Fri, 30 December 2011 04:09 By: Michel Cadot
performace tunning By: sb0024297 on Fri, 30 December 2011	1	1457	Fri, 30 December 2011 03:04 By: Littlefoot
Tuning a small but complicated query Oracle By: neel_Tannu on Thu, 29 December 2011	2	1705	Thu, 29 December 2011 17:35 By: BlackSwan
Bitmap Conversion Oracle 10.2.0.3.0 on AIX By: chuckstoker on Tue, 20 December 2011	8	3097	Wed, 28 December 2011 09:49 By: Kevin Meade
Query running long time Oracle ,10.2.0.4.0 , SunOS By: Jack14 on Mon, 26 December 2011	5	6316	Wed, 28 December 2011 09:48 By: Kevin Meade
Performance Tuning All By: lynndba on Wed, 23 November 2011	11	2879	Tue, 27 December 2011 21:20 By: Kevin Meade
Performance access direct table vs view Oracle 10g / Windows XP By: eeriehunk on Fri, 09 December 2011	9	2791	Tue, 27 December 2011 20:23 By: Kevin Meade
Query cost oracle, 10g, HP-UX B.11.23 By: aruldts on Tue, 27 December 2011	1	1907	Tue, 27 December 2011 01:32 By: Michel Cadot
How to Track Delay in Displaying data on application GUI Oracle 10.2.0.4 By: orapratap on Wed, 21 December 2011	3	1717	Wed, 21 December 2011 03:59 By: Roachcoach
Query on Explain Plan Steps Oracle 10.2.0.4 on RHEL By: orapratap on Wed, 14 December 2011	9	3311	Tue, 20 December 2011 23:57 By: orapratap
Query performance related oracle By: hemant_khandare on Thu, 17 November 2011	4	1947	Tue, 20 December 2011 10:42 By: hemant_khandare
buffer busy wait Linux 2.6.18-92.1.13.el5 By: dba_7722 on Tue, 20 December 2011	4	3345	Tue, 20 December 2011 06:35 By: Michel Cadot
Rowid Range Scan By: gajini on Mon, 19 December 2011	9	13915	Mon, 19 December 2011 04:53 By: Roachcoach
Question on table statistics Oracle 10.2.0.4.0 ,Sun solaris By: Jack14 on Tue, 13 December 2011	23	6258	Thu, 15 December 2011 23:56 By: Jack14
Situations where FAST REFRESH Materialized View does a COMPLETE REFRESH? Oracle 10g By: tsteinmaurer on Thu, 15 December 2011	0	2270	Thu, 15 December 2011 06:03 By: tsteinmaurer
simple select * from table is taking lot of time 11.2.0.1.0 By: gogol_1987 on Tue, 13 December 2011	9	2589	Wed, 14 December 2011 04:33 By: gogol_1987
How to improve performance Oracle 9i By: ravi_n on Wed, 07 December 2011	6	2780	Wed, 14 December 2011 01:28 By: jameslongenecker
Can you please provide optimized query Oracle Database 10g Enterprise Edition Release 10.2.0.4.0, OS - I don't know By: manubatham20 on Thu, 13 October 2011	30	4688	Tue, 13 December 2011 08:12 By: manubatham20
Time Calculation in AWR report Oracle 11g R2 on windows 7 64 bit By: orapratap on Mon, 12 December 2011	2	5675	Tue, 13 December 2011 00:13 By: orapratap
Tune long running query Oracle 10.2.0.4.0, SunOS By: Database admin on Mon, 05 December 2011	24	4552	Tue, 13 December 2011 00:05 By: Database admin
Difficulty in using bind variable to check explain plan Oracle 10.2.0.4 on Linux By: orapratap on Mon, 12 December 2011	12	4261	Mon, 12 December 2011 03:56 By: Michel Cadot
sql tuning for one query 11g 11.2.0,2,IBM aix 64 bit By: pvgangadar on Thu, 08 December 2011	9	3227	Fri, 09 December 2011 08:48 By: John Watson
SQL Profiles Solaris 10, Oracle 10.2.0.4 By: suddhasatwa_bhaumik on Fri, 09 December 2011	0	1973	Fri, 09 December 2011 06:28 By: suddhasatwa_bhaumik
Performance Across DB Links Oracle 11g2, LINUX By: mjm22 on Wed, 07 December 2011	1	3068	Wed, 07 December 2011 15:17 By: cookiemonster
create index 10.2.0.4 By: varunvir on Tue, 06 December 2011	13	2335	Wed, 07 December 2011 07:57 By: Michel Cadot
performance problem Oracle 9i By: ajaykumarkona on Wed, 07 December 2011	3	1565	Wed, 07 December 2011 02:39 By: Michel Cadot
How to improve the performance of export job(expdp)? Oracle10gr2, Linux. By: konkalasiva on Tue, 06 December 2011	1	2580	Tue, 06 December 2011 03:44 By: Michel Cadot
How to reduce cost of my query? sql developer By: Naga_naga_naga on Sat, 03 December 2011	3	3674	Sat, 03 December 2011 01:16 By: flyboy
urgent please modify this query frenz sloww performance By: arivazhagancsegmailcom on Thu, 01 December 2011	12	3728	Fri, 02 December 2011 16:07 By: LNossov