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 2197 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 1814 Fri, 15 September 2006 10:11
By: coral_3
  Number of Datafiles in a Tablespace
By: faiz_hyd on Fri, 15 September 2006
2 1834 Fri, 15 September 2006 10:04
By: faiz_hyd
  Estimate_Percent for Analyze Schema
By: rkulasek on Tue, 12 September 2006
4 4358 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 2382 Wed, 13 September 2006 07:29
By: JRowbottom
  Merge Partition into 1 single partition
By: faiz_hyd on Tue, 12 September 2006
1 2025 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 2008 Mon, 11 September 2006 09:08
By: javed122
  Scale of DBA_HIST_SQLSTAT values
By: kwalz58 on Thu, 07 September 2006
2 4235 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 2044 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 2065 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 3800 Thu, 07 September 2006 22:42
By: tridentadm
  ORA-01652 - Temporary Tablespace problems!!
By: Tizza on Tue, 05 September 2006
2 7849 Wed, 06 September 2006 02:34
By: wwllzpz
  Hash join hint not being used
By: speaker on Tue, 05 September 2006
4 11091 Wed, 06 September 2006 01:18
By: rleishman
  advantage of append mode ??
By: tridentadm on Mon, 04 September 2006
2 1981 Tue, 05 September 2006 11:12
By: ebrian
  analyze table
By: bahy91 on Tue, 05 September 2006
3 2061 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 1819 Tue, 05 September 2006 07:36
By: rleishman
  Performance tuning SQL
By: speaker on Fri, 01 September 2006
3 2302 Fri, 01 September 2006 20:57
By: BlackSwan
  Cursor time out error(open cursor on bottleneck)
By: pareshr on Fri, 01 September 2006
1 3136 Fri, 01 September 2006 20:48
By: BlackSwan
  db file scattered and sequential read wait events ?
By: tridentadm on Fri, 01 September 2006
1 1751 Fri, 01 September 2006 02:39
By: kimant
  how to calculate shared pool size ??
By: tridentadm on Thu, 31 August 2006
1 1902 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 3966 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 2829 Wed, 30 August 2006 06:32
By: adamb
icon2.gif Temp Data files Size
By: mian imran on Tue, 29 August 2006
2 1977 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 3868 Mon, 28 August 2006 15:05
By: amit.pansare
  SLOW Updates
By: dpodborny on Fri, 25 August 2006
4 5990 Mon, 28 August 2006 08:05
By: dpodborny
  Analyze Command
By: javed122 on Fri, 25 August 2006
4 1864 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 2616 Wed, 23 August 2006 09:47
By: wahdany60
  Index Use and Renaming Partitions
By: faiz_hyd on Mon, 21 August 2006
3 3002 Wed, 23 August 2006 04:31
By: rleishman
  Temp segment issue
By: kudur_kv on Thu, 17 August 2006
4 2825 Tue, 22 August 2006 11:21
By: kudur_kv
  STATSPACK question on 10g and 8i
By: toshidas2000 on Thu, 20 July 2006
2 2046 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: Sun May 19 18:00:09 CDT 2024