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

    Replies Views Last message
  Join Query problem. One using index while another full table scan
By: honeybee on Thu, 14 September 2006
3 2195 Fri, 15 September 2006 23:20
By: rleishman
  problems with updating big table by commit at end
By: coral_3 on Thu, 14 September 2006
3 1813 Fri, 15 September 2006 10:11
By: coral_3
  Number of Datafiles in a Tablespace
By: faiz_hyd on Fri, 15 September 2006
2 1832 Fri, 15 September 2006 10:04
By: faiz_hyd
  Estimate_Percent for Analyze Schema
By: rkulasek on Tue, 12 September 2006
4 4357 Thu, 14 September 2006 00:25
By: rkulasek
  Analyze increases cost
By: manish mendiratta on Wed, 13 September 2006
1 1531 Wed, 13 September 2006 21:31
By: rleishman
  help with coming up a test case!
By: orausern on Mon, 11 September 2006
5 2381 Wed, 13 September 2006 07:29
By: JRowbottom
  Merge Partition into 1 single partition
By: faiz_hyd on Tue, 12 September 2006
1 2023 Tue, 12 September 2006 21:23
By: email.sandeepnaik
  sql_trace question
By: rkl1 on Mon, 11 September 2006
1 1877 Tue, 12 September 2006 03:45
By: AndreyPozhidaev
  enable Full-Text Search
By: javed122 on Mon, 11 September 2006
2 2007 Mon, 11 September 2006 09:08
By: javed122
  Scale of DBA_HIST_SQLSTAT values
By: kwalz58 on Thu, 07 September 2006
2 4233 Mon, 11 September 2006 09:06
By: kwalz58
  other buffer pool .... cache sizes ??
By: tridentadm on Thu, 07 September 2006
6 3250 Fri, 08 September 2006 09:32
By: JSI2001
  Big data Inserts
By: rkl1 on Fri, 18 August 2006
4 2042 Fri, 08 September 2006 09:17
By: goudelly
  inserting data in append mode .. what adv ??
By: tridentadm on Mon, 04 September 2006
2 1590 Fri, 08 September 2006 09:07
By: goudelly
icon5.gif Index Usage and SQL Tuning Question
By: mohannemani on Thu, 07 September 2006
2 2064 Fri, 08 September 2006 07:45
By: rleishman
  column to look for in v$system_event
By: tridentadm on Thu, 07 September 2006
3 1827 Fri, 08 September 2006 01:07
By: tarundua
  shared pool, invalidations and creation indexes ??
By: tridentadm on Thu, 07 September 2006
0 3799 Thu, 07 September 2006 22:42
By: tridentadm
  ORA-01652 - Temporary Tablespace problems!!
By: Tizza on Tue, 05 September 2006
2 7848 Wed, 06 September 2006 02:34
By: wwllzpz
  Hash join hint not being used
By: speaker on Tue, 05 September 2006
4 11089 Wed, 06 September 2006 01:18
By: rleishman
  advantage of append mode ??
By: tridentadm on Mon, 04 September 2006
2 1980 Tue, 05 September 2006 11:12
By: ebrian
  analyze table
By: bahy91 on Tue, 05 September 2006
3 2060 Tue, 05 September 2006 07:44
By: Mahesh Rajendran
  Check if the Index is performing good or not
By: bahy91 on Mon, 04 September 2006
4 1818 Tue, 05 September 2006 07:36
By: rleishman
  Performance tuning SQL
By: speaker on Fri, 01 September 2006
3 2300 Fri, 01 September 2006 20:57
By: BlackSwan
  Cursor time out error(open cursor on bottleneck)
By: pareshr on Fri, 01 September 2006
1 3132 Fri, 01 September 2006 20:48
By: BlackSwan
  db file scattered and sequential read wait events ?
By: tridentadm on Fri, 01 September 2006
1 1750 Fri, 01 September 2006 02:39
By: kimant
  how to calculate shared pool size ??
By: tridentadm on Thu, 31 August 2006
1 1899 Thu, 31 August 2006 04:43
By: Frank Naude
  when was COST optimizer introduced ?
By: tridentadm on Wed, 30 August 2006
3 2073 Thu, 31 August 2006 03:30
By: JRowbottom
  what to do about this one !!!
By: seemit on Wed, 30 August 2006
12 3965 Wed, 30 August 2006 08:31
By: seemit
  Oracle 9i redo logging performance poor in relation to DB2 on Solaris. Please help.
By: adamb on Fri, 18 August 2006
2 2828 Wed, 30 August 2006 06:32
By: adamb
icon2.gif Temp Data files Size
By: mian imran on Tue, 29 August 2006
2 1976 Wed, 30 August 2006 00:16
By: mian imran
  Large Volume Updates And Performance
By: Jackofalltrades on Tue, 29 August 2006
4 2344 Tue, 29 August 2006 23:02
By: rleishman
  Connection Latency
By: amit.pansare on Mon, 28 August 2006
0 3866 Mon, 28 August 2006 15:05
By: amit.pansare
  SLOW Updates
By: dpodborny on Fri, 25 August 2006
4 5988 Mon, 28 August 2006 08:05
By: dpodborny
  Analyze Command
By: javed122 on Fri, 25 August 2006
4 1863 Mon, 28 August 2006 02:42
By: javed122
  the outline error why
By: lazycat on Fri, 25 August 2006
3 2395 Fri, 25 August 2006 03:09
By: lazycat
icon8.gif Oracle 9.0.2.7 enterprise problem
By: hvvaghani on Tue, 01 August 2006
2 1786 Wed, 23 August 2006 11:00
By: pabs
  Shared Pool sizing
By: kudur_kv on Tue, 22 August 2006
7 2374 Wed, 23 August 2006 10:59
By: kudur_kv
  Udmp Traces
By: wahdany60 on Mon, 21 August 2006
10 2613 Wed, 23 August 2006 09:47
By: wahdany60
  Index Use and Renaming Partitions
By: faiz_hyd on Mon, 21 August 2006
3 3000 Wed, 23 August 2006 04:31
By: rleishman
  Temp segment issue
By: kudur_kv on Thu, 17 August 2006
4 2823 Tue, 22 August 2006 11:21
By: kudur_kv
  STATSPACK question on 10g and 8i
By: toshidas2000 on Thu, 20 July 2006
2 2045 Tue, 22 August 2006 03:36
By: alexdabr
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 May 16 03:53:26 CDT 2024