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 2675 Mon, 01 October 2007 04:19
By: Oyunbold
  What is the number of cost?
By: trantuananh24hg on Mon, 01 October 2007
5 1928 Mon, 01 October 2007 03:34
By: Michel Cadot
  Slow update with Bulk collect and Forall
By: aliceg on Mon, 24 September 2007
8 6263 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 3235 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 4536 Fri, 28 September 2007 11:23
By: BlackSwan
  Help: Identifying Problem in the query
By: kumarsz on Sun, 23 September 2007
20 5570 Thu, 27 September 2007 08:03
By: kumarsz
  multiple size of db_block
By: tanmoy1048 on Wed, 26 September 2007
12 4781 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 11491 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 2848 Wed, 26 September 2007 12:06
By: mson77
  Performance Tuning in SQL queries and PL/SQL
By: swapnajojo on Wed, 19 September 2007
7 3464 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 1712 Wed, 26 September 2007 06:21
By: Michel Cadot
  Library Cache Lock
By: fakru.y on Wed, 26 September 2007
1 2658 Wed, 26 September 2007 03:10
By: Michel Cadot
  Buffer Cache
By: tanmoy1048 on Wed, 26 September 2007
3 1959 Wed, 26 September 2007 01:23
By: Michel Cadot
  Adding columns vs Adding tables
By: rrvvg_1976 on Mon, 24 September 2007
7 2621 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 2219 Tue, 25 September 2007 06:18
By: Michel Cadot
  AWR REPORT
By: tanmoy1048 on Tue, 25 September 2007
4 6050 Tue, 25 September 2007 04:48
By: Michel Cadot
  I have one problem with snapshot date
By: trantuananh24hg on Mon, 24 September 2007
1 1478 Mon, 24 September 2007 20:58
By: mson77
  Index rebuild
By: tanmoy1048 on Sun, 23 September 2007
16 5897 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 1853 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 3536 Sun, 23 September 2007 10:49
By: mson77
  SQL Sharing Problem (STB_OBJECT_MISMATCH)
By: hongfei.wang on Fri, 21 September 2007
5 3997 Fri, 21 September 2007 13:10
By: BlackSwan
  0ra-1920
By: anamika_025 on Wed, 19 September 2007
3 2366 Fri, 21 September 2007 01:02
By: mson77
  About Bitmap Index
By: bagulia_pilla on Thu, 20 September 2007
5 2693 Thu, 20 September 2007 23:20
By: bagulia_pilla
  top query find through sqlplus ?
By: nomannishat on Tue, 18 September 2007
4 2118 Thu, 20 September 2007 22:00
By: mson77
  Tuning of query (Not DBA Level Tuning)
By: nawshot on Wed, 19 September 2007
4 2361 Wed, 19 September 2007 14:31
By: michael_bialik
  Heavy query with GL
By: tarmenel on Wed, 19 September 2007
1 2742 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 3428 Wed, 19 September 2007 01:22
By: Michel Cadot
  Help - Creating Stored Outlines
By: kumarsz on Thu, 13 September 2007
1 2841 Tue, 18 September 2007 08:46
By: michael_bialik
  outer join problem
By: Nusrat on Sun, 16 September 2007
9 3204 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 1580 Tue, 18 September 2007 06:12
By: Michel Cadot
  Processing lots of data
By: scottwmackey on Fri, 14 September 2007
5 1921 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 1748 Mon, 17 September 2007 05:48
By: JRowbottom
  Urgent help needed in tuning the query
By: grk28 on Thu, 13 September 2007
10 3478 Sun, 16 September 2007 23:10
By: rleishman
  statspack
By: balavignesh on Tue, 03 May 2005
12 12420 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 2490 Sat, 15 September 2007 12:22
By: kumarsz
  RMAN causing CPU boottleneck
By: sreehari on Fri, 14 September 2007
2 3362 Fri, 14 September 2007 11:22
By: srinivnp
  problem in insert
By: anamika_025 on Wed, 12 September 2007
10 2336 Fri, 14 September 2007 05:01
By: Michel Cadot
  AWR report
By: tanmoy1048 on Thu, 13 September 2007
1 1508 Thu, 13 September 2007 05:36
By: ebrian
  TIMED_STATISTICS parameter
By: tanmoy1048 on Thu, 13 September 2007
2 1977 Thu, 13 September 2007 04:57
By: tanmoy1048
  How to rebuild indexes
By: coolboy2005in on Wed, 12 September 2007
1 1563 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: Mon Nov 04 15:17:22 CST 2024