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
Moving table into same tablespace oracle9i By: shrinika on Sun, 18 May 2008	2	1395	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	11937	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	1896	Mon, 19 May 2008 09:15 By: JRowbottom
Please help tuning SQL Oracle 9i By: Ivan on Fri, 16 May 2008	2	1885	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	1449	Mon, 19 May 2008 06:35 By: Michel Cadot
Find the query running time oracle9i By: shrinika on Fri, 16 May 2008	2	1287	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	9332	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	15285	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	2030	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	17560	Thu, 15 May 2008 15:17 By: datamile
Number of table partitions Oracle 9.2 By: chintu00 on Thu, 15 May 2008	3	1418	Thu, 15 May 2008 10:23 By: Michel Cadot
challenge to Sr.DBA Oracle 8i By: chinmayikkalki on Wed, 14 May 2008	2	1717	Thu, 15 May 2008 00:00 By: rleishman
Counting whole table? oracle9i By: shrinika on Wed, 14 May 2008	3	1492	Wed, 14 May 2008 15:19 By: Michel Cadot
Need info regarding DATABASE PARTITIONING Oracel 10g By: smithsareen on Wed, 14 May 2008	2	1447	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	1307	Wed, 14 May 2008 03:46 By: rleishman
What the statistics in Explain plan suggests? (merged) By: VEDDETA on Tue, 13 May 2008	9	2375	Wed, 14 May 2008 03:38 By: VEDDETA
optimization of a query By: user71408 on Wed, 14 May 2008	3	1923	Wed, 14 May 2008 01:42 By: Michel Cadot
Error while creating partitioned table Oracle 10g By: amorphous4u on Tue, 13 May 2008	1	3807	Tue, 13 May 2008 12:27 By: Michel Cadot
Query Tuning oracle 10g By: ram anand on Thu, 01 May 2008	3	1584	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	11858	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	1279	Tue, 13 May 2008 09:33 By: BlackSwan
DB performing very slowly, 10g/Solaris By: me_maddy on Wed, 07 May 2008	9	2981	Tue, 13 May 2008 09:28 By: enkhbold
Regd: Tuning required Oracle 9I By: VEDDETA on Mon, 12 May 2008	12	3208	Tue, 13 May 2008 04:42 By: Michel Cadot
Tuning By: Mihiroracle on Tue, 13 May 2008	1	1528	Tue, 13 May 2008 02:27 By: Littlefoot
Reorganizing Vs Rebuilding Indexes Oracle 9i By: riki on Mon, 12 May 2008	4	5141	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	10115	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	1950	Fri, 09 May 2008 06:55 By: stsy
why oracle choose NL in this case? By: alantany on Thu, 08 May 2008	8	3137	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	8547	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	2713	Wed, 07 May 2008 07:07 By: santoshorcl
Oracle Compression Question Oracle 10GR2 By: Triton46 on Tue, 06 May 2008	3	1429	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	3472	Tue, 06 May 2008 09:33 By: goodmans
Perfomance Tuning 10g By: govardhana_rg on Tue, 06 May 2008	1	1482	Tue, 06 May 2008 08:54 By: BlackSwan
Performance Tuning for a package Oracle 10g By: monasingh on Mon, 05 May 2008	2	2186	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	1809	Mon, 05 May 2008 23:03 By: rajatratewal
Data Statistics oracle 10g By: balaji1482 on Sat, 03 May 2008	2	1353	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	1756	Mon, 05 May 2008 01:14 By: Michel Cadot
How to make inserts faster Oracle10g By: hidnana on Fri, 02 May 2008	9	3954	Sun, 04 May 2008 06:45 By: rleishman
SQL statement tuning Oracle 8i By: chinmayikkalki on Thu, 01 May 2008	4	2219	Fri, 02 May 2008 02:50 By: JRowbottom
tuning time consuming queries oracle 8i By: chinmayikkalki on Wed, 30 April 2008	1	1910	Wed, 30 April 2008 22:56 By: rleishman