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

    Replies Views Last message
  Help- Tuning Query
Oracle 9i R2
By: orasaket on Mon, 07 January 2008
7 1753 Sat, 12 January 2008 10:45
By: michael_bialik
  works in test env but very slow in production
By: pzlj6x on Fri, 11 January 2008
3 1654 Fri, 11 January 2008 15:21
By: Mahesh Rajendran
  PL SQL Merge of tables - efficiency
By: buechler66 on Thu, 10 January 2008
7 4113 Fri, 11 January 2008 13:30
By: Kevin Meade
  table access count
By: asangapradeep on Fri, 11 January 2008
1 1217 Fri, 11 January 2008 05:47
By: Michel Cadot
  What can I do to increase my Library Cache Hit stats
10G Linux
By: aidi-h on Thu, 10 January 2008
1 2377 Thu, 10 January 2008 13:48
By: Kevin Meade
  Split partitions in oracle 8.0.4.3
Sun solaris 5.9
By: hitenparekh on Tue, 08 January 2008
6 1956 Wed, 09 January 2008 20:55
By: rleishman
  retrieve execution plan for running session in Oracle 8i database
By: wkk1020 on Tue, 08 January 2008
6 3865 Wed, 09 January 2008 20:49
By: rleishman
  performance tuning
By: piscean_n on Wed, 26 December 2007
16 3020 Wed, 09 January 2008 10:08
By: Kevin Meade
  Comparing collection against cursor
oracle,9i,sunos
By: shahnazurs on Tue, 08 January 2008
2 1319 Wed, 09 January 2008 01:24
By: Michel Cadot
  How can i tune the query...
By: ziauldba on Tue, 08 January 2008
2 1268 Wed, 09 January 2008 01:22
By: Michel Cadot
  Bock Inefficiency 100%
oracle 8.0.4.3,SunOS 5.9
By: hitenparekh on Wed, 09 January 2008
1 1125 Wed, 09 January 2008 01:18
By: Michel Cadot
  Merge join verse Filter. Same code, different database, different explain plan
By: bickers on Tue, 08 January 2008
2 1311 Tue, 08 January 2008 20:23
By: rleishman
  query plan and negative value (-1) in where clause
By: maga on Tue, 08 January 2008
5 1742 Tue, 08 January 2008 10:14
By: maga
  increasing cache hit ratio
oracle,10g,win xp
By: sd_md_rizwan@yahoo.com on Tue, 08 January 2008
2 1172 Tue, 08 January 2008 03:51
By: Michel Cadot
  Performance tuning of DDL?
By: lwright on Mon, 07 January 2008
5 3217 Tue, 08 January 2008 00:31
By: rleishman
  Index followup decision in case of composite b-tree index
By: Dipali Vithalani on Sat, 05 January 2008
11 4456 Mon, 07 January 2008 13:29
By: Kevin Meade
  A question on Interpreting 10046 trace and the waits
By: orausern on Sun, 06 January 2008
5 2133 Mon, 07 January 2008 10:36
By: orausern
  Index Usage
By: cgk1983 on Mon, 07 January 2008
3 1184 Mon, 07 January 2008 09:07
By: Michel Cadot
  Where to Start the Performance Tuning?
9iR2, RHEL AS3.0
By: sathyguy on Mon, 07 January 2008
1 1164 Mon, 07 January 2008 08:14
By: Michel Cadot
  Deletion script doesnt completes
By: ora_2007 on Sun, 06 January 2008
10 2046 Mon, 07 January 2008 03:46
By: ora_2007
  SGA - Buffer cache size
By: mwansalovewell on Fri, 12 October 2007
9 8786 Sun, 06 January 2008 14:03
By: Frank Naude
  slow query
10.2.3.0
By: mwansalovewell on Fri, 04 January 2008
1 1532 Sat, 05 January 2008 17:17
By: Barbara Boehmer
  sql query running for too long .....
oracle 10g
By: yogeshse on Fri, 04 January 2008
2 1765 Fri, 04 January 2008 17:06
By: Kevin Meade
  11g SQL PERFORMANCE ANALYZER
By: prince973 on Fri, 04 January 2008
0 6310 Fri, 04 January 2008 08:11
By: prince973
  Update Statement is too slow
By: ashwin_tampa on Fri, 28 December 2007
7 8968 Thu, 03 January 2008 14:23
By: ashwin_tampa
  Group by clause
By: deepak samal on Thu, 03 January 2008
1 1133 Thu, 03 January 2008 01:15
By: Michel Cadot
  latch: session allocation and CPU
By: panelan on Mon, 31 December 2007
6 9947 Wed, 02 January 2008 23:37
By: trantuananh24hg
  Choose your Buffer Cache Hit Ratio
V7 Oracle or higher on any OS
By: BlackSwan on Wed, 02 January 2008
0 6341 Wed, 02 January 2008 17:19
By: BlackSwan
  same sql but different responce time
oracle database (OLTP) 9.2.0.7 on aix
By: dba4bank on Fri, 28 December 2007
10 2178 Mon, 31 December 2007 20:10
By: rleishman
  memory sizng on
Win 64 bit, 9.2.0.8
By: oraclestew on Mon, 31 December 2007
1 1153 Mon, 31 December 2007 05:01
By: Michel Cadot
  help on indexes
oracle,10g,win xp
By: sd_md_rizwan@yahoo.com on Sat, 29 December 2007
3 1267 Sun, 30 December 2007 01:30
By: Michel Cadot
  index problem on partition based table
By: dusoo on Thu, 27 December 2007
10 2545 Sat, 29 December 2007 16:13
By: BlackSwan
  Max time for all sql's in my process being consumed by db file sequential read
By: mithun.karthikeyan on Wed, 19 December 2007
9 2172 Fri, 28 December 2007 19:44
By: halfydba
  can collections help
10g
By: himakar.vucha on Tue, 25 December 2007
10 2161 Fri, 28 December 2007 16:21
By: rleishman
  Entries are getting very slow.
By: ksaravin on Thu, 27 December 2007
5 1481 Fri, 28 December 2007 12:25
By: michael_bialik
  EXECUTION TIME
By: tanmoy1048 on Wed, 26 December 2007
2 1326 Thu, 27 December 2007 01:28
By: Michel Cadot
  CLOB usage and issue with TEMP tablespace
By: susmita on Mon, 24 December 2007
1 3227 Mon, 24 December 2007 03:09
By: halfydba
  Long Running SQL- CLOB vs TO_CHAR
By: mymot on Fri, 21 December 2007
1 4228 Fri, 21 December 2007 03:07
By: Michel Cadot
  suggestions required to change the query to improve its performance
Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production,windows XP
By: venkatadeekshi on Thu, 20 December 2007
2 1701 Thu, 20 December 2007 20:04
By: rleishman
  Changing Query Approach
By: mrk_anand on Mon, 17 December 2007
11 2695 Thu, 20 December 2007 10:46
By: Kevin Meade
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: Sun Jun 02 20:30:24 CDT 2024