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

    Replies Views Last message
  How to Best Performance Param of Oracle in Windows
By: Oyunbold on Thu, 27 September 2007
11 2818 Mon, 01 October 2007 04:19
By: Oyunbold
  What is the number of cost?
By: trantuananh24hg on Mon, 01 October 2007
5 1969 Mon, 01 October 2007 03:34
By: Michel Cadot
  Slow update with Bulk collect and Forall
By: aliceg on Mon, 24 September 2007
8 6363 Fri, 28 September 2007 18:31
By: aliceg
  Performance of Oracle 9i in Unix machine (merged 3)
By: oraprobs on Thu, 27 September 2007
18 3277 Fri, 28 September 2007 14:31
By: BlackSwan
  ORA-12560:TNS protocol adapter Error while upgrading oracle 8i to Oracle 9i
By: oraprobs on Fri, 28 September 2007
3 4570 Fri, 28 September 2007 11:23
By: BlackSwan
  Help: Identifying Problem in the query
By: kumarsz on Sun, 23 September 2007
20 5709 Thu, 27 September 2007 08:03
By: kumarsz
  multiple size of db_block
By: tanmoy1048 on Wed, 26 September 2007
12 4832 Thu, 27 September 2007 04:04
By: Michel Cadot
icon5.gif slow perf with Bulk collect and FORALL
By: aliceg on Wed, 11 July 2007
21 11595 Wed, 26 September 2007 21:37
By: rleishman
  Help :Getting Inner query executions from v$sql_plan_statistics_all
By: kumarsz on Wed, 26 September 2007
8 2920 Wed, 26 September 2007 12:06
By: mson77
  Performance Tuning in SQL queries and PL/SQL
By: swapnajojo on Wed, 19 September 2007
7 3517 Wed, 26 September 2007 11:34
By: psiva_oracle
  What is the different between the varchar2 and nvarchar2?
By: psiva_oracle on Wed, 26 September 2007
1 1731 Wed, 26 September 2007 06:21
By: Michel Cadot
  Library Cache Lock
By: fakru.y on Wed, 26 September 2007
1 2688 Wed, 26 September 2007 03:10
By: Michel Cadot
  Buffer Cache
By: tanmoy1048 on Wed, 26 September 2007
3 1986 Wed, 26 September 2007 01:23
By: Michel Cadot
  Adding columns vs Adding tables
By: rrvvg_1976 on Mon, 24 September 2007
7 2662 Tue, 25 September 2007 17:32
By: pablolee
  Increase the redo log buffer: a couple of questions
By: Malakay79 on Tue, 25 September 2007
1 2236 Tue, 25 September 2007 06:18
By: Michel Cadot
  AWR REPORT
By: tanmoy1048 on Tue, 25 September 2007
4 6100 Tue, 25 September 2007 04:48
By: Michel Cadot
  I have one problem with snapshot date
By: trantuananh24hg on Mon, 24 September 2007
1 1498 Mon, 24 September 2007 20:58
By: mson77
  Index rebuild
By: tanmoy1048 on Sun, 23 September 2007
16 5947 Mon, 24 September 2007 15:35
By: mson77
  how to find code causing redo to generate
By: vikeshcool@hotmail.com on Fri, 21 September 2007
3 1893 Mon, 24 September 2007 05:56
By: Michel Cadot
  Variance in -Row Source Generation, Explain Plan and statspack
By: kumarsz on Sat, 22 September 2007
1 3562 Sun, 23 September 2007 10:49
By: mson77
  SQL Sharing Problem (STB_OBJECT_MISMATCH)
By: hongfei.wang on Fri, 21 September 2007
5 4074 Fri, 21 September 2007 13:10
By: BlackSwan
  0ra-1920
By: anamika_025 on Wed, 19 September 2007
3 2391 Fri, 21 September 2007 01:02
By: mson77
  About Bitmap Index
By: bagulia_pilla on Thu, 20 September 2007
5 2717 Thu, 20 September 2007 23:20
By: bagulia_pilla
  top query find through sqlplus ?
By: nomannishat on Tue, 18 September 2007
4 2158 Thu, 20 September 2007 22:00
By: mson77
  Tuning of query (Not DBA Level Tuning)
By: nawshot on Wed, 19 September 2007
4 2420 Wed, 19 September 2007 14:31
By: michael_bialik
  Heavy query with GL
By: tarmenel on Wed, 19 September 2007
1 2776 Wed, 19 September 2007 13:55
By: michael_bialik
  Query Tuning Problem (tkprof o/p,query & explain plan attached)
By: dksampat on Tue, 18 September 2007
4 3452 Wed, 19 September 2007 01:22
By: Michel Cadot
  Help - Creating Stored Outlines
By: kumarsz on Thu, 13 September 2007
1 2869 Tue, 18 September 2007 08:46
By: michael_bialik
  outer join problem
By: Nusrat on Sun, 16 September 2007
9 3235 Tue, 18 September 2007 06:34
By: flyboy
icon14.gif Sql taking 2min with order by clause
By: rc_ashish on Tue, 18 September 2007
1 1597 Tue, 18 September 2007 06:12
By: Michel Cadot
  Processing lots of data
By: scottwmackey on Fri, 14 September 2007
5 1946 Mon, 17 September 2007 12:56
By: scottwmackey
  Help - Will Reducing cardinality using histogram make query run faster?
By: kumarsz on Wed, 12 September 2007
4 1773 Mon, 17 September 2007 05:48
By: JRowbottom
  Urgent help needed in tuning the query
By: grk28 on Thu, 13 September 2007
10 3515 Sun, 16 September 2007 23:10
By: rleishman
  statspack
By: balavignesh on Tue, 03 May 2005
12 12464 Sat, 15 September 2007 17:33
By: mson77
  Finding Status Progress of Query with Single Block I/O
By: kumarsz on Sat, 15 September 2007
9 2537 Sat, 15 September 2007 12:22
By: kumarsz
  RMAN causing CPU boottleneck
By: sreehari on Fri, 14 September 2007
2 3411 Fri, 14 September 2007 11:22
By: srinivnp
  problem in insert
By: anamika_025 on Wed, 12 September 2007
10 2402 Fri, 14 September 2007 05:01
By: Michel Cadot
  AWR report
By: tanmoy1048 on Thu, 13 September 2007
1 1524 Thu, 13 September 2007 05:36
By: ebrian
  TIMED_STATISTICS parameter
By: tanmoy1048 on Thu, 13 September 2007
2 2014 Thu, 13 September 2007 04:57
By: tanmoy1048
  How to rebuild indexes
By: coolboy2005in on Wed, 12 September 2007
1 1599 Thu, 13 September 2007 00:03
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: Wed Feb 12 20:22:40 CST 2025