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
Materialized View Refresh Performance Oracle 10g By: amorphous4u on Mon, 17 November 2008	2	3663	Tue, 18 November 2008 13:30 By: coleing
jobsq slave 10g ,linux By: vinniora on Mon, 17 November 2008	1	1936	Tue, 18 November 2008 01:07 By: Michel Cadot
Performance tuning for a simple table with 2million records Oracle 10g, windows server series By: santhoshmohan on Wed, 12 November 2008	2	2381	Mon, 17 November 2008 21:51 By: Oyunbold
Query optimization By: prem18 on Mon, 17 November 2008	2	2259	Mon, 17 November 2008 19:44 By: rleishman
Wait events 10g,linux By: vinniora on Mon, 17 November 2008	1	1723	Mon, 17 November 2008 04:51 By: Michel Cadot
Error in Materialized view refresh Oracle Database By: mac4rfree on Fri, 14 November 2008	3	3393	Sat, 15 November 2008 14:04 By: Littlefoot
package performance oracle10.2.0.3 By: skumar.dba on Thu, 13 November 2008	3	2057	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	4641	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	2420	Wed, 12 November 2008 22:58 By: kummi_gh
Find speed oracle 10 g By: pointers on Wed, 12 November 2008	6	2387	Wed, 12 November 2008 10:55 By: Michel Cadot
Query taking very long time Oracle 10g By: virmahi on Fri, 07 November 2008	4	3006	Tue, 11 November 2008 20:44 By: rleishman
Dunsel Joins 9i, 10g, 11g By: Kevin Meade on Mon, 10 November 2008	4	4139	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	1820	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	2041	Tue, 11 November 2008 02:07 By: Littlefoot
SESSION CPU AIX 10G By: lioracle on Mon, 10 November 2008	5	2190	Mon, 10 November 2008 11:27 By: Michel Cadot
Query Tuning O9i By: manoj12 on Mon, 10 November 2008	1	2224	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	1782	Fri, 07 November 2008 01:06 By: virmahi
Performance: partition/index not used Oracle 10.2G By: wakula on Wed, 05 November 2008	1	1712	Thu, 06 November 2008 01:28 By: rleishman
Index a system view 10g on IBM AIX By: serkzc on Wed, 05 November 2008	1	1866	Wed, 05 November 2008 23:29 By: Michel Cadot
Dirty database_Performance issues By: neena_forum on Tue, 04 November 2008	2	2430	Tue, 04 November 2008 19:36 By: rleishman
Purgeing data 9i and 10g By: jack00423 on Tue, 04 November 2008	4	2783	Tue, 04 November 2008 19:35 By: Kevin Meade
Query Tuning Oracle 10g By: rsoma on Fri, 31 October 2008	3	1974	Tue, 04 November 2008 13:52 By: coleing
Gather statistics for scale up / down decision process By: tsteinmaurer on Tue, 28 October 2008	3	2768	Tue, 04 November 2008 08:41 By: JRowbottom
gather stats how? By: ArvindBhope on Thu, 23 October 2008	13	5253	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	3743	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	2227	Tue, 04 November 2008 04:58 By: Olivia
Packaged procedure tuning Oracle,10g,Windows XP By: getritesh on Sun, 02 November 2008	1	1588	Sun, 02 November 2008 22:25 By: rleishman
alter system set events oracle10g By: sasnrock on Sun, 02 November 2008	3	8759	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	3342	Thu, 30 October 2008 09:43 By: annagel
Performance issues between Databases Oracle 10.2.0 By: eigeneachse on Mon, 27 October 2008	12	5050	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	14844	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	2276	Fri, 24 October 2008 16:50 By: efachim
High CPU Utilizaion 10.2.0.2 By: varunvir on Wed, 22 October 2008	4	5519	Thu, 23 October 2008 23:21 By: Michel Cadot
oracle volume Oracle 10g By: deepshikhahcl on Thu, 23 October 2008	1	1842	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	2152	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	4374	Wed, 22 October 2008 19:39 By: annagel
Bitmap conversion By: ArvindBhope on Wed, 22 October 2008	0	6740	Wed, 22 October 2008 14:06 By: ArvindBhope
response time By: ArvindBhope on Wed, 22 October 2008	3	1812	Wed, 22 October 2008 07:58 By: Michel Cadot
Need help in tuning this query By: apps_user on Mon, 20 October 2008	5	2422	Wed, 22 October 2008 03:20 By: Alessandro Rossi
Query Rewrite in Materialised Views (merged) By: hexmanju on Wed, 22 October 2008	3	2393	Wed, 22 October 2008 03:00 By: hexmanju