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 issue Oracle 9.2.0.1.0 By: manoj12 on Wed, 06 August 2008	23	3975	Sun, 10 August 2008 07:24 By: michael_bialik
How to simplify this pivot query By: bztom33 on Thu, 20 September 2007	8	3402	Sat, 09 August 2008 07:05 By: bztom33
UNION and UNION ALL discrepancy Oracle 9i, Solaris By: bijou on Fri, 01 August 2008	13	6347	Thu, 07 August 2008 21:52 By: rleishman
Index is used still problem By: bubbly on Wed, 06 August 2008	5	2159	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	2748	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	3206	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	1632	Wed, 06 August 2008 11:19 By: BlackSwan
How gathering of stats/ analyze stats work? 10g By: beetel on Wed, 06 August 2008	4	1897	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	2172	Wed, 06 August 2008 05:56 By: rajatratewal
to decide pctused,pctfree in Oracle8i (merged) By: chinmayikkalki on Wed, 06 August 2008	3	1601	Wed, 06 August 2008 04:11 By: Michel Cadot
buffer cache handles oracle 10g By: holdersav2000 on Tue, 05 August 2008	6	3749	Wed, 06 August 2008 02:17 By: holdersav2000
selectivity in index usage Oracle 9i By: krshnn592 on Tue, 05 August 2008	3	2013	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	1942	Tue, 05 August 2008 08:24 By: JRowbottom
DB link query. 10.2.0.3 By: sonumalhi on Mon, 04 August 2008	1	4395	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	4058	Mon, 04 August 2008 14:04 By: zzasteven
Need suggestion for a better query. By: pravin3032 on Tue, 22 July 2008	6	3271	Mon, 04 August 2008 07:27 By: pravin3032
SQL Tuning Methods & Books 9i/10g By: oraclegyaani on Sun, 03 August 2008	1	1699	Sun, 03 August 2008 11:51 By: Michel Cadot
CREATE TABLE using SEQUENCE ORacle 9i By: ravashingravi on Sat, 02 August 2008	3	3924	Sun, 03 August 2008 01:48 By: Michel Cadot
statspack report Oracle 9i By: manoj12 on Thu, 31 July 2008	8	4840	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	2356	Sat, 02 August 2008 20:59 By: Kevin Meade
criteria for partitioning Oracle 10gR2 By: eaganfox on Tue, 22 July 2008	5	2412	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	5298	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	1963	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	3267	Thu, 31 July 2008 06:28 By: Mahesh Rajendran
ora-04030 By: srini_thiru on Fri, 25 July 2008	8	12102	Thu, 31 July 2008 05:42 By: Michel Cadot
Reverse key index By: getritesh on Tue, 29 July 2008	8	3880	Wed, 30 July 2008 22:52 By: rleishman
Performance Oracle 9i(9.2.0.1.0) By: manoj12 on Thu, 24 July 2008	8	2823	Tue, 29 July 2008 22:09 By: rleishman
Stale Statisics Oracle 10g,Rel 2 ,Linux AS4 By: rsreddy28 on Tue, 29 July 2008	1	1906	Tue, 29 July 2008 05:24 By: Michel Cadot
gather stats By: ArvindBhope on Tue, 29 July 2008	3	1675	Tue, 29 July 2008 03:19 By: Michel Cadot
Tuning 'LIKE' Clause Oracle,10g,Windows XP By: getritesh on Mon, 28 July 2008	2	2570	Mon, 28 July 2008 14:24 By: Michel Cadot
type tables in plsql/ variable IN list By: eaganfox on Fri, 25 July 2008	3	2230	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	1498	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	2740	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	1559	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	17486	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	1973	Wed, 23 July 2008 16:03 By: Kevin Meade
high cost oracle 10g,TOAD By: balaji1482 on Thu, 17 July 2008	12	3190	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	18315	Wed, 23 July 2008 07:54 By: sunil_v_mishra
performance issues in insert stmt Oracle, 10g, windows XP By: jyothsna1612 on Wed, 23 July 2008	1	1808	Wed, 23 July 2008 05:28 By: Michel Cadot
Slow query with customer data Oracle 10.2.0.3.0 on Solaris 10 By: elmu on Thu, 17 July 2008	8	4208	Tue, 22 July 2008 13:19 By: Kriptas

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: Sat Feb 15 02:08:09 CST 2025