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

    Replies Views Last message
  how to find out where oracle is using paging and swapping (merged)
By: ravivkumar on Sat, 09 July 2005
6 2404 Mon, 11 July 2005 11:35
By: srinivas4u2
  shutting down database
By: kinjal on Fri, 08 July 2005
7 1378 Mon, 11 July 2005 10:12
By: smartin
  composite index or single column index?
By: liux99 on Wed, 06 July 2005
3 1505 Wed, 06 July 2005 13:15
By: smartin
  SQL*Net messages
By: mjschwenger on Wed, 06 July 2005
1 1281 Wed, 06 July 2005 12:05
By: smartin
  unable to allocate 4128 bytes of shared memory ("shared pool
By: lordtorero on Fri, 24 June 2005
4 12819 Mon, 04 July 2005 01:53
By: ziggy
  Explain plan
By: peanand on Wed, 29 June 2005
1 1184 Wed, 29 June 2005 08:23
By: Mahesh Rajendran
  Logical database design
By: hafeez_splendid on Tue, 21 June 2005
5 1585 Mon, 27 June 2005 13:20
By: andrew again
  Index for temporary table
By: liux99 on Fri, 24 June 2005
3 2218 Fri, 24 June 2005 16:31
By: andrew again
  Archival of Production Database
By: ppriya_r on Mon, 13 June 2005
6 1767 Wed, 22 June 2005 17:06
By: skempins
  How to optimize this sql
By: pjsiong on Wed, 22 June 2005
7 1420 Wed, 22 June 2005 09:41
By: Art Metzer
  Need some info Capacity Planning ---- Urgent
By: hafeez_splendid on Mon, 20 June 2005
1 1075 Tue, 21 June 2005 16:13
By: andrew again
  How to increase Performance of Composite Primary Key
By: mukeshsingh868 on Tue, 21 June 2005
1 1013 Tue, 21 June 2005 16:03
By: andrew again
  Need some help resizing SGA parameters
By: prestoj8 on Tue, 21 June 2005
1 1277 Tue, 21 June 2005 04:09
By: girish.rohini
icon5.gif Reg. Performance Issue with XML
By: d.dineshkumar on Tue, 21 June 2005
0 1934 Tue, 21 June 2005 02:03
By: d.dineshkumar
  Measuring time exection
By: jef1 on Sat, 18 June 2005
2 1649 Mon, 20 June 2005 04:07
By: limer
  choosing the right query
By: srraajesh on Sat, 18 June 2005
3 1273 Sun, 19 June 2005 06:23
By: Mahesh Rajendran
  how to avoid the full table scan?
By: confident on Mon, 13 June 2005
2 6200 Sat, 18 June 2005 03:56
By: srraajesh
  VERY URGENT -- SQL- TUNING
By: Fl_reader on Wed, 15 June 2005
5 1481 Thu, 16 June 2005 14:40
By: smartin
icon5.gif Decide the size of every component of SGA in given case?
By: sunil_v_mishra on Mon, 25 April 2005
7 3049 Thu, 16 June 2005 14:38
By: smartin
  Storage recomendation please
By: storspoven on Wed, 15 June 2005
1 1757 Thu, 16 June 2005 14:33
By: smartin
  Locally Managed Table syntax
By: livetaurean19 on Wed, 15 June 2005
8 2568 Wed, 15 June 2005 16:38
By: Mahesh Rajendran
  How do you cleanup chained rows!
By: jake374 on Wed, 15 June 2005
9 1932 Wed, 15 June 2005 16:03
By: jake374
icon5.gif getting bad Performance during use
By: hartmut.stumpf@stratos.ag on Wed, 15 June 2005
5 2861 Wed, 15 June 2005 15:24
By: smartin
icon5.gif Which parameter?
By: sunil_v_mishra on Mon, 13 June 2005
8 1557 Wed, 15 June 2005 08:45
By: smartin
  which view to use to know about global partitioned index
By: tom_k_mishra on Tue, 14 June 2005
1 907 Tue, 14 June 2005 14:00
By: smartin
  SQL QUERY NOT USING BITMAP INDEX
By: puneetsachar on Mon, 13 June 2005
8 3595 Tue, 14 June 2005 09:30
By: smartin
  Index on varchar2(2500)
By: sandeep55 on Mon, 13 June 2005
7 2583 Tue, 14 June 2005 09:25
By: smartin
  RBO is there in oracle 10g?
By: sunil_v_mishra on Mon, 13 June 2005
5 1732 Tue, 14 June 2005 09:21
By: smartin
  FTS even there is an index on table.
By: sunil_v_mishra on Mon, 13 June 2005
5 1522 Tue, 14 June 2005 08:39
By: Maaher
  HELP ON STATSPACK
By: sponguru_dba on Mon, 06 June 2005
2 1348 Tue, 14 June 2005 04:33
By: sponguru_dba
  who is the user executing query which is using more disk space?
By: sunil_v_mishra on Thu, 09 June 2005
2 1405 Mon, 13 June 2005 23:13
By: sunil_v_mishra
  Document security model
By: vpronnikov on Mon, 13 June 2005
3 1148 Mon, 13 June 2005 10:03
By: smartin
  Oracle sequence
By: belboey on Sun, 12 June 2005
2 1218 Mon, 13 June 2005 09:36
By: smartin
  When to use index
By: d.dineshkumar on Fri, 03 June 2005
6 2382 Mon, 13 June 2005 05:53
By: d.dineshkumar
  Constraint state in DWH environment (rely disable novalidate)
By: henning.schroer on Sun, 12 June 2005
0 2762 Sun, 12 June 2005 04:30
By: henning.schroer
  Explain Plan - number of rows returned.
By: Lee Sutton on Wed, 08 June 2005
5 2415 Fri, 10 June 2005 08:08
By: Lee Sutton
  Index Question
By: j_potucek on Tue, 03 May 2005
2 1285 Thu, 09 June 2005 04:15
By: nabeelkhan
  What is happening with this sql?
By: rramanat on Fri, 27 May 2005
15 4256 Wed, 08 June 2005 20:10
By: rramanat
  select large amount of data
By: r2d2dev on Wed, 08 June 2005
1 1139 Wed, 08 June 2005 15:47
By: Art Metzer
  forced view
By: ramvenky on Tue, 07 June 2005
4 3760 Wed, 08 June 2005 00:20
By: nabeelkhan
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: Thu Dec 01 03:07:12 CST 2022