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	3872	Sun, 10 August 2008 07:24 By: michael_bialik
How to simplify this pivot query By: bztom33 on Thu, 20 September 2007	8	3264	Sat, 09 August 2008 07:05 By: bztom33
UNION and UNION ALL discrepancy Oracle 9i, Solaris By: bijou on Fri, 01 August 2008	13	6301	Thu, 07 August 2008 21:52 By: rleishman
Index is used still problem By: bubbly on Wed, 06 August 2008	5	2135	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	2725	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	3155	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	1616	Wed, 06 August 2008 11:19 By: BlackSwan
How gathering of stats/ analyze stats work? 10g By: beetel on Wed, 06 August 2008	4	1863	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	2129	Wed, 06 August 2008 05:56 By: rajatratewal
to decide pctused,pctfree in Oracle8i (merged) By: chinmayikkalki on Wed, 06 August 2008	3	1586	Wed, 06 August 2008 04:11 By: Michel Cadot
buffer cache handles oracle 10g By: holdersav2000 on Tue, 05 August 2008	6	3683	Wed, 06 August 2008 02:17 By: holdersav2000
selectivity in index usage Oracle 9i By: krshnn592 on Tue, 05 August 2008	3	1927	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	1908	Tue, 05 August 2008 08:24 By: JRowbottom
DB link query. 10.2.0.3 By: sonumalhi on Mon, 04 August 2008	1	4341	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	3996	Mon, 04 August 2008 14:04 By: zzasteven
Need suggestion for a better query. By: pravin3032 on Tue, 22 July 2008	6	3213	Mon, 04 August 2008 07:27 By: pravin3032
SQL Tuning Methods & Books 9i/10g By: oraclegyaani on Sun, 03 August 2008	1	1677	Sun, 03 August 2008 11:51 By: Michel Cadot
CREATE TABLE using SEQUENCE ORacle 9i By: ravashingravi on Sat, 02 August 2008	3	3889	Sun, 03 August 2008 01:48 By: Michel Cadot
statspack report Oracle 9i By: manoj12 on Thu, 31 July 2008	8	4793	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	2338	Sat, 02 August 2008 20:59 By: Kevin Meade
criteria for partitioning Oracle 10gR2 By: eaganfox on Tue, 22 July 2008	5	2372	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	5214	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	1909	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	3238	Thu, 31 July 2008 06:28 By: Mahesh Rajendran
ora-04030 By: srini_thiru on Fri, 25 July 2008	8	12040	Thu, 31 July 2008 05:42 By: Michel Cadot
Reverse key index By: getritesh on Tue, 29 July 2008	8	3820	Wed, 30 July 2008 22:52 By: rleishman
Performance Oracle 9i(9.2.0.1.0) By: manoj12 on Thu, 24 July 2008	8	2697	Tue, 29 July 2008 22:09 By: rleishman
Stale Statisics Oracle 10g,Rel 2 ,Linux AS4 By: rsreddy28 on Tue, 29 July 2008	1	1873	Tue, 29 July 2008 05:24 By: Michel Cadot
gather stats By: ArvindBhope on Tue, 29 July 2008	3	1620	Tue, 29 July 2008 03:19 By: Michel Cadot
Tuning 'LIKE' Clause Oracle,10g,Windows XP By: getritesh on Mon, 28 July 2008	2	2508	Mon, 28 July 2008 14:24 By: Michel Cadot
type tables in plsql/ variable IN list By: eaganfox on Fri, 25 July 2008	3	2208	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	1476	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	2697	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	1532	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	17394	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	1929	Wed, 23 July 2008 16:03 By: Kevin Meade
high cost oracle 10g,TOAD By: balaji1482 on Thu, 17 July 2008	12	3157	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	18219	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	1792	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	4158	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: Fri Nov 22 18:07:57 CST 2024