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 1808 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 2042 Thu, 29 November 2007 23:07
By: Frank
  Problem with SQL
Oracle 10 g, Windows XP
By: kpremsagar on Fri, 23 November 2007
8 2662 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 2406 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 2294 Thu, 29 November 2007 21:35
By: Kevin Meade
  parameter setting error
By: SRIVASUWIN on Thu, 29 November 2007
6 3239 Thu, 29 November 2007 08:22
By: Mohammad Taj
  how to increase the performance
By: mr.rajeshyadav on Wed, 28 November 2007
13 2663 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 2429 Thu, 29 November 2007 00:56
By: rleishman
  Tuning look-up tables : Suggestions needed
Oracle 10g
By: hidnana on Fri, 16 November 2007
2 1946 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 10001 Wed, 28 November 2007 16:23
By: Kevin Meade
  Statspack frequency
By: orausern on Wed, 28 November 2007
6 2612 Wed, 28 November 2007 09:20
By: Mohammad Taj
  Snap Shot Error on User_Tables
By: faiz_hyd on Wed, 14 November 2007
7 4899 Tue, 27 November 2007 13:43
By: Michel Cadot
  SGA size
10g R1,Windows XP
By: gkrishn on Tue, 27 November 2007
3 1632 Tue, 27 November 2007 12:55
By: Mahesh Rajendran
  tunning notes
10.1.0.
By: pratik123 on Sat, 24 November 2007
3 1666 Mon, 26 November 2007 00:27
By: pratik123
  Regarding - Large_pool_size
By: swamitvk on Fri, 23 November 2007
3 1949 Sun, 25 November 2007 03:50
By: Michel Cadot
  advantages and disadvantages of optimization
By: anamika_025 on Sat, 24 November 2007
1 2342 Sat, 24 November 2007 09:41
By: BlackSwan
  recovery of drop table
oracle9i
By: geetu_gaur on Fri, 23 November 2007
1 1736 Fri, 23 November 2007 18:06
By: Mahesh Rajendran
  SHARED POOL contents
By: gkrishn on Fri, 23 November 2007
3 1897 Fri, 23 November 2007 03:15
By: Michel Cadot
  Similar SQLs : Index Usage/Non-usage
By: hidnana on Wed, 21 November 2007
11 2925 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 2296 Wed, 21 November 2007 06:45
By: orausern
  Maximum number of oracle processes
Oracle 10g
By: anamika901 on Fri, 16 November 2007
4 7722 Mon, 19 November 2007 09:12
By: BlackSwan
  Statspack question
9.2.0.8 on Solaris.
By: orausern on Sun, 18 November 2007
2 1775 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 1830 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 2099 Thu, 15 November 2007 19:27
By: rleishman
  How to decide on SGA sizing ???
By: girishta on Thu, 15 November 2007
1 1735 Thu, 15 November 2007 09:41
By: Michel Cadot
  Index
By: webadministrator on Thu, 15 November 2007
5 2154 Thu, 15 November 2007 07:35
By: Michel Cadot
  Urgent Please
By: balajisundar on Fri, 09 November 2007
10 2824 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 7139 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 1972 Wed, 14 November 2007 09:14
By: kesavansundaram
  Query problem
10.2
By: amit_p_dixit on Tue, 13 November 2007
6 1848 Wed, 14 November 2007 05:36
By: JRowbottom
  Pls. help Tune this query
Oracle 10g
By: hidnana on Mon, 12 November 2007
8 2886 Wed, 14 November 2007 01:23
By: rleishman
  Buffer Cache
Oracle 9.2.x.x, Unix
By: balajisundar on Tue, 13 November 2007
4 1876 Tue, 13 November 2007 09:50
By: balajisundar
  SQL Tunning
By: M.Shakeel Azeem on Mon, 12 November 2007
5 2783 Mon, 12 November 2007 20:23
By: rleishman
  BUFFER CACHE
By: kingo on Mon, 12 November 2007
1 1716 Mon, 12 November 2007 03:46
By: Michel Cadot
  truncate
oracle 7
By: dirish on Mon, 05 November 2007
8 2472 Mon, 12 November 2007 00:58
By: Michel Cadot
  Perfomance in Delete and Insert
By: mohseni on Sat, 10 November 2007
3 1531 Sat, 10 November 2007 09:23
By: Michel Cadot
  Process Threads
Oracl 9.2x, Unix
By: balajisundar on Thu, 08 November 2007
2 1734 Fri, 09 November 2007 07:45
By: balajisundar
  Index overhead
Oracle, 9.2x, Unix
By: balajisundar on Thu, 08 November 2007
2 2319 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 3615 Thu, 08 November 2007 09:26
By: S.Rajaram
  INDEX CREATION
oracle 9.2x , UNIX
By: balajisundar on Tue, 06 November 2007
3 1885 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 19 01:12:47 CDT 2024