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

    Replies Views Last message
  query tuning using explain plan
oracle , linux
By: sheldon1982 on Wed, 02 April 2008
 4 3055 Wed, 02 April 2008 21:26
By: rleishman
  insert took a lnog time.
sun 10g
By: lioracle on Wed, 02 April 2008
 3 2227 Wed, 02 April 2008 21:21
By: rleishman
  Find a correct value for PGA_AGGREGATE_TARGET
Oracle 9i, AIX
By: agostino_neto on Wed, 02 April 2008
 1 3722 Wed, 02 April 2008 08:02
By: Michel Cadot
  Usage of Materialized view to improve performance
By: sandhyaa on Tue, 01 April 2008
 2 2439 Wed, 02 April 2008 07:36
By: gintsp
  How to re-write th eprocedure...?
oracle 9.0.1
By: gksenthilkumar on Tue, 01 April 2008
 5 2287 Tue, 01 April 2008 23:28
By: BlackSwan
  optimzier RULE
10, sun
By: lioracle on Mon, 31 March 2008
 6 3024 Tue, 01 April 2008 21:56
By: BlackSwan
  Bucketing Query Performance
By: verpies on Fri, 28 March 2008
 19 8608 Tue, 01 April 2008 17:34
By: rleishman
  Oracle execution plan help needed
Oracle 8i
By: gangulyz on Tue, 01 April 2008
 2 1896 Tue, 01 April 2008 07:22
By: gangulyz
  'EXISTS' vs 'IN'
By: vkrn on Tue, 01 April 2008
 1 1822 Tue, 01 April 2008 00:21
By: Michel Cadot
  SQL Query behaving weirdly in 10g
10g
By: hrsiddareddy on Fri, 28 March 2008
 4 2719 Mon, 31 March 2008 16:37
By: Kevin Meade
  db_cache_size
Oracle 10.2.3, SunOS sun11 5.9
By: lotusdeva on Fri, 28 March 2008
 6 14291 Mon, 31 March 2008 11:33
By: lotusdeva
  Statspack
oracle 9i
By: sudhir1582 on Mon, 31 March 2008
 4 2250 Mon, 31 March 2008 06:31
By: sudhir1582
  reg performance tuning concept
oracle 10g
By: ram anand on Mon, 31 March 2008
 3 2119 Mon, 31 March 2008 05:34
By: Michel Cadot
  performance problem with DATE field Comparison
Oracle 9i
By: me_arindam on Wed, 26 March 2008
 4 3174 Mon, 31 March 2008 02:23
By: me_arindam
  Creating Materialized View using Union All Operator
Windows, Oracle 9iR2
By: ajitpal.s on Sun, 30 March 2008
 4 5628 Sun, 30 March 2008 22:07
By: ajitpal.s
  bulkloading
oracle9i
By: hindolsaha on Fri, 28 March 2008
 1 2081 Fri, 28 March 2008 08:22
By: Frank Naude
  Query takes long time to execute first time
By: emilSverige on Thu, 20 March 2008
 9 4623 Thu, 27 March 2008 17:11
By: emilSverige
  How to do update statistics on oracle 10g database
10g
By: brandond on Thu, 27 March 2008
 3 7958 Thu, 27 March 2008 12:58
By: Michel Cadot
  CAN ANY ONE PROVIDE ME THE STATSPACK SCRIPTS
By: manoj12 on Thu, 27 March 2008
 4 2476 Thu, 27 March 2008 05:37
By: manoj12
  Check and telll whether the following configuration is correct or not
By: manoj12 on Mon, 24 March 2008
 10 3592 Thu, 27 March 2008 00:19
By: manoj12
  Summary table Update statement.
By: arksjd on Wed, 26 March 2008
 3 1745 Wed, 26 March 2008 21:00
By: rleishman
  Partitioning effect
By: hadinatayp on Wed, 26 March 2008
 4 2105 Wed, 26 March 2008 06:51
By: rleishman
  Usuage of hints.
By: vkrn on Tue, 25 March 2008
 2 2133 Tue, 25 March 2008 18:34
By: gintsp
  Oracle HASH GROUP BY & SORT GROUP BY performance
Oracle 10g
By: rkg_007 on Tue, 25 March 2008
 8 27832 Tue, 25 March 2008 18:32
By: gintsp
  altering rollback segment
oracle 9i
By: chriswitt on Tue, 25 March 2008
 5 2492 Tue, 25 March 2008 15:17
By: Michel Cadot
  usuage of DECODE
By: vkrn on Tue, 25 March 2008
 9 2892 Tue, 25 March 2008 09:01
By: vkrn
  Performance of a query
By: manoj12 on Tue, 25 March 2008
 1 1797 Tue, 25 March 2008 02:23
By: Mahesh Rajendran
  When I should increase the size of datafile,tablespace,redolog files as well as sort area size
Oracle 9i,Windows XP/2000
By: manoj12 on Tue, 18 March 2008
 4 2822 Mon, 24 March 2008 08:27
By: manoj12
  BAD performing query, OR Clause
Oracle 10g
By: stghag on Sat, 22 March 2008
 5 2574 Sun, 23 March 2008 07:10
By: michael_bialik
  ADDM Findings from OEM
10g Rel 2
By: azeem87 on Fri, 21 March 2008
 0 8815 Fri, 21 March 2008 10:52
By: azeem87
  Analytical Functions and Backward Index scans
By: verpies on Tue, 18 March 2008
 17 12953 Thu, 20 March 2008 16:54
By: coleing
  Efficient Data Management.
Solaris , 10.2g
By: Oraclist on Thu, 20 March 2008
 2 1917 Thu, 20 March 2008 07:43
By: rleishman
icon5.gif Selection of driving table
By: vkrn on Tue, 18 March 2008
 8 3290 Thu, 20 March 2008 05:25
By: vkrn
  About Oracle Database Link
Solaris , 10.2g
By: Oraclist on Thu, 20 March 2008
 7 2839 Thu, 20 March 2008 04:50
By: Michel Cadot
  How can we write this query in a better or more efficeint way?
oracle 10g
By: vijay.nimmakuri@gmail.com on Wed, 05 March 2008
 4 3304 Thu, 20 March 2008 04:47
By: Michel Cadot
  lockwait
By: sidd_411 on Thu, 20 March 2008
 2 2039 Thu, 20 March 2008 03:48
By: msmallya
  Can anybody explain this index
oracle 10g, AIX
By: cycloscott on Wed, 19 March 2008
 6 2885 Wed, 19 March 2008 17:23
By: cycloscott
  9i-Clearing cache and memory
oracle 9i, Aix
By: shlomi_bt on Mon, 17 March 2008
 3 2101 Wed, 19 March 2008 12:15
By: shlomi_bt
  PERFORMANCE OF A QUERY ;
By: sispk6 on Wed, 19 March 2008
 4 2304 Wed, 19 March 2008 09:29
By: ThomasG
  database configuration of SGA,shared pool size,redolog buffer and sort area size (merged)
By: manoj12 on Tue, 18 March 2008
 15 7516 Wed, 19 March 2008 06:56
By: manoj12
Goto Forum:
  
 [ Syndicate this forum (XML) ] [ RSS ]
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 11 16:48:42 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.