Replies Views Last message
Please read the OraFAQ Forum Guide before posting.
Please contribute good answers to the wiki.
icon6.gif sticky: How to Identify Performance Problem and Bottleneck
By: Michel Cadot on Fri, 22 June 2007
2 14776 Fri, 28 September 2007 14:11
By: Michel Cadot
  query_rewrite_enabled
10G
By: farenheiit on Fri, 03 July 2009
4 92 Fri, 03 July 2009 17:44
By: farenheiit
how to create partition index on non-partitiion table has been moved to SQL & PL/SQL by the moderator
  Statistics on Empty Partition
oracle 10.2.0.3 in HP-UX11
By: d_ponnilavan on Thu, 02 July 2009
1 50 Thu, 02 July 2009 12:34
By: Michel Cadot
  Index on normal and random column data
Oracle 9.2.0.3
By: prachij593 on Thu, 02 July 2009
2 69 Thu, 02 July 2009 08:09
By: JRowbottom
  9i cbo mode first_rows
Oracle 9i on hp-ux
By: thiagesh on Tue, 30 June 2009
4 109 Thu, 02 July 2009 03:15
By: thiagesh
  choose which index to be create (merged)
By: suryakantnirala on Wed, 01 July 2009
2 41 Wed, 01 July 2009 08:45
By: cookiemonster
  How to avoid Full table scan for Like '%XYZ%'
Oracle 9.2.0.3
By: prachij593 on Wed, 01 July 2009
1 55 Wed, 01 July 2009 07:53
By: JRowbottom
  oracle 11g - 11.0.7.0
solaris 10
By: dirish on Wed, 01 July 2009
4 49 Wed, 01 July 2009 07:30
By: JRowbottom
  stale or empty statiscs
10.2.0.2.0
By: varunvir on Fri, 26 June 2009
5 97 Fri, 26 June 2009 16:42
By: varunvir
  Selection/Updation from a table based on condition
Oracle 10g
By: virmahi on Sun, 24 May 2009
1 245 Fri, 26 June 2009 15:55
By: Barbara Boehmer
  BACKUP OF HISTOGRAMS
Oracle 10g
By: arunprasad_bh on Fri, 26 June 2009
1 53 Fri, 26 June 2009 09:00
By: Michel Cadot
  Storage parameters..
Oralce 10g.
By: venkat_bollu on Fri, 26 June 2009
0 62 Fri, 26 June 2009 07:18
By: venkat_bollu
  How do you know whether the Index is getting used or not
Oracle 10g,Win XP
By: ashoka_bl on Wed, 24 June 2009
7 139 Thu, 25 June 2009 10:29
By: prachij593
  Performance tuning
Oracle 10.2.0.3.0
By: deepbans on Tue, 23 June 2009
7 200 Thu, 25 June 2009 10:22
By: prachij593
  Parallel and First_rows Hints
By: vikram1780 on Tue, 23 June 2009
1 87 Tue, 23 June 2009 05:29
By: Michel Cadot
  import table having 30000000 rows
oracle9i,red hat linux rhel3, having only one processor,ram 1gb
By: suryakantnirala on Mon, 22 June 2009
3 125 Tue, 23 June 2009 01:41
By: Michel Cadot
  performance problem with query
By: vikram1780 on Mon, 22 June 2009
3 132 Mon, 22 June 2009 17:18
By: rleishman
  Problem with query having order by , distinct clause
By: vikram1780 on Sun, 21 June 2009
2 131 Mon, 22 June 2009 03:37
By: vikram1780
  Database Hung due to CPU utilization
Oracle 10.2.0.2.0,Solaris10
By: balaji1482 on Sat, 20 June 2009
4 181 Sun, 21 June 2009 08:04
By: balaji1482
  May you explain to me about AWR?
Oracle 10.2.0.1, Solaris Sparc 64bit
By: trantuananh24hg on Thu, 18 June 2009
8 188 Fri, 19 June 2009 02:37
By: trantuananh24hg
  Improving Performance of Large Result Set
11g
By: jkomorek on Thu, 18 June 2009
9 158 Thu, 18 June 2009 17:33
By: jkomorek
  Database stops responding when run on production server
Oracle 10g
By: sonikumari on Mon, 15 June 2009
3 186 Thu, 18 June 2009 09:18
By: JRowbottom
  is there any need of rebuild pk index
oracle 9i (9.2),linux rhel3
By: suryakantnirala on Thu, 18 June 2009
2 102 Thu, 18 June 2009 01:35
By: Michel Cadot
  ORA-1652: unable to extend temp
Oracle 10g R2 ,AIX
By: gkrishn on Sun, 14 June 2009
4 197 Tue, 16 June 2009 23:32
By: trantuananh24hg
  reload of statements in library cache
oracle 9i, linux rhel3
By: suryakantnirala on Mon, 15 June 2009
8 261 Tue, 16 June 2009 06:58
By: amitzil
  How to tune latch: cache buffers chains
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0
By: upendra4321 on Wed, 10 June 2009
2 192 Fri, 12 June 2009 23:15
By: trantuananh24hg
icon5.gif Group By Behaviors
Oracle Database 10g 10.2.0.4.0 - 64bit, UNIX
By: ykathirv on Thu, 11 June 2009
12 273 Fri, 12 June 2009 04:53
By: ykathirv
  HINT INDEX Usage
9.2.0.7
By: Brayan on Fri, 12 June 2009
1 131 Fri, 12 June 2009 04:40
By: Michel Cadot
  How to tune memory size in oracle 8i (merged)
By: sanjay6713 on Fri, 12 June 2009
12 110 Fri, 12 June 2009 04:38
By: Michel Cadot
  Dynamic_sampling and partitioning
10.2.0.4
By: farenheiit on Thu, 11 June 2009
1 163 Thu, 11 June 2009 11:16
By: BlackSwan
  slow query with MERGE JOIN CARTESIAN and LATCH cache buffer chains
10g
By: farenheiit on Thu, 11 June 2009
2 127 Thu, 11 June 2009 09:57
By: farenheiit
  Performance Tuning in Count(DISTINCT
Oracle 9i
By: sivakumar.rj on Wed, 10 June 2009
7 185 Wed, 10 June 2009 17:23
By: BlackSwan
  Latch:Library Cache
Solaris 10, 10.2.0.1 DB
By: trantuananh24hg on Tue, 09 June 2009
5 133 Tue, 09 June 2009 23:54
By: trantuananh24hg
icon5.gif very simple but very slow query
Oracle Database 10g, Suse Linux 10
By: beingman on Fri, 05 June 2009
22 378 Mon, 08 June 2009 05:25
By: beingman
icon13.gif Performance degrades with big block size tablespace
oracle 10G R2, Sun solaris 10
By: bangalibor on Sun, 17 May 2009
13 420 Sat, 06 June 2009 20:57
By: rleishman
  Performance of database runnig on RAC 10g with two Solaris nodes
Oracle 10g RAC
By: alexberi on Mon, 01 June 2009
12 316 Fri, 05 June 2009 12:59
By: alexberi
  stale_stats and STATTYPE_LOCKED in DBA_TAB_STATISTICS
By: casttree on Fri, 05 June 2009
1 122 Fri, 05 June 2009 03:10
By: Michel Cadot
  How to judge the slow query?
Windows 2003 SP2 Oracle 10.2.0.4 32-bit
By: crazypeter2005 on Tue, 19 May 2009
17 363 Mon, 01 June 2009 04:49
By: crazypeter2005
icon5.gif IOT - what is that?
By: wakula on Fri, 29 May 2009
5 211 Sat, 30 May 2009 16:54
By: BlackSwan
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 Jul 4 20:19:04 CDT 2009

Total time taken to generate the page: 0.04516 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.