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

    Replies Views Last message
  The Server Performance deteriorates after some time after the instance is restarted
By: rhm1 on Thu, 14 July 2005
1 2899 Sat, 16 July 2005 11:11
By: smartin
  Query optimization
By: Hina on Fri, 15 July 2005
3 799 Sat, 16 July 2005 04:06
By: Frank Naude
  /*+ RULE */ hint in SQL Queries
By: sujit_ocp on Mon, 09 May 2005
11 70599 Fri, 15 July 2005 05:38
By: d.dineshkumar
  How to monitor query
By: Hina on Thu, 14 July 2005
2 1049 Thu, 14 July 2005 22:20
By: Hina
  reversed indexes
By: mjschwenger on Thu, 14 July 2005
2 1246 Thu, 14 July 2005 16:08
By: smartin
  Pinning question
By: james_briar on Sat, 25 June 2005
12 1579 Thu, 14 July 2005 15:31
By: james_briar
  Extracting CPU data from statspack tables
By: dee_hicks on Thu, 14 July 2005
1 788 Thu, 14 July 2005 09:21
By: Mahesh Rajendran
  trace level for query
By: Hina on Wed, 13 July 2005
1 662 Thu, 14 July 2005 08:15
By: smartin
  Configuring the database parameters
By: hafeez_splendid on Wed, 13 July 2005
3 2151 Thu, 14 July 2005 08:10
By: smartin
  Influence of snapshot (STATSPACK) in object locks
By: oskarthik on Thu, 14 July 2005
0 1598 Thu, 14 July 2005 07:53
By: oskarthik
  functional desing advise needed
By: mjschwenger on Wed, 06 July 2005
5 1154 Thu, 14 July 2005 04:52
By: ziggy
  Database performance issue
By: Hina on Tue, 12 July 2005
5 1319 Thu, 14 July 2005 00:14
By: milind_sri
  using statspack .......!
By: balavignesh on Wed, 13 July 2005
0 1699 Wed, 13 July 2005 09:51
By: balavignesh
icon14.gif Sql Tuning - (urgent)
By: rc_ashish on Thu, 07 July 2005
2 1010 Wed, 13 July 2005 05:19
By: SoporteDBA
  wait events
By: subusona on Fri, 08 July 2005
2 1445 Wed, 13 July 2005 05:01
By: SoporteDBA
  steps for tuning oracle...!
By: balavignesh on Tue, 12 July 2005
3 1192 Tue, 12 July 2005 11:23
By: smartin
icon5.gif Regarding CPU utilization
By: d.dineshkumar on Tue, 12 July 2005
4 967 Tue, 12 July 2005 08:15
By: d.dineshkumar
  Trace files not getting generated
By: srinivas4u2 on Fri, 08 July 2005
2 4094 Mon, 11 July 2005 14:19
By: srinivas4u2
  how to find out where oracle is using paging and swapping (merged)
By: ravivkumar on Sat, 09 July 2005
6 2079 Mon, 11 July 2005 11:35
By: srinivas4u2
  shutting down database
By: kinjal on Fri, 08 July 2005
7 1093 Mon, 11 July 2005 10:12
By: smartin
  composite index or single column index?
By: liux99 on Wed, 06 July 2005
3 1212 Wed, 06 July 2005 13:15
By: smartin
  SQL*Net messages
By: mjschwenger on Wed, 06 July 2005
1 941 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 12423 Mon, 04 July 2005 01:53
By: ziggy
  Explain plan
By: peanand on Wed, 29 June 2005
1 849 Wed, 29 June 2005 08:23
By: Mahesh Rajendran
  Logical database design
By: hafeez_splendid on Tue, 21 June 2005
5 1260 Mon, 27 June 2005 13:20
By: andrew again
  Index for temporary table
By: liux99 on Fri, 24 June 2005
3 1871 Fri, 24 June 2005 16:31
By: andrew again
  Archival of Production Database
By: ppriya_r on Mon, 13 June 2005
6 1471 Wed, 22 June 2005 17:06
By: skempins
  How to optimize this sql
By: pjsiong on Wed, 22 June 2005
7 1070 Wed, 22 June 2005 09:41
By: Art Metzer
  Need some info Capacity Planning ---- Urgent
By: hafeez_splendid on Mon, 20 June 2005
1 803 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 743 Tue, 21 June 2005 16:03
By: andrew again
  Need some help resizing SGA parameters
By: prestoj8 on Tue, 21 June 2005
1 1003 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 1675 Tue, 21 June 2005 02:03
By: d.dineshkumar
  Measuring time exection
By: jef1 on Sat, 18 June 2005
2 1367 Mon, 20 June 2005 04:07
By: limer
  choosing the right query
By: srraajesh on Sat, 18 June 2005
3 1003 Sun, 19 June 2005 06:23
By: Mahesh Rajendran
  how to avoid the full table scan?
By: confident on Mon, 13 June 2005
2 5808 Sat, 18 June 2005 03:56
By: srraajesh
  VERY URGENT -- SQL- TUNING
By: Fl_reader on Wed, 15 June 2005
5 1235 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 2694 Thu, 16 June 2005 14:38
By: smartin
  Storage recomendation please
By: storspoven on Wed, 15 June 2005
1 1495 Thu, 16 June 2005 14:33
By: smartin
  Locally Managed Table syntax
By: livetaurean19 on Wed, 15 June 2005
8 2258 Wed, 15 June 2005 16:38
By: Mahesh Rajendran
  How do you cleanup chained rows!
By: jake374 on Wed, 15 June 2005
9 1628 Wed, 15 June 2005 16:03
By: jake374
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: Sat Jan 23 19:00:51 CST 2021