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

    Replies Views Last message
  Newbie: Query uses index and runs slow
By: hristo on Mon, 14 January 2008
4 2242 Mon, 14 January 2008 20:29
By: rleishman
  How get full data from table
By: bornlooser on Thu, 10 January 2008
6 3264 Mon, 14 January 2008 05:05
By: rleishman
  sga_max_size: Oracle reserves all at ones?
By: hristo on Mon, 14 January 2008
1 2469 Mon, 14 January 2008 03:41
By: Michel Cadot
  Tuning with Oracle Collections
Oracle 9i
By: trowsdale on Sat, 12 January 2008
2 3095 Sun, 13 January 2008 23:20
By: trowsdale
  Help- Tuning Query
Oracle 9i R2
By: orasaket on Mon, 07 January 2008
7 2583 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 2251 Fri, 11 January 2008 15:21
By: Mahesh Rajendran
  PL SQL Merge of tables - efficiency
By: buechler66 on Thu, 10 January 2008
7 4995 Fri, 11 January 2008 13:30
By: Kevin Meade
  table access count
By: asangapradeep on Fri, 11 January 2008
1 1894 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 3077 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 2970 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 5141 Wed, 09 January 2008 20:49
By: rleishman
  performance tuning
By: piscean_n on Wed, 26 December 2007
16 4137 Wed, 09 January 2008 10:08
By: Kevin Meade
  Comparing collection against cursor
oracle,9i,sunos
By: shahnazurs on Tue, 08 January 2008
2 2347 Wed, 09 January 2008 01:24
By: Michel Cadot
  How can i tune the query...
By: ziauldba on Tue, 08 January 2008
2 2078 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 1843 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 2178 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 2417 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 2019 Tue, 08 January 2008 03:51
By: Michel Cadot
  Performance tuning of DDL?
By: lwright on Mon, 07 January 2008
5 3908 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 5527 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 3254 Mon, 07 January 2008 10:36
By: orausern
  Index Usage
By: cgk1983 on Mon, 07 January 2008
3 2399 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 1818 Mon, 07 January 2008 08:14
By: Michel Cadot
  Deletion script doesnt completes
By: ora_2007 on Sun, 06 January 2008
10 3047 Mon, 07 January 2008 03:46
By: ora_2007
  SGA - Buffer cache size
By: mwansalovewell on Fri, 12 October 2007
9 11119 Sun, 06 January 2008 14:03
By: Frank Naude
  slow query
10.2.3.0
By: mwansalovewell on Fri, 04 January 2008
1 2027 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 2500 Fri, 04 January 2008 17:06
By: Kevin Meade
  11g SQL PERFORMANCE ANALYZER
By: prince973 on Fri, 04 January 2008
0 6848 Fri, 04 January 2008 08:11
By: prince973
  Update Statement is too slow
By: ashwin_tampa on Fri, 28 December 2007
7 10092 Thu, 03 January 2008 14:23
By: ashwin_tampa
  Group by clause
By: deepak samal on Thu, 03 January 2008
1 1597 Thu, 03 January 2008 01:15
By: Michel Cadot
  latch: session allocation and CPU
By: panelan on Mon, 31 December 2007
6 11083 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 6851 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 3135 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 1822 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 2398 Sun, 30 December 2007 01:30
By: Michel Cadot
  index problem on partition based table
By: dusoo on Thu, 27 December 2007
10 3737 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 4456 Fri, 28 December 2007 19:44
By: halfydba
  can collections help
10g
By: himakar.vucha on Tue, 25 December 2007
10 4969 Fri, 28 December 2007 16:21
By: rleishman
  Entries are getting very slow.
By: ksaravin on Thu, 27 December 2007
5 2085 Fri, 28 December 2007 12:25
By: michael_bialik
  EXECUTION TIME
By: tanmoy1048 on Wed, 26 December 2007
2 2295 Thu, 27 December 2007 01:28
By: Michel Cadot
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: Mon Dec 08 11:44:42 CST 2025