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
SQL statement tuning Oracle 8i By: chinmayikkalki on Thu, 01 May 2008	4	2575	Fri, 02 May 2008 02:50 By: JRowbottom
tuning time consuming queries oracle 8i By: chinmayikkalki on Wed, 30 April 2008	1	2146	Wed, 30 April 2008 22:56 By: rleishman
Costly update By: poratips on Mon, 28 April 2008	2	1745	Tue, 29 April 2008 12:24 By: poratips
check oracle job status By: ora_2007 on Thu, 24 April 2008	2	8415	Sun, 27 April 2008 03:31 By: michael_bialik
How to check for Null values By: vkrn on Thu, 24 April 2008	2	1924	Thu, 24 April 2008 08:27 By: vkrn
Sql query tuning 9.0.4.0 By: user71408 on Tue, 15 April 2008	20	6204	Thu, 24 April 2008 03:30 By: user71408
Performance Tuning By: ajexpert on Mon, 21 April 2008	11	3266	Mon, 21 April 2008 21:36 By: rleishman
Performance isssue 9.0.4.0 By: user71408 on Mon, 21 April 2008	13	4852	Mon, 21 April 2008 12:52 By: BlackSwan
Statspack Report 9.2.0.6.0 IBM AIX By: pokhraj_das on Mon, 21 April 2008	3	1947	Mon, 21 April 2008 12:48 By: varu123
more reloads By: pramod_garre on Fri, 18 April 2008	4	2322	Sat, 19 April 2008 01:11 By: Michel Cadot
Rosco's Performance Tuning Guide By: rleishman on Thu, 28 September 2006	12	6848	Fri, 18 April 2008 20:26 By: rleishman
how can i execute this query faster Oracle 10g R1 By: anee459 on Mon, 14 April 2008	4	2092	Thu, 17 April 2008 23:39 By: gopu_g
Enabling Trace file generation. Oracle9i Enterprise Edition Release 9.2.0.7.0 - 64bit Production By: moshea on Thu, 17 April 2008	2	2335	Thu, 17 April 2008 11:06 By: moshea
Query taking time to execute in front end(Oracle 10g R2) Oracle 10g R2. By: anee459 on Mon, 14 April 2008	12	3102	Thu, 17 April 2008 06:13 By: anee459
tuning the view (merged) By: user71408 on Wed, 16 April 2008	5	2168	Thu, 17 April 2008 04:52 By: gopu_g
Loading objects in parallel? Oracle 10.2.0.3 on Sun OS 5.10 By: Kingfisher on Wed, 16 April 2008	4	2346	Thu, 17 April 2008 03:53 By: Kingfisher
Performance discrepancies Oracle 9i/10g Window2000 By: gold_oracl on Tue, 15 April 2008	7	2834	Tue, 15 April 2008 22:23 By: rleishman
INDEX ANALYZE 10g AIX By: lioracle on Tue, 15 April 2008	5	2640	Tue, 15 April 2008 09:47 By: JRowbottom
bulk collect help in production XP ,Oracle 10g By: swas_fly on Wed, 09 April 2008	8	3383	Mon, 14 April 2008 22:10 By: rleishman
Poor performance of query with VPD policy 10gR1, 10.1.0.3 4 node RAC on AIX 5.2 64bit By: kwalz58 on Thu, 20 March 2008	8	7884	Mon, 14 April 2008 07:34 By: kwalz58
Performance tuning with indexes By: swas_fly on Wed, 09 April 2008	11	3621	Sun, 13 April 2008 03:01 By: swas_fly
'DISTINCT' vs 'GROUP by' By: vkrn on Fri, 11 April 2008	8	16937	Fri, 11 April 2008 10:48 By: Michel Cadot
full tablescan though indexes exist By: sandhyaa on Wed, 09 April 2008	4	4448	Fri, 11 April 2008 09:58 By: skooman
regarding update on million of records orcale 9i By: singh.neerajin on Wed, 09 April 2008	11	3017	Fri, 11 April 2008 02:04 By: S.Rajaram
database buffer cache 10g By: balaji1482 on Thu, 10 April 2008	1	2112	Thu, 10 April 2008 09:30 By: JRowbottom
Cursor_Sharing settings not working (merged) By: OraKaran on Wed, 09 April 2008	5	4224	Thu, 10 April 2008 08:13 By: OraKaran
How to reduce the execution timing of SQL Query SQL*Plus: Release 3.3.4.0.0, Oracle7:7.3.4.0.0 By: AnamikaChaudhary on Fri, 28 March 2008	15	3427	Thu, 10 April 2008 03:18 By: rleishman
Order by with Nulls -- Performance Oracle 9i By: MarcL on Wed, 09 April 2008	3	1978	Wed, 09 April 2008 22:06 By: rleishman
Cursors not closed at the database level 10gR2, Windows By: plshelp on Wed, 09 April 2008	14	3143	Wed, 09 April 2008 15:25 By: BlackSwan
Index Creation By: ora_2007 on Tue, 08 April 2008	2	1936	Wed, 09 April 2008 08:57 By: smartin
Two similar queries, two different plans Oracle 8i By: smartin on Wed, 02 April 2008	9	4894	Wed, 09 April 2008 08:50 By: smartin
Reg Hash Join in Performance tunning toad 9.1 ,oracle 10g By: ram anand on Tue, 08 April 2008	4	4063	Tue, 08 April 2008 07:42 By: Michel Cadot
Performance issue 10G/Unix By: liamadherne on Mon, 07 April 2008	2	1776	Tue, 08 April 2008 02:33 By: michael_bialik
Query Tuning Oracle 9.2 By: chintu00 on Fri, 04 April 2008	12	4149	Mon, 07 April 2008 02:57 By: rleishman
How to increase the database size of oracle 9i Oracle 9i By: manoj12 on Fri, 04 April 2008	3	3916	Fri, 04 April 2008 10:12 By: Michel Cadot
update takes much time to execute By: ora_2007 on Wed, 02 April 2008	5	2281	Thu, 03 April 2008 15:51 By: michael_bialik
Which Performance hint we should use when? By: manoj12 on Thu, 03 April 2008	3	1904	Thu, 03 April 2008 07:30 By: manoj12
How to decrease time to execute SUM function? oracle10gR2 Solaris5.9 By: wxfjordan on Tue, 01 April 2008	6	2616	Thu, 03 April 2008 07:05 By: sispk6
query tuning using explain plan oracle , linux By: sheldon1982 on Wed, 02 April 2008	4	2776	Wed, 02 April 2008 21:26 By: rleishman
insert took a lnog time. sun 10g By: lioracle on Wed, 02 April 2008	3	1962	Wed, 02 April 2008 21:21 By: rleishman