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

    Replies Views Last message
  Pls help in reducing the buffer gets for the query below
By: aarti.mishra on Fri, 08 September 2006
7 7871 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 2484 Wed, 15 November 2006 07:52
By: JRowbottom
  Analyze tables
By: seema.taunk on Mon, 13 November 2006
7 6533 Tue, 14 November 2006 22:52
By: seema.taunk
  Regarding Autotrace execution Plan
By: reena_ch30 on Mon, 13 November 2006
3 2387 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 6249 Mon, 13 November 2006 22:40
By: Mohammad Taj
  Query Optimization problem...
By: deepayan on Tue, 07 November 2006
2 3685 Mon, 13 November 2006 19:50
By: rleishman
icon14.gif Analyze SYS_IL0000 LOB Indexes
By: venkatp6 on Mon, 13 November 2006
1 6565 Mon, 13 November 2006 12:18
By: Mahesh Rajendran
  Index not used in outer join query
By: lars3006 on Wed, 08 November 2006
10 19092 Fri, 10 November 2006 18:51
By: rleishman
  Parrallel Query Problem
By: rkl1 on Fri, 10 November 2006
0 3710 Fri, 10 November 2006 15:10
By: rkl1
  PB statistic CBO
By: Haler on Fri, 10 November 2006
4 1961 Fri, 10 November 2006 12:54
By: Haler
  Perfomace issues on complex query
By: jaydba on Wed, 01 November 2006
9 2296 Thu, 09 November 2006 11:06
By: jaydba
  Creating PK in Each table
By: selvakumar_82 on Mon, 06 November 2006
7 2376 Thu, 09 November 2006 02:38
By: JRowbottom
  help need in optimizing a query....
By: chandanbhamra on Tue, 07 November 2006
0 4094 Tue, 07 November 2006 05:10
By: chandanbhamra
  Performance thumb-rules
By: panda on Wed, 01 November 2006
5 4555 Tue, 07 November 2006 02:44
By: kimant
  Library Cache OVERHEAD
By: orafaqdba on Mon, 06 November 2006
0 3718 Mon, 06 November 2006 12:53
By: orafaqdba
  insert statement runs very slow
By: beastjj on Mon, 06 November 2006
1 2127 Mon, 06 November 2006 02:28
By: beastjj
  v$librarycache
By: Anand Ramaswamy on Fri, 03 November 2006
3 1610 Sun, 05 November 2006 13:35
By: kimant
  Tuning SQL statement in PL/SQL
By: Akshar on Mon, 30 October 2006
12 2818 Sat, 04 November 2006 15:20
By: Akshar
  Will Deleting rows from Table improve Performance?
By: kumarsz on Sat, 04 November 2006
2 1924 Sat, 04 November 2006 14:12
By: kimant
  insert statement runs slow
By: Akshar on Fri, 27 October 2006
7 9094 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 2085 Sat, 04 November 2006 03:08
By: jiltin
  how to change this query, runs forever
By: leahchow on Thu, 02 November 2006
1 1909 Fri, 03 November 2006 00:25
By: rleishman
  Partition Criteria
By: piyushbhatt on Thu, 19 October 2006
2 1809 Thu, 02 November 2006 08:24
By: michael_bialik
  Tuning the query - Outer join
By: bagulia_pilla on Tue, 31 October 2006
4 2167 Thu, 02 November 2006 02:12
By: S.Rajaram
  Performance tuning a table
By: ezhilv on Mon, 30 October 2006
3 1769 Wed, 01 November 2006 07:00
By: michael_bialik
  Advice on Hints
By: ravgopal on Thu, 26 October 2006
7 3724 Mon, 30 October 2006 16:57
By: rleishman
  STATS and Last Analyzed Column
By: faiz_hyd on Mon, 30 October 2006
0 9035 Mon, 30 October 2006 11:01
By: faiz_hyd
  datafile random read average time
By: seema.taunk on Fri, 27 October 2006
2 6933 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 3076 Mon, 30 October 2006 03:16
By: a_developer
  Find the Explain Plan from Trace File
By: bellpk on Tue, 24 October 2006
2 3836 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 1926 Sat, 28 October 2006 00:05
By: Mohammad Taj
  problem when dropping table
By: aline on Mon, 23 October 2006
6 3876 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 8235 Fri, 27 October 2006 09:54
By: caraless
  Check v$sqlarea for shared cursors
By: reena_ch30 on Thu, 26 October 2006
5 1784 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 1634 Fri, 27 October 2006 00:33
By: reena_ch30
  Update vs CTAS
By: a_developer on Thu, 26 October 2006
2 1928 Thu, 26 October 2006 10:02
By: Kevin Meade
  Regarding v$librarycache
By: reena_ch30 on Thu, 19 October 2006
5 1984 Thu, 26 October 2006 05:34
By: reena_ch30
  Help Deciding on Local or Global Index
By: mdoakes42 on Wed, 25 October 2006
1 2260 Wed, 25 October 2006 21:36
By: rleishman
  Statspack: How to reduce the LNS wait for LGWR redo EVENT and CPU TIME
By: beastjj on Wed, 25 October 2006
0 11683 Wed, 25 October 2006 02:41
By: beastjj
  Search option
By: selvakumar_82 on Fri, 20 October 2006
3 1825 Wed, 25 October 2006 00:29
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: Fri Apr 26 22:22:08 CDT 2024