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
Querry performance By: sreenu80 on Wed, 19 November 2008	5	3587	Wed, 19 November 2008 22:58 By: Michel Cadot
parallel hint 10g By: maheshmhs on Wed, 19 November 2008	1	2280	Wed, 19 November 2008 03:41 By: tahpush
Materialized View Refresh Performance Oracle 10g By: amorphous4u on Mon, 17 November 2008	2	3944	Tue, 18 November 2008 13:30 By: coleing
jobsq slave 10g ,linux By: vinniora on Mon, 17 November 2008	1	2132	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	2666	Mon, 17 November 2008 21:51 By: Oyunbold
Query optimization By: prem18 on Mon, 17 November 2008	2	2549	Mon, 17 November 2008 19:44 By: rleishman
Wait events 10g,linux By: vinniora on Mon, 17 November 2008	1	1969	Mon, 17 November 2008 04:51 By: Michel Cadot
Error in Materialized view refresh Oracle Database By: mac4rfree on Fri, 14 November 2008	3	3648	Sat, 15 November 2008 14:04 By: Littlefoot
package performance oracle10.2.0.3 By: skumar.dba on Thu, 13 November 2008	3	2497	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	5136	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	2694	Wed, 12 November 2008 22:58 By: kummi_gh
Find speed oracle 10 g By: pointers on Wed, 12 November 2008	6	2910	Wed, 12 November 2008 10:55 By: Michel Cadot
Query taking very long time Oracle 10g By: virmahi on Fri, 07 November 2008	4	3326	Tue, 11 November 2008 20:44 By: rleishman
Dunsel Joins 9i, 10g, 11g By: Kevin Meade on Mon, 10 November 2008	4	4533	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	2042	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	2383	Tue, 11 November 2008 02:07 By: Littlefoot
SESSION CPU AIX 10G By: lioracle on Mon, 10 November 2008	5	2564	Mon, 10 November 2008 11:27 By: Michel Cadot
Query Tuning O9i By: manoj12 on Mon, 10 November 2008	1	2509	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	2064	Fri, 07 November 2008 01:06 By: virmahi
Performance: partition/index not used Oracle 10.2G By: wakula on Wed, 05 November 2008	1	2033	Thu, 06 November 2008 01:28 By: rleishman
Index a system view 10g on IBM AIX By: serkzc on Wed, 05 November 2008	1	2130	Wed, 05 November 2008 23:29 By: Michel Cadot
Dirty database_Performance issues By: neena_forum on Tue, 04 November 2008	2	2684	Tue, 04 November 2008 19:36 By: rleishman
Purgeing data 9i and 10g By: jack00423 on Tue, 04 November 2008	4	3118	Tue, 04 November 2008 19:35 By: Kevin Meade
Query Tuning Oracle 10g By: rsoma on Fri, 31 October 2008	3	2298	Tue, 04 November 2008 13:52 By: coleing
Gather statistics for scale up / down decision process By: tsteinmaurer on Tue, 28 October 2008	3	3173	Tue, 04 November 2008 08:41 By: JRowbottom
gather stats how? By: ArvindBhope on Thu, 23 October 2008	13	5906	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	4284	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	2575	Tue, 04 November 2008 04:58 By: Olivia
Packaged procedure tuning Oracle,10g,Windows XP By: getritesh on Sun, 02 November 2008	1	1865	Sun, 02 November 2008 22:25 By: rleishman
alter system set events oracle10g By: sasnrock on Sun, 02 November 2008	3	9232	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	3819	Thu, 30 October 2008 09:43 By: annagel
Performance issues between Databases Oracle 10.2.0 By: eigeneachse on Mon, 27 October 2008	12	6051	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	15500	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	2568	Fri, 24 October 2008 16:50 By: efachim
High CPU Utilizaion 10.2.0.2 By: varunvir on Wed, 22 October 2008	4	6022	Thu, 23 October 2008 23:21 By: Michel Cadot
oracle volume Oracle 10g By: deepshikhahcl on Thu, 23 October 2008	1	2081	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	2544	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	5027	Wed, 22 October 2008 19:39 By: annagel
Bitmap conversion By: ArvindBhope on Wed, 22 October 2008	0	6938	Wed, 22 October 2008 14:06 By: ArvindBhope
response time By: ArvindBhope on Wed, 22 October 2008	3	2153	Wed, 22 October 2008 07:58 By: Michel Cadot