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
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	1691	Wed, 21 May 2008 05:53 By: rleishman
Updates ( 1 2) By: Lucky A on Sun, 11 May 2008	53	5981	Wed, 21 May 2008 01:30 By: Lucky A
Moving table into same tablespace oracle9i By: shrinika on Sun, 18 May 2008	2	1839	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	12171	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	2183	Mon, 19 May 2008 09:15 By: JRowbottom
Please help tuning SQL Oracle 9i By: Ivan on Fri, 16 May 2008	2	2127	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	1817	Mon, 19 May 2008 06:35 By: Michel Cadot
Find the query running time oracle9i By: shrinika on Fri, 16 May 2008	2	1906	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	9669	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	15874	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	3124	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	17833	Thu, 15 May 2008 15:17 By: datamile
Number of table partitions Oracle 9.2 By: chintu00 on Thu, 15 May 2008	3	1729	Thu, 15 May 2008 10:23 By: Michel Cadot
challenge to Sr.DBA Oracle 8i By: chinmayikkalki on Wed, 14 May 2008	2	1989	Thu, 15 May 2008 00:00 By: rleishman
Counting whole table? oracle9i By: shrinika on Wed, 14 May 2008	3	2246	Wed, 14 May 2008 15:19 By: Michel Cadot
Need info regarding DATABASE PARTITIONING Oracel 10g By: smithsareen on Wed, 14 May 2008	2	1732	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	1465	Wed, 14 May 2008 03:46 By: rleishman
What the statistics in Explain plan suggests? (merged) By: VEDDETA on Tue, 13 May 2008	9	2680	Wed, 14 May 2008 03:38 By: VEDDETA
optimization of a query By: user71408 on Wed, 14 May 2008	3	2120	Wed, 14 May 2008 01:42 By: Michel Cadot
Error while creating partitioned table Oracle 10g By: amorphous4u on Tue, 13 May 2008	1	4142	Tue, 13 May 2008 12:27 By: Michel Cadot
Query Tuning oracle 10g By: ram anand on Thu, 01 May 2008	3	1897	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	13322	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	1619	Tue, 13 May 2008 09:33 By: BlackSwan
DB performing very slowly, 10g/Solaris By: me_maddy on Wed, 07 May 2008	9	3850	Tue, 13 May 2008 09:28 By: enkhbold
Regd: Tuning required Oracle 9I By: VEDDETA on Mon, 12 May 2008	12	3648	Tue, 13 May 2008 04:42 By: Michel Cadot
Tuning By: Mihiroracle on Tue, 13 May 2008	1	1960	Tue, 13 May 2008 02:27 By: Littlefoot
Reorganizing Vs Rebuilding Indexes Oracle 9i By: riki on Mon, 12 May 2008	4	5474	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	10542	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	2742	Fri, 09 May 2008 06:55 By: stsy
why oracle choose NL in this case? By: alantany on Thu, 08 May 2008	8	3443	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	9455	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	3157	Wed, 07 May 2008 07:07 By: santoshorcl
Oracle Compression Question Oracle 10GR2 By: Triton46 on Tue, 06 May 2008	3	1926	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	3878	Tue, 06 May 2008 09:33 By: goodmans
Perfomance Tuning 10g By: govardhana_rg on Tue, 06 May 2008	1	2006	Tue, 06 May 2008 08:54 By: BlackSwan
Performance Tuning for a package Oracle 10g By: monasingh on Mon, 05 May 2008	2	2381	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	2657	Mon, 05 May 2008 23:03 By: rajatratewal
Data Statistics oracle 10g By: balaji1482 on Sat, 03 May 2008	2	1639	Mon, 05 May 2008 06:41 By: balaji1482
Where can I download this Book? Oracle 10gR2 RedHat AS 4 By: wxfjordan on Sun, 04 May 2008	3	2401	Mon, 05 May 2008 01:14 By: Michel Cadot
How to make inserts faster Oracle10g By: hidnana on Fri, 02 May 2008	9	4323	Sun, 04 May 2008 06:45 By: rleishman