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
UNION and UNION ALL discrepancy Oracle 9i, Solaris By: bijou on Fri, 01 August 2008	13	5366	Thu, 07 August 2008 21:52 By: rleishman
Index is used still problem By: bubbly on Wed, 06 August 2008	5	1618	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	2322	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	2919	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	1271	Wed, 06 August 2008 11:19 By: BlackSwan
How gathering of stats/ analyze stats work? 10g By: beetel on Wed, 06 August 2008	4	1611	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	1726	Wed, 06 August 2008 05:56 By: rajatratewal
to decide pctused,pctfree in Oracle8i (merged) By: chinmayikkalki on Wed, 06 August 2008	3	1369	Wed, 06 August 2008 04:11 By: Michel Cadot
buffer cache handles oracle 10g By: holdersav2000 on Tue, 05 August 2008	6	3447	Wed, 06 August 2008 02:17 By: holdersav2000
selectivity in index usage Oracle 9i By: krshnn592 on Tue, 05 August 2008	3	1467	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	1686	Tue, 05 August 2008 08:24 By: JRowbottom
DB link query. 10.2.0.3 By: sonumalhi on Mon, 04 August 2008	1	4082	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	3390	Mon, 04 August 2008 14:04 By: zzasteven
Need suggestion for a better query. By: pravin3032 on Tue, 22 July 2008	6	2949	Mon, 04 August 2008 07:27 By: pravin3032
SQL Tuning Methods & Books 9i/10g By: oraclegyaani on Sun, 03 August 2008	1	1392	Sun, 03 August 2008 11:51 By: Michel Cadot
CREATE TABLE using SEQUENCE ORacle 9i By: ravashingravi on Sat, 02 August 2008	3	3503	Sun, 03 August 2008 01:48 By: Michel Cadot
statspack report Oracle 9i By: manoj12 on Thu, 31 July 2008	8	4504	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	1907	Sat, 02 August 2008 20:59 By: Kevin Meade
criteria for partitioning Oracle 10gR2 By: eaganfox on Tue, 22 July 2008	5	2160	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	4972	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	1505	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	2782	Thu, 31 July 2008 06:28 By: Mahesh Rajendran
ora-04030 By: srini_thiru on Fri, 25 July 2008	8	10965	Thu, 31 July 2008 05:42 By: Michel Cadot
Reverse key index By: getritesh on Tue, 29 July 2008	8	2366	Wed, 30 July 2008 22:52 By: rleishman
Performance Oracle 9i(9.2.0.1.0) By: manoj12 on Thu, 24 July 2008	8	2430	Tue, 29 July 2008 22:09 By: rleishman
Stale Statisics Oracle 10g,Rel 2 ,Linux AS4 By: rsreddy28 on Tue, 29 July 2008	1	1306	Tue, 29 July 2008 05:24 By: Michel Cadot
gather stats By: ArvindBhope on Tue, 29 July 2008	3	1361	Tue, 29 July 2008 03:19 By: Michel Cadot
Tuning 'LIKE' Clause Oracle,10g,Windows XP By: getritesh on Mon, 28 July 2008	2	2090	Mon, 28 July 2008 14:24 By: Michel Cadot
type tables in plsql/ variable IN list By: eaganfox on Fri, 25 July 2008	3	1871	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	1290	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	2444	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	1297	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	17007	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	1679	Wed, 23 July 2008 16:03 By: Kevin Meade
high cost oracle 10g,TOAD By: balaji1482 on Thu, 17 July 2008	12	2704	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	17685	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	1309	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	3836	Tue, 22 July 2008 13:19 By: Kriptas
Better way to handle this query? Oracle 9i By: Olivia on Tue, 22 July 2008	5	2675	Tue, 22 July 2008 11:00 By: BlackSwan
optimize queries oracle 10g By: acarella on Fri, 18 July 2008	4	1949	Tue, 22 July 2008 08:30 By: michael_bialik

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 Jun 22 21:34:31 CDT 2024