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
Need An Alternate - Synonyms By: rohikesh on Thu, 27 October 2005	2	2262	Thu, 27 October 2005 09:54 By: rohikesh
Book for tuning (I'm not a DBA, though) By: vgs2005 on Sun, 23 October 2005	3	2994	Wed, 26 October 2005 10:45 By: SQLTraceViewer
sequences shared pool By: vadimk on Tue, 25 October 2005	1	2472	Wed, 26 October 2005 03:15 By: JSI2001
What are the pluses of autostats By: mjschwenger on Tue, 25 October 2005	0	3343	Tue, 25 October 2005 17:03 By: mjschwenger
Inline Views By: rgopal67 on Sat, 22 October 2005	4	3115	Tue, 25 October 2005 02:44 By: girish.rohini
Performance of Package and Procedure By: azeem87 on Thu, 15 September 2005	4	3465	Mon, 24 October 2005 17:52 By: SQLTraceViewer
statspack report By: lallmanish on Sun, 23 October 2005	3	3811	Mon, 24 October 2005 02:38 By: ziggy
Reading Output of Plan Table By: feroze on Fri, 21 October 2005	4	3574	Sat, 22 October 2005 11:59 By: feroze
query perfomance By: nitin_228 on Thu, 20 October 2005	1	2268	Sat, 22 October 2005 05:23 By: girish.rohini
How do I force a hash join By: scottwmackey on Thu, 20 October 2005	2	8881	Fri, 21 October 2005 11:43 By: scottwmackey
How to treat binds as literals By: kojakhu on Wed, 19 October 2005	3	2852	Thu, 20 October 2005 08:49 By: smartin
Query Based on Two Views By: pauld on Tue, 18 October 2005	7	3751	Wed, 19 October 2005 13:51 By: smartin
Indexes Difference By: feroze on Mon, 17 October 2005	4	3526	Wed, 19 October 2005 07:05 By: ziggy
Interpreting TKPROF for Complex Inserts/Updates By: scottwmackey on Mon, 17 October 2005	4	2540	Wed, 19 October 2005 05:15 By: ziggy
Very Similar Queries, Very Different Elapsed Times By: scottwmackey on Tue, 18 October 2005	1	1836	Tue, 18 October 2005 21:24 By: Art Metzer
bind variable peeking and collecting statistics By: cybotto on Wed, 12 October 2005	5	6512	Tue, 18 October 2005 08:34 By: smartin
sample tuning help By: kartal on Mon, 17 October 2005	3	2913	Mon, 17 October 2005 08:48 By: Mahesh Rajendran
How can I prove plan invalidations By: smartin on Thu, 13 October 2005	3	1955	Fri, 14 October 2005 13:52 By: smartin
Analytic function but bad performance (merged 5 cross-posts) By: Kanagaraj Velusamy on Fri, 07 October 2005	14	4705	Fri, 14 October 2005 10:43 By: smartin
tuning documentation By: kartal on Fri, 14 October 2005	1	2196	Fri, 14 October 2005 10:03 By: Frank
Oracle Text performance By: CrisDK on Mon, 10 October 2005	2	2761	Thu, 13 October 2005 18:48 By: cybotto
Slow Query By: abc123 on Thu, 13 October 2005	1	1964	Thu, 13 October 2005 18:39 By: cybotto
Theoretical Question Regarding Full Table Scans By: scottwmackey on Thu, 13 October 2005	3	1803	Thu, 13 October 2005 16:55 By: smartin
Why two sets of explain plans in tkprof..ed file?? By: wushu_kid on Fri, 07 October 2005	12	3427	Wed, 12 October 2005 17:05 By: wushu_kid
How can I see the optimized SQL by CBO By: vgs2005 on Mon, 10 October 2005	1	2504	Mon, 10 October 2005 08:23 By: Frank Naude
defragment in oracle By: manu_jariwala on Sat, 08 October 2005	2	4772	Mon, 10 October 2005 06:21 By: girish.rohini
AUM IN ORACLE By: israel05 on Wed, 05 October 2005	1	2442	Mon, 10 October 2005 06:16 By: sunil_v_mishra
max memory of oracle process By: gautamvv on Mon, 10 October 2005	1	2292	Mon, 10 October 2005 06:04 By: sunil_v_mishra
Partition feature By: rebeccaz on Thu, 22 September 2005	2	2371	Fri, 07 October 2005 08:07 By: wushu_kid
Tuning SQL By: vikramjogi on Wed, 05 October 2005	1	3230	Fri, 07 October 2005 05:38 By: sunil_v_mishra
rebuilding indexes ..!!! By: balavignesh on Thu, 06 October 2005	4	2999	Thu, 06 October 2005 15:24 By: smartin
how oracle calculates statistics from within By: mjschwenger on Thu, 06 October 2005	0	3786	Thu, 06 October 2005 11:15 By: mjschwenger
Upgrade By: manu_jariwala on Thu, 06 October 2005	1	2126	Thu, 06 October 2005 08:07 By: Frank Naude
End user problem By: oradba16 on Thu, 06 October 2005	2	2436	Thu, 06 October 2005 02:58 By: JSI2001
different performance on old server By: mjschwenger on Tue, 04 October 2005	2	2681	Wed, 05 October 2005 07:35 By: Mahesh Rajendran
Increasing performance of queries By: sreek_s on Wed, 05 October 2005	1	2147	Wed, 05 October 2005 07:10 By: Mahesh Rajendran
indexes By: adi_dba on Fri, 09 September 2005	12	5257	Wed, 05 October 2005 07:03 By: adi_dba
not using index from application By: mjschwenger on Thu, 29 September 2005	4	2724	Sat, 01 October 2005 21:04 By: smartin
sizing SGA...??? By: balavignesh on Fri, 16 September 2005	15	11688	Fri, 30 September 2005 13:09 By: Hindustanweb
Why the Index is not used, even if its forced? By: nabeelkhan on Thu, 23 June 2005	16	3478	Fri, 30 September 2005 09:00 By: ziggy