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
Performance tuning for a simple table with 2million records Oracle 10g, windows server series By: santhoshmohan on Wed, 12 November 2008	2	1710	Mon, 17 November 2008 21:51 By: Oyunbold
Query optimization By: prem18 on Mon, 17 November 2008	2	2001	Mon, 17 November 2008 19:44 By: rleishman
Wait events 10g,linux By: vinniora on Mon, 17 November 2008	1	1354	Mon, 17 November 2008 04:51 By: Michel Cadot
Error in Materialized view refresh Oracle Database By: mac4rfree on Fri, 14 November 2008	3	2729	Sat, 15 November 2008 14:04 By: Littlefoot
package performance oracle10.2.0.3 By: skumar.dba on Thu, 13 November 2008	3	1780	Fri, 14 November 2008 23:10 By: rleishman
Interpreting "Row Source Operation" Output of TKPROF Oracle 9iR2 By: tsteinmaurer on Wed, 12 November 2008	6	4312	Thu, 13 November 2008 19:24 By: rleishman
High Logical Reads 10g R2, 10.2.0.2, win 2003 stnd sp2 By: kummi_gh on Wed, 12 November 2008	2	1694	Wed, 12 November 2008 22:58 By: kummi_gh
Find speed oracle 10 g By: pointers on Wed, 12 November 2008	6	2079	Wed, 12 November 2008 10:55 By: Michel Cadot
Query taking very long time Oracle 10g By: virmahi on Fri, 07 November 2008	4	2748	Tue, 11 November 2008 20:44 By: rleishman
Dunsel Joins 9i, 10g, 11g By: Kevin Meade on Mon, 10 November 2008	4	3821	Tue, 11 November 2008 20:39 By: rleishman
Wait events 9i (9.2.0.1) Windows 2003 By: marcossantos on Tue, 11 November 2008	1	1446	Tue, 11 November 2008 12:32 By: Michel Cadot
gets,pins and reloads in v$library Cache By: ankush_chawla on Mon, 10 November 2008	2	1423	Tue, 11 November 2008 02:07 By: Littlefoot
SESSION CPU AIX 10G By: lioracle on Mon, 10 November 2008	5	1500	Mon, 10 November 2008 11:27 By: Michel Cadot
Query Tuning O9i By: manoj12 on Mon, 10 November 2008	1	2024	Mon, 10 November 2008 01:36 By: rleishman
Performance Issue: Steps that need to take care of Oracle9i By: Olivia on Wed, 05 November 2008	2	1471	Fri, 07 November 2008 01:06 By: virmahi
Performance: partition/index not used Oracle 10.2G By: wakula on Wed, 05 November 2008	1	1509	Thu, 06 November 2008 01:28 By: rleishman
Index a system view 10g on IBM AIX By: serkzc on Wed, 05 November 2008	1	1637	Wed, 05 November 2008 23:29 By: Michel Cadot
Dirty database_Performance issues By: neena_forum on Tue, 04 November 2008	2	1805	Tue, 04 November 2008 19:36 By: rleishman
Purgeing data 9i and 10g By: jack00423 on Tue, 04 November 2008	4	1752	Tue, 04 November 2008 19:35 By: Kevin Meade
Query Tuning Oracle 10g By: rsoma on Fri, 31 October 2008	3	1755	Tue, 04 November 2008 13:52 By: coleing
Gather statistics for scale up / down decision process By: tsteinmaurer on Tue, 28 October 2008	3	1911	Tue, 04 November 2008 08:41 By: JRowbottom
gather stats how? By: ArvindBhope on Thu, 23 October 2008	13	4803	Tue, 04 November 2008 07:04 By: JRowbottom
select does a full table scan. 130.000.000 rows Oracle 9 By: mclu on Fri, 31 October 2008	5	3516	Tue, 04 November 2008 05:34 By: michael_bialik
Whether Statistics upto date or not oracle 9i By: Olivia on Tue, 04 November 2008	2	1539	Tue, 04 November 2008 04:58 By: Olivia
Packaged procedure tuning Oracle,10g,Windows XP By: getritesh on Sun, 02 November 2008	1	1363	Sun, 02 November 2008 22:25 By: rleishman
alter system set events oracle10g By: sasnrock on Sun, 02 November 2008	3	8316	Sun, 02 November 2008 10:15 By: sasnrock
Insert Oddly Alters Explain Plan Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi By: annagel on Tue, 28 October 2008	4	3010	Thu, 30 October 2008 09:43 By: annagel
Performance issues between Databases Oracle 10.2.0 By: eigeneachse on Mon, 27 October 2008	12	4530	Thu, 30 October 2008 08:06 By: Kevin Meade
Thread 1 cannot allocate new log, sequence 8823--Checkpoint not complete Oracle 10.2, Win 2003 By: youngb912 on Wed, 22 October 2008	6	13502	Wed, 29 October 2008 20:56 By: ebrian
Do you know how to find out the underlying tables for a dynamic view? Oracle 11g, 11.1.0, Windows 2K3 By: efachim on Fri, 24 October 2008	2	1461	Fri, 24 October 2008 16:50 By: efachim
High CPU Utilizaion 10.2.0.2 By: varunvir on Wed, 22 October 2008	4	5186	Thu, 23 October 2008 23:21 By: Michel Cadot
oracle volume Oracle 10g By: deepshikhahcl on Thu, 23 October 2008	1	1344	Thu, 23 October 2008 05:35 By: Michel Cadot
What is the significance of this data dictionary column? Oracle 11g, 11.1.0, Linux By: efachim on Wed, 22 October 2008	3	1871	Wed, 22 October 2008 23:08 By: Michel Cadot
Looking for a better access method Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi By: annagel on Tue, 21 October 2008	7	4021	Wed, 22 October 2008 19:39 By: annagel
Bitmap conversion By: ArvindBhope on Wed, 22 October 2008	0	6529	Wed, 22 October 2008 14:06 By: ArvindBhope
response time By: ArvindBhope on Wed, 22 October 2008	3	1371	Wed, 22 October 2008 07:58 By: Michel Cadot
Need help in tuning this query By: apps_user on Mon, 20 October 2008	5	2119	Wed, 22 October 2008 03:20 By: Alessandro Rossi
Query Rewrite in Materialised Views (merged) By: hexmanju on Wed, 22 October 2008	3	1529	Wed, 22 October 2008 03:00 By: hexmanju
Performance Query Tuning help By: rsoma on Fri, 17 October 2008	6	2293	Tue, 21 October 2008 22:27 By: rsoma
Please help me Tune this query By: rak007 on Thu, 16 October 2008	4	3894	Tue, 21 October 2008 16:36 By: michael_bialik