Home » RDBMS Server » Performance Tuning
Please read the OraFAQ Forum Guide before posting.
Please contribute good answers to the wiki.

    Replies Views Last message
  flushing the buffer cache
By: reena_ch30 on Thu, 19 October 2006
12 4237 Thu, 16 November 2006 02:11
By: Mohammad Taj
  Interpret STATSPack Report
By: faiz_hyd on Wed, 15 November 2006
0 5245 Wed, 15 November 2006 14:38
By: faiz_hyd
  Pls help in reducing the buffer gets for the query below
By: aarti.mishra on Fri, 08 September 2006
7 8366 Wed, 15 November 2006 10:11
By: skn
  I need a listing of Oracle indexes and how often they are used, how?
By: aidi-h on Fri, 10 November 2006
7 4278 Wed, 15 November 2006 07:52
By: JRowbottom
  Analyze tables
By: seema.taunk on Mon, 13 November 2006
7 7003 Tue, 14 November 2006 22:52
By: seema.taunk
  Regarding Autotrace execution Plan
By: reena_ch30 on Mon, 13 November 2006
3 2811 Tue, 14 November 2006 00:49
By: Mohammad Taj
  Difference between SORT_MULTIBLOCK_READ_COUNT and DB_MULTIBLOCK_READ_COUNT
By: reena_ch30 on Sun, 12 November 2006
3 7019 Mon, 13 November 2006 22:40
By: Mohammad Taj
  Query Optimization problem...
By: deepayan on Tue, 07 November 2006
2 4028 Mon, 13 November 2006 19:50
By: rleishman
icon14.gif Analyze SYS_IL0000 LOB Indexes
By: venkatp6 on Mon, 13 November 2006
1 7191 Mon, 13 November 2006 12:18
By: Mahesh Rajendran
  Index not used in outer join query
By: lars3006 on Wed, 08 November 2006
10 19604 Fri, 10 November 2006 18:51
By: rleishman
  Parrallel Query Problem
By: rkl1 on Fri, 10 November 2006
0 4204 Fri, 10 November 2006 15:10
By: rkl1
  PB statistic CBO
By: Haler on Fri, 10 November 2006
4 2871 Fri, 10 November 2006 12:54
By: Haler
  Perfomace issues on complex query
By: jaydba on Wed, 01 November 2006
9 4229 Thu, 09 November 2006 11:06
By: jaydba
  Creating PK in Each table
By: selvakumar_82 on Mon, 06 November 2006
7 3924 Thu, 09 November 2006 02:38
By: JRowbottom
  help need in optimizing a query....
By: chandanbhamra on Tue, 07 November 2006
0 4376 Tue, 07 November 2006 05:10
By: chandanbhamra
  Performance thumb-rules
By: panda on Wed, 01 November 2006
5 4993 Tue, 07 November 2006 02:44
By: kimant
  Library Cache OVERHEAD
By: orafaqdba on Mon, 06 November 2006
0 4087 Mon, 06 November 2006 12:53
By: orafaqdba
  insert statement runs very slow
By: beastjj on Mon, 06 November 2006
1 2759 Mon, 06 November 2006 02:28
By: beastjj
  v$librarycache
By: Anand Ramaswamy on Fri, 03 November 2006
3 2108 Sun, 05 November 2006 13:35
By: kimant
  Tuning SQL statement in PL/SQL
By: Akshar on Mon, 30 October 2006
12 3385 Sat, 04 November 2006 15:20
By: Akshar
  Will Deleting rows from Table improve Performance?
By: kumarsz on Sat, 04 November 2006
2 2383 Sat, 04 November 2006 14:12
By: kimant
  insert statement runs slow
By: Akshar on Fri, 27 October 2006
7 9530 Sat, 04 November 2006 03:23
By: Admin@Lightsql.Com
  Inserts, update are taking long to execute. How to tune it?
By: jiltin on Wed, 27 September 2006
3 2933 Sat, 04 November 2006 03:08
By: jiltin
  how to change this query, runs forever
By: leahchow on Thu, 02 November 2006
1 2208 Fri, 03 November 2006 00:25
By: rleishman
  Partition Criteria
By: piyushbhatt on Thu, 19 October 2006
2 2625 Thu, 02 November 2006 08:24
By: michael_bialik
  Tuning the query - Outer join
By: bagulia_pilla on Tue, 31 October 2006
4 2456 Thu, 02 November 2006 02:12
By: S.Rajaram
  Performance tuning a table
By: ezhilv on Mon, 30 October 2006
3 2521 Wed, 01 November 2006 07:00
By: michael_bialik
  Advice on Hints
By: ravgopal on Thu, 26 October 2006
7 4001 Mon, 30 October 2006 16:57
By: rleishman
  STATS and Last Analyzed Column
By: faiz_hyd on Mon, 30 October 2006
0 9374 Mon, 30 October 2006 11:01
By: faiz_hyd
  datafile random read average time
By: seema.taunk on Fri, 27 October 2006
2 7764 Mon, 30 October 2006 03:53
By: seema.taunk
  Copying statistics of one table to another
By: a_developer on Mon, 30 October 2006
2 3539 Mon, 30 October 2006 03:16
By: a_developer
  Find the Explain Plan from Trace File
By: bellpk on Tue, 24 October 2006
2 4569 Sun, 29 October 2006 23:27
By: bellpk
  move all objects from tbs to new tbs /rebuild all indexes to new tbs
By: caraless on Fri, 27 October 2006
1 2606 Sat, 28 October 2006 00:05
By: Mohammad Taj
  problem when dropping table
By: aline on Mon, 23 October 2006
6 4334 Fri, 27 October 2006 19:02
By: rleishman
  Reorganization of data/ Eliminate database fragmentation (export, drop and re-import tables)
By: caraless on Thu, 26 October 2006
10 10077 Fri, 27 October 2006 09:54
By: caraless
  Check v$sqlarea for shared cursors
By: reena_ch30 on Thu, 26 October 2006
5 2199 Fri, 27 October 2006 00:58
By: reena_ch30
  setting trace file name created using sql trace
By: reena_ch30 on Thu, 26 October 2006
2 2241 Fri, 27 October 2006 00:33
By: reena_ch30
  Update vs CTAS
By: a_developer on Thu, 26 October 2006
2 2794 Thu, 26 October 2006 10:02
By: Kevin Meade
  Regarding v$librarycache
By: reena_ch30 on Thu, 19 October 2006
5 3227 Thu, 26 October 2006 05:34
By: reena_ch30
  Help Deciding on Local or Global Index
By: mdoakes42 on Wed, 25 October 2006
1 2766 Wed, 25 October 2006 21:36
By: rleishman
Goto Forum:
  
Legend New Messages New Messages   No New messages No New messages   Locked (w/ unread messages) Locked (w/ unread messages)   Locked Locked   Moved to another forum Moved to another forum

Current Time: Wed Nov 27 03:12:20 CST 2024