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 2168 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 1786 Fri, 15 September 2006 10:11
By: coral_3
  Number of Datafiles in a Tablespace
By: faiz_hyd on Fri, 15 September 2006
2 1809 Fri, 15 September 2006 10:04
By: faiz_hyd
  Estimate_Percent for Analyze Schema
By: rkulasek on Tue, 12 September 2006
4 4332 Thu, 14 September 2006 00:25
By: rkulasek
  Analyze increases cost
By: manish mendiratta on Wed, 13 September 2006
1 1504 Wed, 13 September 2006 21:31
By: rleishman
  help with coming up a test case!
By: orausern on Mon, 11 September 2006
5 2353 Wed, 13 September 2006 07:29
By: JRowbottom
  Merge Partition into 1 single partition
By: faiz_hyd on Tue, 12 September 2006
1 1997 Tue, 12 September 2006 21:23
By: email.sandeepnaik
  sql_trace question
By: rkl1 on Mon, 11 September 2006
1 1846 Tue, 12 September 2006 03:45
By: AndreyPozhidaev
  enable Full-Text Search
By: javed122 on Mon, 11 September 2006
2 1983 Mon, 11 September 2006 09:08
By: javed122
  Scale of DBA_HIST_SQLSTAT values
By: kwalz58 on Thu, 07 September 2006
2 4201 Mon, 11 September 2006 09:06
By: kwalz58
  other buffer pool .... cache sizes ??
By: tridentadm on Thu, 07 September 2006
6 3224 Fri, 08 September 2006 09:32
By: JSI2001
  Big data Inserts
By: rkl1 on Fri, 18 August 2006
4 2015 Fri, 08 September 2006 09:17
By: goudelly
  inserting data in append mode .. what adv ??
By: tridentadm on Mon, 04 September 2006
2 1559 Fri, 08 September 2006 09:07
By: goudelly
icon5.gif Index Usage and SQL Tuning Question
By: mohannemani on Thu, 07 September 2006
2 2039 Fri, 08 September 2006 07:45
By: rleishman
  column to look for in v$system_event
By: tridentadm on Thu, 07 September 2006
3 1801 Fri, 08 September 2006 01:07
By: tarundua
  shared pool, invalidations and creation indexes ??
By: tridentadm on Thu, 07 September 2006
0 3769 Thu, 07 September 2006 22:42
By: tridentadm
  ORA-01652 - Temporary Tablespace problems!!
By: Tizza on Tue, 05 September 2006
2 7824 Wed, 06 September 2006 02:34
By: wwllzpz
  Hash join hint not being used
By: speaker on Tue, 05 September 2006
4 11063 Wed, 06 September 2006 01:18
By: rleishman
  advantage of append mode ??
By: tridentadm on Mon, 04 September 2006
2 1955 Tue, 05 September 2006 11:12
By: ebrian
  analyze table
By: bahy91 on Tue, 05 September 2006
3 2036 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 1791 Tue, 05 September 2006 07:36
By: rleishman
  Performance tuning SQL
By: speaker on Fri, 01 September 2006
3 2271 Fri, 01 September 2006 20:57
By: BlackSwan
  Cursor time out error(open cursor on bottleneck)
By: pareshr on Fri, 01 September 2006
1 3102 Fri, 01 September 2006 20:48
By: BlackSwan
  db file scattered and sequential read wait events ?
By: tridentadm on Fri, 01 September 2006
1 1723 Fri, 01 September 2006 02:39
By: kimant
  how to calculate shared pool size ??
By: tridentadm on Thu, 31 August 2006
1 1868 Thu, 31 August 2006 04:43
By: Frank Naude
  when was COST optimizer introduced ?
By: tridentadm on Wed, 30 August 2006
3 2049 Thu, 31 August 2006 03:30
By: JRowbottom
  what to do about this one !!!
By: seemit on Wed, 30 August 2006
12 3931 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 2805 Wed, 30 August 2006 06:32
By: adamb
icon2.gif Temp Data files Size
By: mian imran on Tue, 29 August 2006
2 1950 Wed, 30 August 2006 00:16
By: mian imran
  Large Volume Updates And Performance
By: Jackofalltrades on Tue, 29 August 2006
4 2318 Tue, 29 August 2006 23:02
By: rleishman
  Connection Latency
By: amit.pansare on Mon, 28 August 2006
0 3842 Mon, 28 August 2006 15:05
By: amit.pansare
  SLOW Updates
By: dpodborny on Fri, 25 August 2006
4 5963 Mon, 28 August 2006 08:05
By: dpodborny
  Analyze Command
By: javed122 on Fri, 25 August 2006
4 1838 Mon, 28 August 2006 02:42
By: javed122
  the outline error why
By: lazycat on Fri, 25 August 2006
3 2369 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 1761 Wed, 23 August 2006 11:00
By: pabs
  Shared Pool sizing
By: kudur_kv on Tue, 22 August 2006
7 2344 Wed, 23 August 2006 10:59
By: kudur_kv
  Udmp Traces
By: wahdany60 on Mon, 21 August 2006
10 2585 Wed, 23 August 2006 09:47
By: wahdany60
  Index Use and Renaming Partitions
By: faiz_hyd on Mon, 21 August 2006
3 2971 Wed, 23 August 2006 04:31
By: rleishman
  Temp segment issue
By: kudur_kv on Thu, 17 August 2006
4 2799 Tue, 22 August 2006 11:21
By: kudur_kv
  STATSPACK question on 10g and 8i
By: toshidas2000 on Thu, 20 July 2006
2 2020 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 Apr 25 23:46:32 CDT 2024