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

    Replies Views Last message
  sga_max_size: Oracle reserves all at ones?
By: hristo on Mon, 14 January 2008
1 2230 Mon, 14 January 2008 03:41
By: Michel Cadot
  Tuning with Oracle Collections
Oracle 9i
By: trowsdale on Sat, 12 January 2008
2 2656 Sun, 13 January 2008 23:20
By: trowsdale
  Help- Tuning Query
Oracle 9i R2
By: orasaket on Mon, 07 January 2008
7 2106 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 1925 Fri, 11 January 2008 15:21
By: Mahesh Rajendran
  PL SQL Merge of tables - efficiency
By: buechler66 on Thu, 10 January 2008
7 4420 Fri, 11 January 2008 13:30
By: Kevin Meade
  table access count
By: asangapradeep on Fri, 11 January 2008
1 1661 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 2681 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 2586 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 4713 Wed, 09 January 2008 20:49
By: rleishman
  performance tuning
By: piscean_n on Wed, 26 December 2007
16 3462 Wed, 09 January 2008 10:08
By: Kevin Meade
  Comparing collection against cursor
oracle,9i,sunos
By: shahnazurs on Tue, 08 January 2008
2 2026 Wed, 09 January 2008 01:24
By: Michel Cadot
  How can i tune the query...
By: ziauldba on Tue, 08 January 2008
2 1731 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 1552 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 1802 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 2078 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 1744 Tue, 08 January 2008 03:51
By: Michel Cadot
  Performance tuning of DDL?
By: lwright on Mon, 07 January 2008
5 3470 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 4862 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 2441 Mon, 07 January 2008 10:36
By: orausern
  Index Usage
By: cgk1983 on Mon, 07 January 2008
3 2021 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 1578 Mon, 07 January 2008 08:14
By: Michel Cadot
  Deletion script doesnt completes
By: ora_2007 on Sun, 06 January 2008
10 2420 Mon, 07 January 2008 03:46
By: ora_2007
  SGA - Buffer cache size
By: mwansalovewell on Fri, 12 October 2007
9 10294 Sun, 06 January 2008 14:03
By: Frank Naude
  slow query
10.2.3.0
By: mwansalovewell on Fri, 04 January 2008
1 1750 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 2107 Fri, 04 January 2008 17:06
By: Kevin Meade
  11g SQL PERFORMANCE ANALYZER
By: prince973 on Fri, 04 January 2008
0 6640 Fri, 04 January 2008 08:11
By: prince973
  Update Statement is too slow
By: ashwin_tampa on Fri, 28 December 2007
7 9423 Thu, 03 January 2008 14:23
By: ashwin_tampa
  Group by clause
By: deepak samal on Thu, 03 January 2008
1 1367 Thu, 03 January 2008 01:15
By: Michel Cadot
  latch: session allocation and CPU
By: panelan on Mon, 31 December 2007
6 10443 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 6691 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 2564 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 1569 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 2075 Sun, 30 December 2007 01:30
By: Michel Cadot
  index problem on partition based table
By: dusoo on Thu, 27 December 2007
10 2948 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 3798 Fri, 28 December 2007 19:44
By: halfydba
  can collections help
10g
By: himakar.vucha on Tue, 25 December 2007
10 4103 Fri, 28 December 2007 16:21
By: rleishman
  Entries are getting very slow.
By: ksaravin on Thu, 27 December 2007
5 1696 Fri, 28 December 2007 12:25
By: michael_bialik
  EXECUTION TIME
By: tanmoy1048 on Wed, 26 December 2007
2 1975 Thu, 27 December 2007 01:28
By: Michel Cadot
  CLOB usage and issue with TEMP tablespace
By: susmita on Mon, 24 December 2007
1 3727 Mon, 24 December 2007 03:09
By: halfydba
  Long Running SQL- CLOB vs TO_CHAR
By: mymot on Fri, 21 December 2007
1 4571 Fri, 21 December 2007 03:07
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: Sat Nov 23 01:24:27 CST 2024