Home » RDBMS Server » Performance Tuning
Please read the OraFAQ Forum Guide before posting.
Please contribute good answers to the wiki.

    Replies Views Last message
icon4.gif Poor Insert Performance after table truncation was interupted
By: williamhwh on Fri, 30 November 2007
3 1781 Sat, 01 December 2007 13:30
By: michael_bialik
  Removing Duplicates Query
9.2.0.5 Sun O.S 5.7
By: faiz_hyd on Thu, 29 November 2007
3 2013 Thu, 29 November 2007 23:07
By: Frank
  Problem with SQL
Oracle 10 g, Windows XP
By: kpremsagar on Fri, 23 November 2007
8 2625 Thu, 29 November 2007 21:58
By: Kevin Meade
  order of drop,create and create index during data load
By: beeky on Tue, 27 November 2007
5 2383 Thu, 29 November 2007 21:47
By: Kevin Meade
  Rebuild of indexes and 'Sweeper' referred in Ask tom site Options
By: orausern on Thu, 29 November 2007
2 2276 Thu, 29 November 2007 21:35
By: Kevin Meade
  parameter setting error
By: SRIVASUWIN on Thu, 29 November 2007
6 3225 Thu, 29 November 2007 08:22
By: Mohammad Taj
  how to increase the performance
By: mr.rajeshyadav on Wed, 28 November 2007
13 2637 Thu, 29 November 2007 03:28
By: mr.rajeshyadav
  Issue updating a partitioned table
Oracle 10 g, Windows XP
By: kpremsagar on Tue, 27 November 2007
10 2395 Thu, 29 November 2007 00:56
By: rleishman
  Tuning look-up tables : Suggestions needed
Oracle 10g
By: hidnana on Fri, 16 November 2007
2 1921 Wed, 28 November 2007 16:32
By: Kevin Meade
  oracle sequence is causing high cpu usage?
oracle sequence is causing high cpu usage?
By: dba4bank on Wed, 31 October 2007
7 9967 Wed, 28 November 2007 16:23
By: Kevin Meade
  Statspack frequency
By: orausern on Wed, 28 November 2007
6 2587 Wed, 28 November 2007 09:20
By: Mohammad Taj
  Snap Shot Error on User_Tables
By: faiz_hyd on Wed, 14 November 2007
7 4872 Tue, 27 November 2007 13:43
By: Michel Cadot
  SGA size
10g R1,Windows XP
By: gkrishn on Tue, 27 November 2007
3 1610 Tue, 27 November 2007 12:55
By: Mahesh Rajendran
  tunning notes
10.1.0.
By: pratik123 on Sat, 24 November 2007
3 1642 Mon, 26 November 2007 00:27
By: pratik123
  Regarding - Large_pool_size
By: swamitvk on Fri, 23 November 2007
3 1928 Sun, 25 November 2007 03:50
By: Michel Cadot
  advantages and disadvantages of optimization
By: anamika_025 on Sat, 24 November 2007
1 2326 Sat, 24 November 2007 09:41
By: BlackSwan
  recovery of drop table
oracle9i
By: geetu_gaur on Fri, 23 November 2007
1 1721 Fri, 23 November 2007 18:06
By: Mahesh Rajendran
  SHARED POOL contents
By: gkrishn on Fri, 23 November 2007
3 1872 Fri, 23 November 2007 03:15
By: Michel Cadot
  Similar SQLs : Index Usage/Non-usage
By: hidnana on Wed, 21 November 2007
11 2888 Thu, 22 November 2007 20:54
By: rleishman
  Another question related to Statspack
Oracle 9.2.0.8 on Solaris
By: orausern on Mon, 19 November 2007
5 2277 Wed, 21 November 2007 06:45
By: orausern
  Maximum number of oracle processes
Oracle 10g
By: anamika901 on Fri, 16 November 2007
4 7700 Mon, 19 November 2007 09:12
By: BlackSwan
  Statspack question
9.2.0.8 on Solaris.
By: orausern on Sun, 18 November 2007
2 1754 Mon, 19 November 2007 03:23
By: orausern
  consistent gets > segment size during FTS
9.2.0.8 solaris 8
By: mlobel1 on Fri, 16 November 2007
2 1813 Fri, 16 November 2007 09:49
By: mlobel1
  Help needed in tuning this query
Oracle 10.2.0.2, HP Unix
By: hidnana on Wed, 14 November 2007
4 2078 Thu, 15 November 2007 19:27
By: rleishman
  How to decide on SGA sizing ???
By: girishta on Thu, 15 November 2007
1 1720 Thu, 15 November 2007 09:41
By: Michel Cadot
  Index
By: webadministrator on Thu, 15 November 2007
5 2131 Thu, 15 November 2007 07:35
By: Michel Cadot
  Urgent Please
By: balajisundar on Fri, 09 November 2007
10 2793 Thu, 15 November 2007 03:36
By: balajisundar
  Why such a difference in explain plans
Oracle 9.2.5.0
By: MarcL on Wed, 14 November 2007
0 7123 Wed, 14 November 2007 10:35
By: MarcL
  Need to perform INDEX RANGE SCAN instead of FTS
oracle 9.2.0.6.0 ,sunsolaris 9.5
By: kesavansundaram on Wed, 14 November 2007
2 1947 Wed, 14 November 2007 09:14
By: kesavansundaram
  Query problem
10.2
By: amit_p_dixit on Tue, 13 November 2007
6 1828 Wed, 14 November 2007 05:36
By: JRowbottom
  Pls. help Tune this query
Oracle 10g
By: hidnana on Mon, 12 November 2007
8 2877 Wed, 14 November 2007 01:23
By: rleishman
  Buffer Cache
Oracle 9.2.x.x, Unix
By: balajisundar on Tue, 13 November 2007
4 1859 Tue, 13 November 2007 09:50
By: balajisundar
  SQL Tunning
By: M.Shakeel Azeem on Mon, 12 November 2007
5 2760 Mon, 12 November 2007 20:23
By: rleishman
  BUFFER CACHE
By: kingo on Mon, 12 November 2007
1 1699 Mon, 12 November 2007 03:46
By: Michel Cadot
  truncate
oracle 7
By: dirish on Mon, 05 November 2007
8 2458 Mon, 12 November 2007 00:58
By: Michel Cadot
  Perfomance in Delete and Insert
By: mohseni on Sat, 10 November 2007
3 1499 Sat, 10 November 2007 09:23
By: Michel Cadot
  Process Threads
Oracl 9.2x, Unix
By: balajisundar on Thu, 08 November 2007
2 1705 Fri, 09 November 2007 07:45
By: balajisundar
  Index overhead
Oracle, 9.2x, Unix
By: balajisundar on Thu, 08 November 2007
2 2289 Thu, 08 November 2007 11:40
By: DreamzZ
  How to improve a group by sql stmt (merged)
By: dasgupta.amitava@gmail on Wed, 07 November 2007
4 3584 Thu, 08 November 2007 09:26
By: S.Rajaram
  INDEX CREATION
oracle 9.2x , UNIX
By: balajisundar on Tue, 06 November 2007
3 1870 Wed, 07 November 2007 03:29
By: balajisundar
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 Sep 12 08:06:50 CDT 2024