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 2732 Mon, 01 October 2007 04:19
By: Oyunbold
  What is the number of cost?
By: trantuananh24hg on Mon, 01 October 2007
5 1955 Mon, 01 October 2007 03:34
By: Michel Cadot
  Slow update with Bulk collect and Forall
By: aliceg on Mon, 24 September 2007
8 6344 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 3271 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 4565 Fri, 28 September 2007 11:23
By: BlackSwan
  Help: Identifying Problem in the query
By: kumarsz on Sun, 23 September 2007
20 5653 Thu, 27 September 2007 08:03
By: kumarsz
  multiple size of db_block
By: tanmoy1048 on Wed, 26 September 2007
12 4817 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 11579 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 2883 Wed, 26 September 2007 12:06
By: mson77
  Performance Tuning in SQL queries and PL/SQL
By: swapnajojo on Wed, 19 September 2007
7 3495 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 1726 Wed, 26 September 2007 06:21
By: Michel Cadot
  Library Cache Lock
By: fakru.y on Wed, 26 September 2007
1 2672 Wed, 26 September 2007 03:10
By: Michel Cadot
  Buffer Cache
By: tanmoy1048 on Wed, 26 September 2007
3 1974 Wed, 26 September 2007 01:23
By: Michel Cadot
  Adding columns vs Adding tables
By: rrvvg_1976 on Mon, 24 September 2007
7 2649 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 2231 Tue, 25 September 2007 06:18
By: Michel Cadot
  AWR REPORT
By: tanmoy1048 on Tue, 25 September 2007
4 6072 Tue, 25 September 2007 04:48
By: Michel Cadot
  I have one problem with snapshot date
By: trantuananh24hg on Mon, 24 September 2007
1 1494 Mon, 24 September 2007 20:58
By: mson77
  Index rebuild
By: tanmoy1048 on Sun, 23 September 2007
16 5937 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 1884 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 3554 Sun, 23 September 2007 10:49
By: mson77
  SQL Sharing Problem (STB_OBJECT_MISMATCH)
By: hongfei.wang on Fri, 21 September 2007
5 4050 Fri, 21 September 2007 13:10
By: BlackSwan
  0ra-1920
By: anamika_025 on Wed, 19 September 2007
3 2384 Fri, 21 September 2007 01:02
By: mson77
  About Bitmap Index
By: bagulia_pilla on Thu, 20 September 2007
5 2708 Thu, 20 September 2007 23:20
By: bagulia_pilla
  top query find through sqlplus ?
By: nomannishat on Tue, 18 September 2007
4 2135 Thu, 20 September 2007 22:00
By: mson77
  Tuning of query (Not DBA Level Tuning)
By: nawshot on Wed, 19 September 2007
4 2387 Wed, 19 September 2007 14:31
By: michael_bialik
  Heavy query with GL
By: tarmenel on Wed, 19 September 2007
1 2771 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 3449 Wed, 19 September 2007 01:22
By: Michel Cadot
  Help - Creating Stored Outlines
By: kumarsz on Thu, 13 September 2007
1 2861 Tue, 18 September 2007 08:46
By: michael_bialik
  outer join problem
By: Nusrat on Sun, 16 September 2007
9 3226 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 1594 Tue, 18 September 2007 06:12
By: Michel Cadot
  Processing lots of data
By: scottwmackey on Fri, 14 September 2007
5 1933 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 1767 Mon, 17 September 2007 05:48
By: JRowbottom
  Urgent help needed in tuning the query
By: grk28 on Thu, 13 September 2007
10 3504 Sun, 16 September 2007 23:10
By: rleishman
  statspack
By: balavignesh on Tue, 03 May 2005
12 12455 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 2512 Sat, 15 September 2007 12:22
By: kumarsz
  RMAN causing CPU boottleneck
By: sreehari on Fri, 14 September 2007
2 3386 Fri, 14 September 2007 11:22
By: srinivnp
  problem in insert
By: anamika_025 on Wed, 12 September 2007
10 2370 Fri, 14 September 2007 05:01
By: Michel Cadot
  AWR report
By: tanmoy1048 on Thu, 13 September 2007
1 1518 Thu, 13 September 2007 05:36
By: ebrian
  TIMED_STATISTICS parameter
By: tanmoy1048 on Thu, 13 September 2007
2 1998 Thu, 13 September 2007 04:57
By: tanmoy1048
  How to rebuild indexes
By: coolboy2005in on Wed, 12 September 2007
1 1583 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 Jan 08 22:54:16 CST 2025