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
Costly update By: poratips on Mon, 28 April 2008	2	1549	Tue, 29 April 2008 12:24 By: poratips
check oracle job status By: ora_2007 on Thu, 24 April 2008	2	7981	Sun, 27 April 2008 03:31 By: michael_bialik
How to check for Null values By: vkrn on Thu, 24 April 2008	2	1468	Thu, 24 April 2008 08:27 By: vkrn
Sql query tuning 9.0.4.0 By: user71408 on Tue, 15 April 2008	20	5641	Thu, 24 April 2008 03:30 By: user71408
Performance Tuning By: ajexpert on Mon, 21 April 2008	11	2917	Mon, 21 April 2008 21:36 By: rleishman
Performance isssue 9.0.4.0 By: user71408 on Mon, 21 April 2008	13	4362	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	1555	Mon, 21 April 2008 12:48 By: varu123
more reloads By: pramod_garre on Fri, 18 April 2008	4	1757	Sat, 19 April 2008 01:11 By: Michel Cadot
Rosco's Performance Tuning Guide By: rleishman on Thu, 28 September 2006	12	6346	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	1879	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	1958	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	2649	Thu, 17 April 2008 06:13 By: anee459
tuning the view (merged) By: user71408 on Wed, 16 April 2008	5	1753	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	1699	Thu, 17 April 2008 03:53 By: Kingfisher
Performance discrepancies Oracle 9i/10g Window2000 By: gold_oracl on Tue, 15 April 2008	7	2458	Tue, 15 April 2008 22:23 By: rleishman
INDEX ANALYZE 10g AIX By: lioracle on Tue, 15 April 2008	5	1947	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	2960	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	7407	Mon, 14 April 2008 07:34 By: kwalz58
Performance tuning with indexes By: swas_fly on Wed, 09 April 2008	11	3157	Sun, 13 April 2008 03:01 By: swas_fly
'DISTINCT' vs 'GROUP by' By: vkrn on Fri, 11 April 2008	8	16386	Fri, 11 April 2008 10:48 By: Michel Cadot
full tablescan though indexes exist By: sandhyaa on Wed, 09 April 2008	4	4149	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	2533	Fri, 11 April 2008 02:04 By: S.Rajaram
database buffer cache 10g By: balaji1482 on Thu, 10 April 2008	1	1780	Thu, 10 April 2008 09:30 By: JRowbottom
Cursor_Sharing settings not working (merged) By: OraKaran on Wed, 09 April 2008	5	3843	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	2987	Thu, 10 April 2008 03:18 By: rleishman
Order by with Nulls -- Performance Oracle 9i By: MarcL on Wed, 09 April 2008	3	1655	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	2677	Wed, 09 April 2008 15:25 By: BlackSwan
Index Creation By: ora_2007 on Tue, 08 April 2008	2	1702	Wed, 09 April 2008 08:57 By: smartin
Two similar queries, two different plans Oracle 8i By: smartin on Wed, 02 April 2008	9	4514	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	3492	Tue, 08 April 2008 07:42 By: Michel Cadot
Performance issue 10G/Unix By: liamadherne on Mon, 07 April 2008	2	1516	Tue, 08 April 2008 02:33 By: michael_bialik
Query Tuning Oracle 9.2 By: chintu00 on Fri, 04 April 2008	12	2883	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	3529	Fri, 04 April 2008 10:12 By: Michel Cadot
update takes much time to execute By: ora_2007 on Wed, 02 April 2008	5	1926	Thu, 03 April 2008 15:51 By: michael_bialik
Which Performance hint we should use when? By: manoj12 on Thu, 03 April 2008	3	1588	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	1852	Thu, 03 April 2008 07:05 By: sispk6
query tuning using explain plan oracle , linux By: sheldon1982 on Wed, 02 April 2008	4	2105	Wed, 02 April 2008 21:26 By: rleishman
insert took a lnog time. sun 10g By: lioracle on Wed, 02 April 2008	3	1598	Wed, 02 April 2008 21:21 By: rleishman
Find a correct value for PGA_AGGREGATE_TARGET Oracle 9i, AIX By: agostino_neto on Wed, 02 April 2008	1	2956	Wed, 02 April 2008 08:02 By: Michel Cadot
Usage of Materialized view to improve performance By: sandhyaa on Tue, 01 April 2008	2	2002	Wed, 02 April 2008 07:36 By: gintsp