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 3147 Wed, 02 April 2008 21:26
By: rleishman
  insert took a lnog time.
sun 10g
By: lioracle on Wed, 02 April 2008
 3 2329 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 3788 Wed, 02 April 2008 08:02
By: Michel Cadot
  Usage of Materialized view to improve performance
By: sandhyaa on Tue, 01 April 2008
 2 2510 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 2404 Tue, 01 April 2008 23:28
By: BlackSwan
  optimzier RULE
10, sun
By: lioracle on Mon, 31 March 2008
 6 3185 Tue, 01 April 2008 21:56
By: BlackSwan
  Bucketing Query Performance
By: verpies on Fri, 28 March 2008
 19 8877 Tue, 01 April 2008 17:34
By: rleishman
  Oracle execution plan help needed
Oracle 8i
By: gangulyz on Tue, 01 April 2008
 2 1964 Tue, 01 April 2008 07:22
By: gangulyz
  'EXISTS' vs 'IN'
By: vkrn on Tue, 01 April 2008
 1 1889 Tue, 01 April 2008 00:21
By: Michel Cadot
  SQL Query behaving weirdly in 10g
10g
By: hrsiddareddy on Fri, 28 March 2008
 4 2811 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 14424 Mon, 31 March 2008 11:33
By: lotusdeva
  Statspack
oracle 9i
By: sudhir1582 on Mon, 31 March 2008
 4 2357 Mon, 31 March 2008 06:31
By: sudhir1582
  reg performance tuning concept
oracle 10g
By: ram anand on Mon, 31 March 2008
 3 2208 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 3292 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 5744 Sun, 30 March 2008 22:07
By: ajitpal.s
  bulkloading
oracle9i
By: hindolsaha on Fri, 28 March 2008
 1 2145 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 4790 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 8085 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 2548 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 3728 Thu, 27 March 2008 00:19
By: manoj12
  Summary table Update statement.
By: arksjd on Wed, 26 March 2008
 3 1834 Wed, 26 March 2008 21:00
By: rleishman
  Partitioning effect
By: hadinatayp on Wed, 26 March 2008
 4 2172 Wed, 26 March 2008 06:51
By: rleishman
  Usuage of hints.
By: vkrn on Tue, 25 March 2008
 2 2211 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 27949 Tue, 25 March 2008 18:32
By: gintsp
  altering rollback segment
oracle 9i
By: chriswitt on Tue, 25 March 2008
 5 2567 Tue, 25 March 2008 15:17
By: Michel Cadot
  usuage of DECODE
By: vkrn on Tue, 25 March 2008
 9 3002 Tue, 25 March 2008 09:01
By: vkrn
  Performance of a query
By: manoj12 on Tue, 25 March 2008
 1 1862 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 2909 Mon, 24 March 2008 08:27
By: manoj12
  BAD performing query, OR Clause
Oracle 10g
By: stghag on Sat, 22 March 2008
 5 2693 Sun, 23 March 2008 07:10
By: michael_bialik
  ADDM Findings from OEM
10g Rel 2
By: azeem87 on Fri, 21 March 2008
 0 8873 Fri, 21 March 2008 10:52
By: azeem87
  Analytical Functions and Backward Index scans
By: verpies on Tue, 18 March 2008
 17 13248 Thu, 20 March 2008 16:54
By: coleing
  Efficient Data Management.
Solaris , 10.2g
By: Oraclist on Thu, 20 March 2008
 2 1992 Thu, 20 March 2008 07:43
By: rleishman
icon5.gif Selection of driving table
By: vkrn on Tue, 18 March 2008
 8 3418 Thu, 20 March 2008 05:25
By: vkrn
  About Oracle Database Link
Solaris , 10.2g
By: Oraclist on Thu, 20 March 2008
 7 2989 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 3395 Thu, 20 March 2008 04:47
By: Michel Cadot
  lockwait
By: sidd_411 on Thu, 20 March 2008
 2 2083 Thu, 20 March 2008 03:48
By: msmallya
  Can anybody explain this index
oracle 10g, AIX
By: cycloscott on Wed, 19 March 2008
 6 2984 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 2180 Wed, 19 March 2008 12:15
By: shlomi_bt
  PERFORMANCE OF A QUERY ;
By: sispk6 on Wed, 19 March 2008
 4 2390 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 7715 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: Tue Nov 04 20:05:35 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.