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
How to delete records without generating redo logs? Oracle 10g By: sudheer0886 on Thu, 25 September 2008	11	14104	Thu, 25 September 2008 22:55 By: rleishman
Slow Execution Stored Procedure with cursors Oracle, 8, Windows 2003 By: sabishs on Thu, 25 September 2008	1	3743	Thu, 25 September 2008 09:36 By: JRowbottom
Index Creation with Parallel Option Oracle 10g Rel 2 By: faiz_hyd on Wed, 24 September 2008	3	1989	Thu, 25 September 2008 09:09 By: faiz_hyd
Improve in-memory sort performance Oracle 10g on Linux By: kpalania on Wed, 24 September 2008	3	3689	Thu, 25 September 2008 05:15 By: rleishman
Stroring Hierarchical Data(XML) into relational Table Oracle 9.2,XP By: rajatratewal on Mon, 14 July 2008	21	5811	Wed, 24 September 2008 17:11 By: guru_karnam
procedure tuning oracle 10g By: pointers on Wed, 24 September 2008	3	2008	Wed, 24 September 2008 11:01 By: JRowbottom
Query performance Oracle 10g By: ora_2007 on Mon, 22 September 2008	9	2843	Tue, 23 September 2008 13:13 By: Kriptas
First_rows Versus All_rows Oracle 9.2.0.8 By: shrinika on Mon, 22 September 2008	3	6653	Tue, 23 September 2008 08:48 By: shrinika
v$sess_io info is not changing. oracle 9.2.0.8 By: shrinika on Sun, 21 September 2008	2	3529	Mon, 22 September 2008 14:17 By: shrinika
Parallel inserts Oracle 10g,Rel 2 ,Linux AS4 By: rsreddy28 on Mon, 22 September 2008	1	1439	Mon, 22 September 2008 09:00 By: Michel Cadot
Query taking long time By: sreenu80 on Wed, 17 September 2008	4	1914	Mon, 22 September 2008 05:27 By: joshirish
Why This Execution Plan By: scottwmackey on Fri, 19 September 2008	22	5232	Mon, 22 September 2008 00:54 By: scottwmackey
How to change value of CLUSTERING_FACTOR of index oracle 10g hpux11 By: reyazan on Thu, 18 September 2008	4	2687	Sun, 21 September 2008 14:38 By: harrysmall3
Relationsip between Parallel Degree & Clustering Factor Oracle 10g Rel 2 ( 2 Node RAC ) , Solaris 10 By: feroze on Wed, 10 September 2008	4	2510	Sun, 21 September 2008 09:45 By: VivekSharma
Partitioned table growing too fast 10.2.0.3 on Solaris 8 By: IMRAN2008 on Fri, 19 September 2008	5	2136	Sat, 20 September 2008 13:27 By: Michel Cadot
Tuning query approach Oracle 9i By: Olivia on Mon, 15 September 2008	11	3353	Sat, 20 September 2008 02:16 By: Kriptas
How to avoid TableAccessFull Performance Tuning By: srivishnuhari on Wed, 17 September 2008	5	2270	Fri, 19 September 2008 15:20 By: harrysmall3
Find out what query is running for specific session? oracle 9.2.0.8 By: shrinika on Thu, 18 September 2008	2	1825	Fri, 19 September 2008 14:32 By: shrinika
SQL query performance issue By: kirtani on Thu, 11 September 2008	31	6530	Thu, 18 September 2008 17:12 By: harrysmall3
How the Query works By: basmraj on Thu, 18 September 2008	1	1366	Thu, 18 September 2008 08:46 By: Michel Cadot
dbms_stats 10.2.0.1 Solaris By: varunvir on Wed, 17 September 2008	2	1899	Thu, 18 September 2008 08:38 By: varunvir
query performance related By: basmgokul on Mon, 15 September 2008	10	2612	Thu, 18 September 2008 07:54 By: Kriptas
Help in tuning query By: trupti111 on Mon, 01 September 2008	11	3021	Wed, 17 September 2008 23:23 By: trupti111
Performance Test: IS NOT NULL check Oracle 9.2.0.3 Unix By: harrysmall3 on Wed, 17 September 2008	0	6736	Wed, 17 September 2008 18:48 By: harrysmall3
Run time versus Elapsed time Oracle 9.2.0.8 By: shrinika on Wed, 17 September 2008	2	6628	Wed, 17 September 2008 15:40 By: shrinika
Index rebuild AIX 9.2.0.6 By: pokhraj_das on Wed, 17 September 2008	1	1540	Wed, 17 September 2008 00:55 By: Michel Cadot
Low oracle performance oracle 10g r2, HPUX By: Kriptas on Wed, 04 June 2008	29	6256	Tue, 16 September 2008 10:51 By: Kriptas
Database buffer cache monitoring Oracle 10g,solaris By: balaji1482 on Sun, 14 September 2008	5	2372	Tue, 16 September 2008 04:18 By: JRowbottom
Problem with SQL Plan By: majstoru on Thu, 11 September 2008	6	2316	Tue, 16 September 2008 04:09 By: JRowbottom
Statspack Report - Suggestion 9.2.0.7 By: nazbrian on Fri, 05 September 2008	8	5280	Tue, 16 September 2008 01:21 By: Brayan
Help - To get Row Source Operation in Tkprof Oracle 10g R2 on RHEL 4 By: orasaket on Mon, 15 September 2008	0	7107	Mon, 15 September 2008 08:54 By: orasaket
How to SQL Tuning? Explain Steps By: prashant.badhe on Sun, 14 September 2008	2	1615	Mon, 15 September 2008 04:01 By: Alessandro Rossi
temporary tablespace growing Oracle 10 R1-Linux By: dirish on Sun, 14 September 2008	3	1658	Sun, 14 September 2008 23:42 By: BlackSwan
TKPROF Fetch stats 10g By: ehegagoka on Sun, 14 September 2008	2	3467	Sun, 14 September 2008 14:05 By: ehegagoka
NumNull Stats By: ehegagoka on Fri, 12 September 2008	8	2541	Sat, 13 September 2008 15:26 By: ehegagoka
Interpreting Histograms 10g By: ehegagoka on Sat, 13 September 2008	0	6452	Sat, 13 September 2008 14:14 By: ehegagoka
New predicate increasing response time from 30 sec to 6 min Oracle 10.2.0.3.0 By: arunprasad_bh on Thu, 11 September 2008	5	2535	Fri, 12 September 2008 11:18 By: harrysmall3
Index not being used in Oracle 10g Oracle 10g By: Karena_Russell on Fri, 12 September 2008	2	5955	Fri, 12 September 2008 09:12 By: BlackSwan
TKPROF - High scattered read 9.2.0.7 By: Brayan on Fri, 12 September 2008	3	4872	Fri, 12 September 2008 03:24 By: rleishman
SUSE Oracle high CPU usgae problem Linux SUSE x86_64 GNU/Linux 2.6.5-7.97-smp/ Oracle Enterprise Edition 64 bit 10.2.3 By: crazypeter2005 on Thu, 11 September 2008	6	5385	Fri, 12 September 2008 02:57 By: crazypeter2005