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 2218 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 1839 Fri, 15 September 2006 10:11
By: coral_3
  Number of Datafiles in a Tablespace
By: faiz_hyd on Fri, 15 September 2006
2 1852 Fri, 15 September 2006 10:04
By: faiz_hyd
  Estimate_Percent for Analyze Schema
By: rkulasek on Tue, 12 September 2006
4 4379 Thu, 14 September 2006 00:25
By: rkulasek
  Analyze increases cost
By: manish mendiratta on Wed, 13 September 2006
1 1552 Wed, 13 September 2006 21:31
By: rleishman
  help with coming up a test case!
By: orausern on Mon, 11 September 2006
5 2398 Wed, 13 September 2006 07:29
By: JRowbottom
  Merge Partition into 1 single partition
By: faiz_hyd on Tue, 12 September 2006
1 2039 Tue, 12 September 2006 21:23
By: email.sandeepnaik
  sql_trace question
By: rkl1 on Mon, 11 September 2006
1 1893 Tue, 12 September 2006 03:45
By: AndreyPozhidaev
  enable Full-Text Search
By: javed122 on Mon, 11 September 2006
2 2029 Mon, 11 September 2006 09:08
By: javed122
  Scale of DBA_HIST_SQLSTAT values
By: kwalz58 on Thu, 07 September 2006
2 4255 Mon, 11 September 2006 09:06
By: kwalz58
  other buffer pool .... cache sizes ??
By: tridentadm on Thu, 07 September 2006
6 3271 Fri, 08 September 2006 09:32
By: JSI2001
  Big data Inserts
By: rkl1 on Fri, 18 August 2006
4 2066 Fri, 08 September 2006 09:17
By: goudelly
  inserting data in append mode .. what adv ??
By: tridentadm on Mon, 04 September 2006
2 1613 Fri, 08 September 2006 09:07
By: goudelly
icon5.gif Index Usage and SQL Tuning Question
By: mohannemani on Thu, 07 September 2006
2 2084 Fri, 08 September 2006 07:45
By: rleishman
  column to look for in v$system_event
By: tridentadm on Thu, 07 September 2006
3 1846 Fri, 08 September 2006 01:07
By: tarundua
  shared pool, invalidations and creation indexes ??
By: tridentadm on Thu, 07 September 2006
0 3821 Thu, 07 September 2006 22:42
By: tridentadm
  ORA-01652 - Temporary Tablespace problems!!
By: Tizza on Tue, 05 September 2006
2 7872 Wed, 06 September 2006 02:34
By: wwllzpz
  Hash join hint not being used
By: speaker on Tue, 05 September 2006
4 11108 Wed, 06 September 2006 01:18
By: rleishman
  advantage of append mode ??
By: tridentadm on Mon, 04 September 2006
2 2001 Tue, 05 September 2006 11:12
By: ebrian
  analyze table
By: bahy91 on Tue, 05 September 2006
3 2085 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 1842 Tue, 05 September 2006 07:36
By: rleishman
  Performance tuning SQL
By: speaker on Fri, 01 September 2006
3 2320 Fri, 01 September 2006 20:57
By: BlackSwan
  Cursor time out error(open cursor on bottleneck)
By: pareshr on Fri, 01 September 2006
1 3152 Fri, 01 September 2006 20:48
By: BlackSwan
  db file scattered and sequential read wait events ?
By: tridentadm on Fri, 01 September 2006
1 1768 Fri, 01 September 2006 02:39
By: kimant
  how to calculate shared pool size ??
By: tridentadm on Thu, 31 August 2006
1 1923 Thu, 31 August 2006 04:43
By: Frank Naude
  when was COST optimizer introduced ?
By: tridentadm on Wed, 30 August 2006
3 2092 Thu, 31 August 2006 03:30
By: JRowbottom
  what to do about this one !!!
By: seemit on Wed, 30 August 2006
12 3983 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 2850 Wed, 30 August 2006 06:32
By: adamb
icon2.gif Temp Data files Size
By: mian imran on Tue, 29 August 2006
2 1999 Wed, 30 August 2006 00:16
By: mian imran
  Large Volume Updates And Performance
By: Jackofalltrades on Tue, 29 August 2006
4 2363 Tue, 29 August 2006 23:02
By: rleishman
  Connection Latency
By: amit.pansare on Mon, 28 August 2006
0 3885 Mon, 28 August 2006 15:05
By: amit.pansare
  SLOW Updates
By: dpodborny on Fri, 25 August 2006
4 6011 Mon, 28 August 2006 08:05
By: dpodborny
  Analyze Command
By: javed122 on Fri, 25 August 2006
4 1886 Mon, 28 August 2006 02:42
By: javed122
  the outline error why
By: lazycat on Fri, 25 August 2006
3 2419 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 1806 Wed, 23 August 2006 11:00
By: pabs
  Shared Pool sizing
By: kudur_kv on Tue, 22 August 2006
7 2399 Wed, 23 August 2006 10:59
By: kudur_kv
  Udmp Traces
By: wahdany60 on Mon, 21 August 2006
10 2635 Wed, 23 August 2006 09:47
By: wahdany60
  Index Use and Renaming Partitions
By: faiz_hyd on Mon, 21 August 2006
3 3018 Wed, 23 August 2006 04:31
By: rleishman
  Temp segment issue
By: kudur_kv on Thu, 17 August 2006
4 2852 Tue, 22 August 2006 11:21
By: kudur_kv
  STATSPACK question on 10g and 8i
By: toshidas2000 on Thu, 20 July 2006
2 2064 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: Sat Jun 01 14:29:07 CDT 2024