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
Hint is not working oracle10g By: shrinika on Thu, 23 April 2009	8	4576	Sun, 03 May 2009 20:49 By: iamadba
value BETWEEN x AND y Oracle 10.2G By: wakula on Thu, 12 March 2009	8	3223	Fri, 01 May 2009 17:33 By: rleishman
keep pool 10g By: grpatwari on Wed, 22 April 2009	10	4328	Wed, 29 April 2009 08:53 By: JRowbottom
Job queue process takes more then 90 % cpu oracle 10.2.0.4.0,Unbrekable linux By: sameer_2230 on Wed, 29 April 2009	5	5695	Wed, 29 April 2009 05:33 By: babuknb
DBWR writes entire dirty block ? By: tridentadm on Mon, 27 April 2009	4	3662	Mon, 27 April 2009 12:12 By: BlackSwan
Hints USE_HASH (merged) By: Anne Simms on Tue, 31 March 2009	14	7615	Mon, 27 April 2009 08:28 By: Anne Simms
SQL PERFORMANCE ANALYZER Oracle 11g Rel1 , RHEL AS4 By: rsreddy28 on Sun, 26 April 2009	1	2867	Sun, 26 April 2009 08:09 By: Mahesh Rajendran
Query Rewrite Failed After RLS policy applied(QSM-01284) By: ramabhupal on Fri, 17 April 2009	10	6003	Sat, 25 April 2009 21:31 By: rleishman
PL SQL performance tuning Oracle 10g By: vinod_tiwari on Tue, 21 April 2009	3	2806	Tue, 21 April 2009 22:01 By: rleishman
The difference of execution plans By: dingwei on Sun, 19 April 2009	0	6558	Sun, 19 April 2009 01:11 By: dingwei
SQL too slow 10g 10.1.0.2.0 - xp By: rzkhan on Thu, 16 April 2009	8	3411	Fri, 17 April 2009 08:47 By: BlackSwan
Query is getting stuck after adding one filter condition is where clause 9I, Windows By: gurinder_mann2004 on Fri, 10 April 2009	8	4477	Fri, 17 April 2009 00:15 By: gurinder_mann2004
problem while generating AWR report By: rituraj on Tue, 14 April 2009	8	9054	Thu, 16 April 2009 12:01 By: Mahesh Rajendran
improve the performance (merged 2) By: swas_fly on Wed, 15 April 2009	10	2664	Thu, 16 April 2009 06:40 By: JRowbottom
want to change snap level in 10g r2 By: rituraj on Tue, 14 April 2009	1	4306	Tue, 14 April 2009 12:42 By: BlackSwan
improving query performance oracle 10g By: swas_fly on Tue, 14 April 2009	1	2094	Tue, 14 April 2009 12:29 By: Michel Cadot
Explain Plan Oracle Database 10g Release 10.1.0.2.0 - 64bi ,HP-UX B.11.23 By: vinniora on Tue, 14 April 2009	1	2323	Tue, 14 April 2009 01:13 By: Michel Cadot
TKprof shows fetching taking long time Database: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bi By: spur230 on Wed, 01 April 2009	7	8400	Sun, 12 April 2009 23:16 By: rleishman
create dynamic partitions in oracle 9 oracle9i/ windows By: parasuramchekuri on Fri, 10 April 2009	9	8076	Sat, 11 April 2009 07:25 By: rleishman
Bind variable versus CURSOR_SHARING='SIMILAR' oracle10g By: shrinika on Fri, 10 April 2009	3	6077	Fri, 10 April 2009 23:19 By: trantuananh24hg
List partition and Index partitioning (merged) By: jimit_shaili on Mon, 06 April 2009	14	3651	Fri, 10 April 2009 00:34 By: jimit_shaili
Can any one help me to tune this query. By: vipinsonkar2000 on Sat, 04 April 2009	9	2759	Thu, 09 April 2009 05:07 By: JRowbottom
PCTFREE and PCTUSED 10g Warehouse database on RHEL4 By: nandusb on Sat, 21 March 2009	5	5008	Thu, 09 April 2009 02:39 By: Michel Cadot
Report Taking So Much Of Time and goes into ORA-01555 Oracle Apps 11.5.10.2 By: sumitgarg on Wed, 08 April 2009	4	4785	Wed, 08 April 2009 23:13 By: sumitgarg
how to optimize sql for query big table? (merged 3) By: kevin_ye on Wed, 08 April 2009	3	3603	Wed, 08 April 2009 21:25 By: kevin_ye
SQL Tuning Help Oracle 10g By: crazykuda on Wed, 08 April 2009	1	2841	Wed, 08 April 2009 15:08 By: BlackSwan
ORA-00604: error occurred at recursive SQL level x Oracle 10.1.2.0 Windows 2003 By: rakesh.c.purohit on Wed, 08 April 2009	1	2027	Wed, 08 April 2009 08:47 By: Mahesh Rajendran
v$session output oracle 10203 /AIX 5.3 By: loveoracle on Mon, 06 April 2009	9	4037	Tue, 07 April 2009 05:55 By: Michel Cadot
Temp Tablespace usage Oracle 9.2.0.7 AIX By: dbcop on Sat, 04 April 2009	1	3148	Sat, 04 April 2009 19:18 By: oraxperts
difference between analyze table and dbms_stats.gatherstatistic By: rituraj on Thu, 02 April 2009	2	3872	Thu, 02 April 2009 09:25 By: BlackSwan
'show parameter allow' doesnt work oracle 9.2 By: rituraj on Wed, 01 April 2009	5	3070	Wed, 01 April 2009 13:55 By: rituraj
how to give kill session priviledge to normal user By: rituraj on Wed, 01 April 2009	3	2878	Wed, 01 April 2009 11:14 By: Michel Cadot
contention on temprary tablespace oracle 9.2 By: rituraj on Wed, 01 April 2009	3	2352	Wed, 01 April 2009 11:12 By: Mahesh Rajendran
Performance degrades suddenly. 10.2.0.4/Solaris 10 By: it_me24 on Mon, 30 March 2009	10	3735	Wed, 01 April 2009 05:12 By: rleishman
bad index choose when using rownum < 9 or less 10.2.0.4 AIX 5 By: lionel.ducret on Tue, 31 March 2009	1	1794	Wed, 01 April 2009 03:15 By: dingwei
KEEP POOL Oacle 11g on Solaris10 By: AlinaC on Tue, 31 March 2009	3	2703	Tue, 31 March 2009 21:06 By: BlackSwan
What if not give any ext in datafile........ By: sameer_2230 on Sat, 28 March 2009	2	2362	Mon, 30 March 2009 10:09 By: JRowbottom
AWR report analysis Oracle Serer, 10g R2 , RH By: John Charles on Mon, 30 March 2009	0	8774	Mon, 30 March 2009 02:34 By: John Charles
Performance tuning By: avrillavinge on Fri, 27 March 2009	4	2747	Fri, 27 March 2009 04:57 By: avrillavinge
Tkprof trace file meaning Oracel10g By: sr_orcl on Thu, 26 March 2009	3	3055	Thu, 26 March 2009 09:53 By: BlackSwan