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
Finding HWM oracle9i By: shrinika on Tue, 20 May 2008	4	2541	Wed, 21 May 2008 07:06 By: shrinika
Query is taking exceptionally large amount of time Oracle Database 10g Enterprise Edition Release 10.1.0.4.0,PL/SQL Release 10.1.0.4.0 By: sreenadhaj on Tue, 20 May 2008	5	2695	Wed, 21 May 2008 05:54 By: rleishman
MView Complete Refresh Performance Issue Oracle 10g R2 Enterprise Edition 64-bit, Windows 2003 Standard Edition 64-bit By: sawcna on Wed, 21 May 2008	1	1880	Wed, 21 May 2008 05:53 By: rleishman
Updates ( 1 2) By: Lucky A on Sun, 11 May 2008	53	8040	Wed, 21 May 2008 01:30 By: Lucky A
Moving table into same tablespace oracle9i By: shrinika on Sun, 18 May 2008	2	2056	Tue, 20 May 2008 15:20 By: shrinika
cursor: pin S wait on X in Oracle 10.2.0.4 Oracle 10.2.0.4 on RHEL 4 By: OraKaran on Tue, 06 May 2008	2	12384	Mon, 19 May 2008 16:27 By: moatazmizo
How i tune database and sql Oracle 9i (9.2.0.1) on Windows 2003 Server 32 bit By: pradies on Mon, 19 May 2008	2	2478	Mon, 19 May 2008 09:15 By: JRowbottom
Please help tuning SQL Oracle 9i By: Ivan on Fri, 16 May 2008	2	2449	Mon, 19 May 2008 07:50 By: rleishman
How To Get Previous Version Of Stats Gathered Oracle,9.2.0.6.0,XP By: rajatratewal on Mon, 19 May 2008	3	2041	Mon, 19 May 2008 06:35 By: Michel Cadot
Find the query running time oracle9i By: shrinika on Fri, 16 May 2008	2	2141	Fri, 16 May 2008 17:03 By: shrinika
Oracle NOT IN query is slow Oracle 10g on Win2k3 By: nmaier on Thu, 15 May 2008	3	10041	Fri, 16 May 2008 12:04 By: nmaier
connect by prior is killing me again Oracle 10g By: zim327 on Thu, 15 May 2008	9	16867	Fri, 16 May 2008 09:10 By: zim327
Performance Issue on a specific Table only Oracle 10G V3` By: DBAsal on Thu, 15 May 2008	8	3396	Fri, 16 May 2008 07:31 By: DBAsal
High enq: TX - row lock contention Oracle 10.2 HPUX By: datamile on Thu, 15 May 2008	2	18190	Thu, 15 May 2008 15:17 By: datamile
Number of table partitions Oracle 9.2 By: chintu00 on Thu, 15 May 2008	3	1928	Thu, 15 May 2008 10:23 By: Michel Cadot
challenge to Sr.DBA Oracle 8i By: chinmayikkalki on Wed, 14 May 2008	2	2197	Thu, 15 May 2008 00:00 By: rleishman
Counting whole table? oracle9i By: shrinika on Wed, 14 May 2008	3	2503	Wed, 14 May 2008 15:19 By: Michel Cadot
Need info regarding DATABASE PARTITIONING Oracel 10g By: smithsareen on Wed, 14 May 2008	2	2027	Wed, 14 May 2008 04:01 By: smithsareen
can any one help to tune the query solaris 10 oracle 10.2.0.3 By: skumar.dba on Tue, 13 May 2008	1	1732	Wed, 14 May 2008 03:46 By: rleishman
What the statistics in Explain plan suggests? (merged) By: VEDDETA on Tue, 13 May 2008	9	3013	Wed, 14 May 2008 03:38 By: VEDDETA
optimization of a query By: user71408 on Wed, 14 May 2008	3	2319	Wed, 14 May 2008 01:42 By: Michel Cadot
Error while creating partitioned table Oracle 10g By: amorphous4u on Tue, 13 May 2008	1	4334	Tue, 13 May 2008 12:27 By: Michel Cadot
Query Tuning oracle 10g By: ram anand on Thu, 01 May 2008	3	2270	Tue, 13 May 2008 09:57 By: enkhbold
DeadLock in the database Oracle 9i on Solaris 9 ( 1 2) By: vaishalikatarki on Mon, 14 April 2008	72	15392	Tue, 13 May 2008 09:46 By: vaishalikatarki
oracle data base in multi application server and multi sites oracle data base 10g and oracle application server By: abdou_ci on Tue, 13 May 2008	1	1812	Tue, 13 May 2008 09:33 By: BlackSwan
DB performing very slowly, 10g/Solaris By: me_maddy on Wed, 07 May 2008	9	4289	Tue, 13 May 2008 09:28 By: enkhbold
Regd: Tuning required Oracle 9I By: VEDDETA on Mon, 12 May 2008	12	4018	Tue, 13 May 2008 04:42 By: Michel Cadot
Tuning By: Mihiroracle on Tue, 13 May 2008	1	2249	Tue, 13 May 2008 02:27 By: Littlefoot
Reorganizing Vs Rebuilding Indexes Oracle 9i By: riki on Mon, 12 May 2008	4	5845	Mon, 12 May 2008 16:22 By: BlackSwan
Tuning Error with Order by clause 10.2.0.3, Solaris64 By: arvulis on Thu, 08 May 2008	3	10966	Sun, 11 May 2008 22:24 By: rleishman
Problem on understanding cardinality of index 10.2.0.3 By: stsy on Fri, 09 May 2008	6	3027	Fri, 09 May 2008 06:55 By: stsy
why oracle choose NL in this case? By: alantany on Thu, 08 May 2008	8	3828	Fri, 09 May 2008 04:46 By: JRowbottom
impact of this parameter bloom_filter_enabled =false oracle 10.2.0.2 solaris 10 64 bit By: skumar.dba on Wed, 07 May 2008	6	9789	Thu, 08 May 2008 05:30 By: Michel Cadot
Importance of index unique scan (cost=0) Oracle 10g R2, HPUX By: santoshorcl on Wed, 07 May 2008	2	3459	Wed, 07 May 2008 07:07 By: santoshorcl
Oracle Compression Question Oracle 10GR2 By: Triton46 on Tue, 06 May 2008	3	2282	Tue, 06 May 2008 10:56 By: Michel Cadot
How to tune a view using 3 big tables By: goodmans on Wed, 23 April 2008	13	4296	Tue, 06 May 2008 09:33 By: goodmans
Perfomance Tuning 10g By: govardhana_rg on Tue, 06 May 2008	1	2171	Tue, 06 May 2008 08:54 By: BlackSwan
Performance Tuning for a package Oracle 10g By: monasingh on Mon, 05 May 2008	2	2550	Tue, 06 May 2008 01:05 By: monasingh
Query Executing Every Second Oracle 9i,9.2.0.6.0,windows XP By: rajatratewal on Mon, 05 May 2008	6	3124	Mon, 05 May 2008 23:03 By: rajatratewal
Data Statistics oracle 10g By: balaji1482 on Sat, 03 May 2008	2	1877	Mon, 05 May 2008 06:41 By: balaji1482