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
keep pool 10g By: grpatwari on Wed, 22 April 2009	10	2722	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	4524	Wed, 29 April 2009 05:33 By: babuknb
DBWR writes entire dirty block ? By: tridentadm on Mon, 27 April 2009	4	2649	Mon, 27 April 2009 12:12 By: BlackSwan
Hints USE_HASH (merged) By: Anne Simms on Tue, 31 March 2009	14	6859	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	2203	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	5521	Sat, 25 April 2009 21:31 By: rleishman
PL SQL performance tuning Oracle 10g By: vinod_tiwari on Tue, 21 April 2009	3	2414	Tue, 21 April 2009 22:01 By: rleishman
The difference of execution plans By: dingwei on Sun, 19 April 2009	0	6121	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	2986	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	2836	Fri, 17 April 2009 00:15 By: gurinder_mann2004
problem while generating AWR report By: rituraj on Tue, 14 April 2009	8	7917	Thu, 16 April 2009 12:01 By: Mahesh Rajendran
improve the performance (merged 2) By: swas_fly on Wed, 15 April 2009	10	2364	Thu, 16 April 2009 06:40 By: JRowbottom
want to change snap level in 10g r2 By: rituraj on Tue, 14 April 2009	1	3779	Tue, 14 April 2009 12:42 By: BlackSwan
improving query performance oracle 10g By: swas_fly on Tue, 14 April 2009	1	1870	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	1721	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	7840	Sun, 12 April 2009 23:16 By: rleishman
create dynamic partitions in oracle 9 oracle9i/ windows By: parasuramchekuri on Fri, 10 April 2009	9	6633	Sat, 11 April 2009 07:25 By: rleishman
Bind variable versus CURSOR_SHARING='SIMILAR' oracle10g By: shrinika on Fri, 10 April 2009	3	5788	Fri, 10 April 2009 23:19 By: trantuananh24hg
List partition and Index partitioning (merged) By: jimit_shaili on Mon, 06 April 2009	14	3131	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	2320	Thu, 09 April 2009 05:07 By: JRowbottom
PCTFREE and PCTUSED 10g Warehouse database on RHEL4 By: nandusb on Sat, 21 March 2009	5	4490	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	3704	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	3269	Wed, 08 April 2009 21:25 By: kevin_ye
SQL Tuning Help Oracle 10g By: crazykuda on Wed, 08 April 2009	1	2172	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	1623	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	3555	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	2864	Sat, 04 April 2009 19:18 By: oraxperts
difference between analyze table and dbms_stats.gatherstatistic By: rituraj on Thu, 02 April 2009	2	3276	Thu, 02 April 2009 09:25 By: BlackSwan
'show parameter allow' doesnt work oracle 9.2 By: rituraj on Wed, 01 April 2009	5	1810	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	2175	Wed, 01 April 2009 11:14 By: Michel Cadot
contention on temprary tablespace oracle 9.2 By: rituraj on Wed, 01 April 2009	3	1454	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	3368	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	1572	Wed, 01 April 2009 03:15 By: dingwei
KEEP POOL Oacle 11g on Solaris10 By: AlinaC on Tue, 31 March 2009	3	1760	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	1555	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	8490	Mon, 30 March 2009 02:34 By: John Charles
Performance tuning By: avrillavinge on Fri, 27 March 2009	4	2041	Fri, 27 March 2009 04:57 By: avrillavinge
Tkprof trace file meaning Oracel10g By: sr_orcl on Thu, 26 March 2009	3	2315	Thu, 26 March 2009 09:53 By: BlackSwan
statspack error By: somavamshi on Fri, 20 July 2007	7	7227	Tue, 24 March 2009 10:49 By: BlackSwan
Performance tuning Oracle By: sivakumar.rj on Mon, 23 March 2009	2	1688	Tue, 24 March 2009 08:40 By: JRowbottom

Pages (119): [ « ‹ 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 › »]

Goto Forum:

[ Syndicate this forum (XML) ] [

]

Legend

New Messages

No New messages

Locked (w/ unread messages) Locked

Locked

Moved to another forum

Current Time: Sun May 12 11:36:07 CDT 2024