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 2248 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 1874 Fri, 15 September 2006 10:11
By: coral_3
  Number of Datafiles in a Tablespace
By: faiz_hyd on Fri, 15 September 2006
2 1880 Fri, 15 September 2006 10:04
By: faiz_hyd
  Estimate_Percent for Analyze Schema
By: rkulasek on Tue, 12 September 2006
4 4406 Thu, 14 September 2006 00:25
By: rkulasek
  Analyze increases cost
By: manish mendiratta on Wed, 13 September 2006
1 1589 Wed, 13 September 2006 21:31
By: rleishman
  help with coming up a test case!
By: orausern on Mon, 11 September 2006
5 2430 Wed, 13 September 2006 07:29
By: JRowbottom
  Merge Partition into 1 single partition
By: faiz_hyd on Tue, 12 September 2006
1 2071 Tue, 12 September 2006 21:23
By: email.sandeepnaik
  sql_trace question
By: rkl1 on Mon, 11 September 2006
1 1933 Tue, 12 September 2006 03:45
By: AndreyPozhidaev
  enable Full-Text Search
By: javed122 on Mon, 11 September 2006
2 2067 Mon, 11 September 2006 09:08
By: javed122
  Scale of DBA_HIST_SQLSTAT values
By: kwalz58 on Thu, 07 September 2006
2 4292 Mon, 11 September 2006 09:06
By: kwalz58
  other buffer pool .... cache sizes ??
By: tridentadm on Thu, 07 September 2006
6 3296 Fri, 08 September 2006 09:32
By: JSI2001
  Big data Inserts
By: rkl1 on Fri, 18 August 2006
4 2104 Fri, 08 September 2006 09:17
By: goudelly
  inserting data in append mode .. what adv ??
By: tridentadm on Mon, 04 September 2006
2 1645 Fri, 08 September 2006 09:07
By: goudelly
icon5.gif Index Usage and SQL Tuning Question
By: mohannemani on Thu, 07 September 2006
2 2118 Fri, 08 September 2006 07:45
By: rleishman
  column to look for in v$system_event
By: tridentadm on Thu, 07 September 2006
3 1878 Fri, 08 September 2006 01:07
By: tarundua
  shared pool, invalidations and creation indexes ??
By: tridentadm on Thu, 07 September 2006
0 3851 Thu, 07 September 2006 22:42
By: tridentadm
  ORA-01652 - Temporary Tablespace problems!!
By: Tizza on Tue, 05 September 2006
2 7904 Wed, 06 September 2006 02:34
By: wwllzpz
  Hash join hint not being used
By: speaker on Tue, 05 September 2006
4 11143 Wed, 06 September 2006 01:18
By: rleishman
  advantage of append mode ??
By: tridentadm on Mon, 04 September 2006
2 2029 Tue, 05 September 2006 11:12
By: ebrian
  analyze table
By: bahy91 on Tue, 05 September 2006
3 2124 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 1882 Tue, 05 September 2006 07:36
By: rleishman
  Performance tuning SQL
By: speaker on Fri, 01 September 2006
3 2352 Fri, 01 September 2006 20:57
By: BlackSwan
  Cursor time out error(open cursor on bottleneck)
By: pareshr on Fri, 01 September 2006
1 3186 Fri, 01 September 2006 20:48
By: BlackSwan
  db file scattered and sequential read wait events ?
By: tridentadm on Fri, 01 September 2006
1 1799 Fri, 01 September 2006 02:39
By: kimant
  how to calculate shared pool size ??
By: tridentadm on Thu, 31 August 2006
1 1960 Thu, 31 August 2006 04:43
By: Frank Naude
  when was COST optimizer introduced ?
By: tridentadm on Wed, 30 August 2006
3 2122 Thu, 31 August 2006 03:30
By: JRowbottom
  what to do about this one !!!
By: seemit on Wed, 30 August 2006
12 4019 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 2879 Wed, 30 August 2006 06:32
By: adamb
icon2.gif Temp Data files Size
By: mian imran on Tue, 29 August 2006
2 2032 Wed, 30 August 2006 00:16
By: mian imran
  Large Volume Updates And Performance
By: Jackofalltrades on Tue, 29 August 2006
4 2397 Tue, 29 August 2006 23:02
By: rleishman
  Connection Latency
By: amit.pansare on Mon, 28 August 2006
0 3922 Mon, 28 August 2006 15:05
By: amit.pansare
  SLOW Updates
By: dpodborny on Fri, 25 August 2006
4 6040 Mon, 28 August 2006 08:05
By: dpodborny
  Analyze Command
By: javed122 on Fri, 25 August 2006
4 1921 Mon, 28 August 2006 02:42
By: javed122
  the outline error why
By: lazycat on Fri, 25 August 2006
3 2447 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 1838 Wed, 23 August 2006 11:00
By: pabs
  Shared Pool sizing
By: kudur_kv on Tue, 22 August 2006
7 2428 Wed, 23 August 2006 10:59
By: kudur_kv
  Udmp Traces
By: wahdany60 on Mon, 21 August 2006
10 2668 Wed, 23 August 2006 09:47
By: wahdany60
  Index Use and Renaming Partitions
By: faiz_hyd on Mon, 21 August 2006
3 3056 Wed, 23 August 2006 04:31
By: rleishman
  Temp segment issue
By: kudur_kv on Thu, 17 August 2006
4 2884 Tue, 22 August 2006 11:21
By: kudur_kv
  STATSPACK question on 10g and 8i
By: toshidas2000 on Thu, 20 July 2006
2 2100 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 Jun 27 02:33:35 CDT 2024