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

    Replies Views Last message
  Removing Duplicates Query
9.2.0.5 Sun O.S 5.7
By: faiz_hyd on Thu, 29 November 2007
3 1851 Thu, 29 November 2007 23:07
By: Frank
  Problem with SQL
Oracle 10 g, Windows XP
By: kpremsagar on Fri, 23 November 2007
8 2449 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 2218 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 2126 Thu, 29 November 2007 21:35
By: Kevin Meade
  parameter setting error
By: SRIVASUWIN on Thu, 29 November 2007
6 3051 Thu, 29 November 2007 08:22
By: Mohammad Taj
  how to increase the performance
By: mr.rajeshyadav on Wed, 28 November 2007
13 2440 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 2204 Thu, 29 November 2007 00:56
By: rleishman
  Tuning look-up tables : Suggestions needed
Oracle 10g
By: hidnana on Fri, 16 November 2007
2 1751 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 9778 Wed, 28 November 2007 16:23
By: Kevin Meade
  Statspack frequency
By: orausern on Wed, 28 November 2007
6 2422 Wed, 28 November 2007 09:20
By: Mohammad Taj
  Snap Shot Error on User_Tables
By: faiz_hyd on Wed, 14 November 2007
7 4638 Tue, 27 November 2007 13:43
By: Michel Cadot
  SGA size
10g R1,Windows XP
By: gkrishn on Tue, 27 November 2007
3 1463 Tue, 27 November 2007 12:55
By: Mahesh Rajendran
  tunning notes
10.1.0.
By: pratik123 on Sat, 24 November 2007
3 1486 Mon, 26 November 2007 00:27
By: pratik123
  Regarding - Large_pool_size
By: swamitvk on Fri, 23 November 2007
3 1775 Sun, 25 November 2007 03:50
By: Michel Cadot
  advantages and disadvantages of optimization
By: anamika_025 on Sat, 24 November 2007
1 2177 Sat, 24 November 2007 09:41
By: BlackSwan
  recovery of drop table
oracle9i
By: geetu_gaur on Fri, 23 November 2007
1 1578 Fri, 23 November 2007 18:06
By: Mahesh Rajendran
  SHARED POOL contents
By: gkrishn on Fri, 23 November 2007
3 1721 Fri, 23 November 2007 03:15
By: Michel Cadot
  Similar SQLs : Index Usage/Non-usage
By: hidnana on Wed, 21 November 2007
11 2753 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 2134 Wed, 21 November 2007 06:45
By: orausern
  Maximum number of oracle processes
Oracle 10g
By: anamika901 on Fri, 16 November 2007
4 7541 Mon, 19 November 2007 09:12
By: BlackSwan
  Statspack question
9.2.0.8 on Solaris.
By: orausern on Sun, 18 November 2007
2 1621 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 1677 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 1935 Thu, 15 November 2007 19:27
By: rleishman
  How to decide on SGA sizing ???
By: girishta on Thu, 15 November 2007
1 1574 Thu, 15 November 2007 09:41
By: Michel Cadot
  Index
By: webadministrator on Thu, 15 November 2007
5 1967 Thu, 15 November 2007 07:35
By: Michel Cadot
  Urgent Please
By: balajisundar on Fri, 09 November 2007
10 2610 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 6986 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 1772 Wed, 14 November 2007 09:14
By: kesavansundaram
  Query problem
10.2
By: amit_p_dixit on Tue, 13 November 2007
6 1678 Wed, 14 November 2007 05:36
By: JRowbottom
  Pls. help Tune this query
Oracle 10g
By: hidnana on Mon, 12 November 2007
8 2705 Wed, 14 November 2007 01:23
By: rleishman
  Buffer Cache
Oracle 9.2.x.x, Unix
By: balajisundar on Tue, 13 November 2007
4 1701 Tue, 13 November 2007 09:50
By: balajisundar
  SQL Tunning
By: M.Shakeel Azeem on Mon, 12 November 2007
5 2596 Mon, 12 November 2007 20:23
By: rleishman
  BUFFER CACHE
By: kingo on Mon, 12 November 2007
1 1555 Mon, 12 November 2007 03:46
By: Michel Cadot
  truncate
oracle 7
By: dirish on Mon, 05 November 2007
8 2289 Mon, 12 November 2007 00:58
By: Michel Cadot
  Perfomance in Delete and Insert
By: mohseni on Sat, 10 November 2007
3 1357 Sat, 10 November 2007 09:23
By: Michel Cadot
  Process Threads
Oracl 9.2x, Unix
By: balajisundar on Thu, 08 November 2007
2 1564 Fri, 09 November 2007 07:45
By: balajisundar
  Index overhead
Oracle, 9.2x, Unix
By: balajisundar on Thu, 08 November 2007
2 2157 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 3430 Thu, 08 November 2007 09:26
By: S.Rajaram
  INDEX CREATION
oracle 9.2x , UNIX
By: balajisundar on Tue, 06 November 2007
3 1724 Wed, 07 November 2007 03:29
By: balajisundar
  Slow performance
Oracle 10.2.0.2, Solaris 5.8
By: kamragulshan on Wed, 07 November 2007
1 1552 Wed, 07 November 2007 02:49
By: Michel Cadot
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 May 16 09:27:06 CDT 2024