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 2767 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 1716 Sun, 02 December 2007 19:59
By: rleishman
  Question about joins
By: SRIVASUWIN on Thu, 29 November 2007
3 2662 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 2621 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 2378 Thu, 29 November 2007 23:07
By: Frank
  Problem with SQL
Oracle 10 g, Windows XP
By: kpremsagar on Fri, 23 November 2007
8 3201 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 3629 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 2649 Thu, 29 November 2007 21:35
By: Kevin Meade
  parameter setting error
By: SRIVASUWIN on Thu, 29 November 2007
6 5032 Thu, 29 November 2007 08:22
By: Mohammad Taj
  how to increase the performance
By: mr.rajeshyadav on Wed, 28 November 2007
13 5491 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 3166 Thu, 29 November 2007 00:56
By: rleishman
  Tuning look-up tables : Suggestions needed
Oracle 10g
By: hidnana on Fri, 16 November 2007
2 2452 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 11447 Wed, 28 November 2007 16:23
By: Kevin Meade
  Statspack frequency
By: orausern on Wed, 28 November 2007
6 4208 Wed, 28 November 2007 09:20
By: Mohammad Taj
  Snap Shot Error on User_Tables
By: faiz_hyd on Wed, 14 November 2007
7 5589 Tue, 27 November 2007 13:43
By: Michel Cadot
  SGA size
10g R1,Windows XP
By: gkrishn on Tue, 27 November 2007
3 1966 Tue, 27 November 2007 12:55
By: Mahesh Rajendran
  tunning notes
10.1.0.
By: pratik123 on Sat, 24 November 2007
3 2473 Mon, 26 November 2007 00:27
By: pratik123
  Regarding - Large_pool_size
By: swamitvk on Fri, 23 November 2007
3 2591 Sun, 25 November 2007 03:50
By: Michel Cadot
  advantages and disadvantages of optimization
By: anamika_025 on Sat, 24 November 2007
1 2829 Sat, 24 November 2007 09:41
By: BlackSwan
  recovery of drop table
oracle9i
By: geetu_gaur on Fri, 23 November 2007
1 2184 Fri, 23 November 2007 18:06
By: Mahesh Rajendran
  SHARED POOL contents
By: gkrishn on Fri, 23 November 2007
3 2686 Fri, 23 November 2007 03:15
By: Michel Cadot
  Similar SQLs : Index Usage/Non-usage
By: hidnana on Wed, 21 November 2007
11 3557 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 2827 Wed, 21 November 2007 06:45
By: orausern
  Maximum number of oracle processes
Oracle 10g
By: anamika901 on Fri, 16 November 2007
4 8534 Mon, 19 November 2007 09:12
By: BlackSwan
  Statspack question
9.2.0.8 on Solaris.
By: orausern on Sun, 18 November 2007
2 2129 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 2381 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 3242 Thu, 15 November 2007 19:27
By: rleishman
  How to decide on SGA sizing ???
By: girishta on Thu, 15 November 2007
1 2385 Thu, 15 November 2007 09:41
By: Michel Cadot
  Index
By: webadministrator on Thu, 15 November 2007
5 3827 Thu, 15 November 2007 07:35
By: Michel Cadot
  Urgent Please
By: balajisundar on Fri, 09 November 2007
10 3466 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 7401 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 2442 Wed, 14 November 2007 09:14
By: kesavansundaram
  Query problem
10.2
By: amit_p_dixit on Tue, 13 November 2007
6 2273 Wed, 14 November 2007 05:36
By: JRowbottom
  Pls. help Tune this query
Oracle 10g
By: hidnana on Mon, 12 November 2007
8 3456 Wed, 14 November 2007 01:23
By: rleishman
  Buffer Cache
Oracle 9.2.x.x, Unix
By: balajisundar on Tue, 13 November 2007
4 2470 Tue, 13 November 2007 09:50
By: balajisundar
  SQL Tunning
By: M.Shakeel Azeem on Mon, 12 November 2007
5 3206 Mon, 12 November 2007 20:23
By: rleishman
  BUFFER CACHE
By: kingo on Mon, 12 November 2007
1 2047 Mon, 12 November 2007 03:46
By: Michel Cadot
  truncate
oracle 7
By: dirish on Mon, 05 November 2007
8 4390 Mon, 12 November 2007 00:58
By: Michel Cadot
  Perfomance in Delete and Insert
By: mohseni on Sat, 10 November 2007
3 1929 Sat, 10 November 2007 09:23
By: Michel Cadot
  Process Threads
Oracl 9.2x, Unix
By: balajisundar on Thu, 08 November 2007
2 2583 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: Wed Nov 05 21:16:05 CST 2025