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

    Replies Views Last message
  Slow update with Bulk collect and Forall
By: aliceg on Mon, 24 September 2007
8 5779 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 2806 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 4277 Fri, 28 September 2007 11:23
By: BlackSwan
  Help: Identifying Problem in the query
By: kumarsz on Sun, 23 September 2007
20 4768 Thu, 27 September 2007 08:03
By: kumarsz
  multiple size of db_block
By: tanmoy1048 on Wed, 26 September 2007
12 3652 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 10862 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 2404 Wed, 26 September 2007 12:06
By: mson77
  Performance Tuning in SQL queries and PL/SQL
By: swapnajojo on Wed, 19 September 2007
7 2361 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 1490 Wed, 26 September 2007 06:21
By: Michel Cadot
  Library Cache Lock
By: fakru.y on Wed, 26 September 2007
1 2339 Wed, 26 September 2007 03:10
By: Michel Cadot
  Buffer Cache
By: tanmoy1048 on Wed, 26 September 2007
3 1567 Wed, 26 September 2007 01:23
By: Michel Cadot
  Adding columns vs Adding tables
By: rrvvg_1976 on Mon, 24 September 2007
7 2015 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 1864 Tue, 25 September 2007 06:18
By: Michel Cadot
  AWR REPORT
By: tanmoy1048 on Tue, 25 September 2007
4 5380 Tue, 25 September 2007 04:48
By: Michel Cadot
  I have one problem with snapshot date
By: trantuananh24hg on Mon, 24 September 2007
1 1247 Mon, 24 September 2007 20:58
By: mson77
  Index rebuild
By: tanmoy1048 on Sun, 23 September 2007
16 4759 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 1468 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 3232 Sun, 23 September 2007 10:49
By: mson77
  SQL Sharing Problem (STB_OBJECT_MISMATCH)
By: hongfei.wang on Fri, 21 September 2007
5 3270 Fri, 21 September 2007 13:10
By: BlackSwan
  0ra-1920
By: anamika_025 on Wed, 19 September 2007
3 1926 Fri, 21 September 2007 01:02
By: mson77
  About Bitmap Index
By: bagulia_pilla on Thu, 20 September 2007
5 1832 Thu, 20 September 2007 23:20
By: bagulia_pilla
  top query find through sqlplus ?
By: nomannishat on Tue, 18 September 2007
4 1662 Thu, 20 September 2007 22:00
By: mson77
  Tuning of query (Not DBA Level Tuning)
By: nawshot on Wed, 19 September 2007
4 2113 Wed, 19 September 2007 14:31
By: michael_bialik
  Heavy query with GL
By: tarmenel on Wed, 19 September 2007
1 2501 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 3221 Wed, 19 September 2007 01:22
By: Michel Cadot
  Help - Creating Stored Outlines
By: kumarsz on Thu, 13 September 2007
1 2637 Tue, 18 September 2007 08:46
By: michael_bialik
  outer join problem
By: Nusrat on Sun, 16 September 2007
9 2560 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 1273 Tue, 18 September 2007 06:12
By: Michel Cadot
  Processing lots of data
By: scottwmackey on Fri, 14 September 2007
5 1615 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 1505 Mon, 17 September 2007 05:48
By: JRowbottom
  Urgent help needed in tuning the query
By: grk28 on Thu, 13 September 2007
10 3147 Sun, 16 September 2007 23:10
By: rleishman
  statspack
By: balavignesh on Tue, 03 May 2005
12 11804 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 2103 Sat, 15 September 2007 12:22
By: kumarsz
  RMAN causing CPU boottleneck
By: sreehari on Fri, 14 September 2007
2 2896 Fri, 14 September 2007 11:22
By: srinivnp
  problem in insert
By: anamika_025 on Wed, 12 September 2007
10 1917 Fri, 14 September 2007 05:01
By: Michel Cadot
  AWR report
By: tanmoy1048 on Thu, 13 September 2007
1 1192 Thu, 13 September 2007 05:36
By: ebrian
  TIMED_STATISTICS parameter
By: tanmoy1048 on Thu, 13 September 2007
2 1527 Thu, 13 September 2007 04:57
By: tanmoy1048
  How to rebuild indexes
By: coolboy2005in on Wed, 12 September 2007
1 1205 Thu, 13 September 2007 00:03
By: Michel Cadot
  Module in Statspack Report
By: kumarsz on Wed, 12 September 2007
3 1685 Wed, 12 September 2007 13:54
By: Michel Cadot
  lots of waits sql*net
By: thorin666 on Wed, 12 September 2007
2 1932 Wed, 12 September 2007 12:04
By: thorin666
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: Thu May 16 01:00:05 CDT 2024