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
gather stats estimated By: ArvindBhope on Mon, 11 August 2008	3	2163	Mon, 11 August 2008 10:13 By: Michel Cadot
shink blob column oracle 10.1.0.3 By: ankush_chawla on Mon, 11 August 2008	0	6811	Mon, 11 August 2008 08:23 By: ankush_chawla
Performance issue Oracle 9.2.0.1.0 By: manoj12 on Wed, 06 August 2008	23	4875	Sun, 10 August 2008 07:24 By: michael_bialik
How to simplify this pivot query By: bztom33 on Thu, 20 September 2007	8	3871	Sat, 09 August 2008 07:05 By: bztom33
UNION and UNION ALL discrepancy Oracle 9i, Solaris By: bijou on Fri, 01 August 2008	13	6683	Thu, 07 August 2008 21:52 By: rleishman
Index is used still problem By: bubbly on Wed, 06 August 2008	5	2354	Thu, 07 August 2008 03:36 By: sunil_v_mishra
How to estimate query response time and number of rows without executing query Oracle 10.2.0.3 on Sun Solaris 5.10 By: gkodakalla on Thu, 07 August 2008	4	3022	Thu, 07 August 2008 02:52 By: gkodakalla
need assist to delete histograms oracle 10.2.0.3 solaris 10 By: kumar.joy on Wed, 06 August 2008	2	3441	Wed, 06 August 2008 12:09 By: Mahesh Rajendran
Help me tune the query Oracle 9.0.0.2 By: thalladas on Wed, 06 August 2008	1	1787	Wed, 06 August 2008 11:19 By: BlackSwan
How gathering of stats/ analyze stats work? 10g By: beetel on Wed, 06 August 2008	4	2156	Wed, 06 August 2008 08:48 By: BlackSwan
sql consumes more cpu oracle 10g, 10.2.0.1, Linux AS 3 By: guyj on Wed, 06 August 2008	5	2351	Wed, 06 August 2008 05:56 By: rajatratewal
to decide pctused,pctfree in Oracle8i (merged) By: chinmayikkalki on Wed, 06 August 2008	3	1832	Wed, 06 August 2008 04:11 By: Michel Cadot
buffer cache handles oracle 10g By: holdersav2000 on Tue, 05 August 2008	6	4049	Wed, 06 August 2008 02:17 By: holdersav2000
selectivity in index usage Oracle 9i By: krshnn592 on Tue, 05 August 2008	3	2226	Tue, 05 August 2008 10:50 By: Michel Cadot
QUERY REWRITING 9.2.0.7.WONDOWS SERVER 2003 By: jayarajkrishna on Sun, 03 August 2008	2	2114	Tue, 05 August 2008 08:24 By: JRowbottom
DB link query. 10.2.0.3 By: sonumalhi on Mon, 04 August 2008	1	4543	Mon, 04 August 2008 16:26 By: BlackSwan
Merging large amounts of data into large tables oracle 10 By: zzasteven on Mon, 04 August 2008	6	4331	Mon, 04 August 2008 14:04 By: zzasteven
Need suggestion for a better query. By: pravin3032 on Tue, 22 July 2008	6	3506	Mon, 04 August 2008 07:27 By: pravin3032
SQL Tuning Methods & Books 9i/10g By: oraclegyaani on Sun, 03 August 2008	1	1836	Sun, 03 August 2008 11:51 By: Michel Cadot
CREATE TABLE using SEQUENCE ORacle 9i By: ravashingravi on Sat, 02 August 2008	3	4086	Sun, 03 August 2008 01:48 By: Michel Cadot
statspack report Oracle 9i By: manoj12 on Thu, 31 July 2008	8	5115	Sun, 03 August 2008 01:40 By: Michel Cadot
HIGH no of LOCKS exclusive in tables for UPDATE Statement Oracle 9.2.0.8 By: udara on Mon, 21 July 2008	3	2516	Sat, 02 August 2008 20:59 By: Kevin Meade
criteria for partitioning Oracle 10gR2 By: eaganfox on Tue, 22 July 2008	5	2576	Fri, 01 August 2008 01:24 By: Michel Cadot
Adding INDEX_DESC hint slow down the query Oracle9i By: shrinika on Mon, 28 July 2008	3	5460	Thu, 31 July 2008 13:28 By: shrinika
Report hangs ORACLE 10.2.0.4.0, WINDOWS 2003 SERVER SP2 By: srini_thiru on Thu, 31 July 2008	1	2125	Thu, 31 July 2008 08:57 By: BlackSwan
Performance issues after Database Hang during backup Oracle 10g By: virmahi on Mon, 28 July 2008	7	3557	Thu, 31 July 2008 06:28 By: Mahesh Rajendran
ora-04030 By: srini_thiru on Fri, 25 July 2008	8	12503	Thu, 31 July 2008 05:42 By: Michel Cadot
Reverse key index By: getritesh on Tue, 29 July 2008	8	4251	Wed, 30 July 2008 22:52 By: rleishman
Performance Oracle 9i(9.2.0.1.0) By: manoj12 on Thu, 24 July 2008	8	3127	Tue, 29 July 2008 22:09 By: rleishman
Stale Statisics Oracle 10g,Rel 2 ,Linux AS4 By: rsreddy28 on Tue, 29 July 2008	1	2011	Tue, 29 July 2008 05:24 By: Michel Cadot
gather stats By: ArvindBhope on Tue, 29 July 2008	3	1844	Tue, 29 July 2008 03:19 By: Michel Cadot
Tuning 'LIKE' Clause Oracle,10g,Windows XP By: getritesh on Mon, 28 July 2008	2	2775	Mon, 28 July 2008 14:24 By: Michel Cadot
type tables in plsql/ variable IN list By: eaganfox on Fri, 25 July 2008	3	2510	Fri, 25 July 2008 17:54 By: coleing
need help to optimize the query oracle 10.2.0.3 solaris 10 By: skumar.dba on Wed, 23 July 2008	1	1688	Thu, 24 July 2008 22:26 By: rleishman
need assistance to tune the query solarin 5.10, oracle 10.2.0.3 By: kumar.joy on Thu, 24 July 2008	8	2937	Thu, 24 July 2008 22:22 By: rleishman
Testing of generated test data from Sequence oracle 10g By: sreechaitu on Thu, 24 July 2008	1	1694	Thu, 24 July 2008 13:08 By: BlackSwan
how find SGA size is sufficient or not? oracle 10.2.0.3 solaris 10 By: skumar.dba on Tue, 22 July 2008	8	17822	Thu, 24 July 2008 01:44 By: Michel Cadot
Is possible to turn the following into a view Oracle 10g By: bztom33 on Mon, 21 July 2008	4	2270	Wed, 23 July 2008 16:03 By: Kevin Meade
high cost oracle 10g,TOAD By: balaji1482 on Thu, 17 July 2008	12	3554	Wed, 23 July 2008 10:28 By: balaji1482
Avoiding : ORA-00470: LGWR process terminated with error By: Josphat Kioko on Tue, 12 October 2004	1	18590	Wed, 23 July 2008 07:54 By: sunil_v_mishra

Pages (119): [ « ‹ 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 › »]

Goto Forum:

[ Syndicate this forum (XML) ] [

]

Legend

New Messages

No New messages

Locked (w/ unread messages) Locked

Locked

Moved to another forum

Current Time: Sun Aug 17 16:56:14 CDT 2025