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

    Replies Views Last message
  sql performance
By: sellafrica on Thu, 29 November 2007
4 2632 Sun, 02 December 2007 20:12
By: rleishman
  Weird client performance problem
10gR2 Standard Edition RAC; 10gR2 Instant Client
By: dhock194 on Sun, 02 December 2007
1 1627 Sun, 02 December 2007 19:59
By: rleishman
  Question about joins
By: SRIVASUWIN on Thu, 29 November 2007
3 2544 Sat, 01 December 2007 20:09
By: rleishman
icon4.gif Poor Insert Performance after table truncation was interupted
By: williamhwh on Fri, 30 November 2007
3 2524 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 2253 Thu, 29 November 2007 23:07
By: Frank
  Problem with SQL
Oracle 10 g, Windows XP
By: kpremsagar on Fri, 23 November 2007
8 3031 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 3490 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 2547 Thu, 29 November 2007 21:35
By: Kevin Meade
  parameter setting error
By: SRIVASUWIN on Thu, 29 November 2007
6 4848 Thu, 29 November 2007 08:22
By: Mohammad Taj
  how to increase the performance
By: mr.rajeshyadav on Wed, 28 November 2007
13 5195 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 2954 Thu, 29 November 2007 00:56
By: rleishman
  Tuning look-up tables : Suggestions needed
Oracle 10g
By: hidnana on Fri, 16 November 2007
2 2340 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 11186 Wed, 28 November 2007 16:23
By: Kevin Meade
  Statspack frequency
By: orausern on Wed, 28 November 2007
6 3994 Wed, 28 November 2007 09:20
By: Mohammad Taj
  Snap Shot Error on User_Tables
By: faiz_hyd on Wed, 14 November 2007
7 5372 Tue, 27 November 2007 13:43
By: Michel Cadot
  SGA size
10g R1,Windows XP
By: gkrishn on Tue, 27 November 2007
3 1839 Tue, 27 November 2007 12:55
By: Mahesh Rajendran
  tunning notes
10.1.0.
By: pratik123 on Sat, 24 November 2007
3 2328 Mon, 26 November 2007 00:27
By: pratik123
  Regarding - Large_pool_size
By: swamitvk on Fri, 23 November 2007
3 2471 Sun, 25 November 2007 03:50
By: Michel Cadot
  advantages and disadvantages of optimization
By: anamika_025 on Sat, 24 November 2007
1 2735 Sat, 24 November 2007 09:41
By: BlackSwan
  recovery of drop table
oracle9i
By: geetu_gaur on Fri, 23 November 2007
1 2017 Fri, 23 November 2007 18:06
By: Mahesh Rajendran
  SHARED POOL contents
By: gkrishn on Fri, 23 November 2007
3 2570 Fri, 23 November 2007 03:15
By: Michel Cadot
  Similar SQLs : Index Usage/Non-usage
By: hidnana on Wed, 21 November 2007
11 3280 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 2681 Wed, 21 November 2007 06:45
By: orausern
  Maximum number of oracle processes
Oracle 10g
By: anamika901 on Fri, 16 November 2007
4 8401 Mon, 19 November 2007 09:12
By: BlackSwan
  Statspack question
9.2.0.8 on Solaris.
By: orausern on Sun, 18 November 2007
2 2012 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 2277 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 3093 Thu, 15 November 2007 19:27
By: rleishman
  How to decide on SGA sizing ???
By: girishta on Thu, 15 November 2007
1 2275 Thu, 15 November 2007 09:41
By: Michel Cadot
  Index
By: webadministrator on Thu, 15 November 2007
5 3616 Thu, 15 November 2007 07:35
By: Michel Cadot
  Urgent Please
By: balajisundar on Fri, 09 November 2007
10 3168 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 7304 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 2269 Wed, 14 November 2007 09:14
By: kesavansundaram
  Query problem
10.2
By: amit_p_dixit on Tue, 13 November 2007
6 2069 Wed, 14 November 2007 05:36
By: JRowbottom
  Pls. help Tune this query
Oracle 10g
By: hidnana on Mon, 12 November 2007
8 3188 Wed, 14 November 2007 01:23
By: rleishman
  Buffer Cache
Oracle 9.2.x.x, Unix
By: balajisundar on Tue, 13 November 2007
4 2316 Tue, 13 November 2007 09:50
By: balajisundar
  SQL Tunning
By: M.Shakeel Azeem on Mon, 12 November 2007
5 3013 Mon, 12 November 2007 20:23
By: rleishman
  BUFFER CACHE
By: kingo on Mon, 12 November 2007
1 1949 Mon, 12 November 2007 03:46
By: Michel Cadot
  truncate
oracle 7
By: dirish on Mon, 05 November 2007
8 4088 Mon, 12 November 2007 00:58
By: Michel Cadot
  Perfomance in Delete and Insert
By: mohseni on Sat, 10 November 2007
3 1786 Sat, 10 November 2007 09:23
By: Michel Cadot
  Process Threads
Oracl 9.2x, Unix
By: balajisundar on Thu, 08 November 2007
2 2460 Fri, 09 November 2007 07:45
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: Tue Jul 29 15:40:41 CDT 2025