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 5892 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 2853 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 4331 Fri, 28 September 2007 11:23
By: BlackSwan
  Help: Identifying Problem in the query
By: kumarsz on Sun, 23 September 2007
20 4840 Thu, 27 September 2007 08:03
By: kumarsz
  multiple size of db_block
By: tanmoy1048 on Wed, 26 September 2007
12 3705 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 10929 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 2452 Wed, 26 September 2007 12:06
By: mson77
  Performance Tuning in SQL queries and PL/SQL
By: swapnajojo on Wed, 19 September 2007
7 2436 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 1543 Wed, 26 September 2007 06:21
By: Michel Cadot
  Library Cache Lock
By: fakru.y on Wed, 26 September 2007
1 2385 Wed, 26 September 2007 03:10
By: Michel Cadot
  Buffer Cache
By: tanmoy1048 on Wed, 26 September 2007
3 1613 Wed, 26 September 2007 01:23
By: Michel Cadot
  Adding columns vs Adding tables
By: rrvvg_1976 on Mon, 24 September 2007
7 2057 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 1912 Tue, 25 September 2007 06:18
By: Michel Cadot
  AWR REPORT
By: tanmoy1048 on Tue, 25 September 2007
4 5418 Tue, 25 September 2007 04:48
By: Michel Cadot
  I have one problem with snapshot date
By: trantuananh24hg on Mon, 24 September 2007
1 1294 Mon, 24 September 2007 20:58
By: mson77
  Index rebuild
By: tanmoy1048 on Sun, 23 September 2007
16 4816 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 1512 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 3287 Sun, 23 September 2007 10:49
By: mson77
  SQL Sharing Problem (STB_OBJECT_MISMATCH)
By: hongfei.wang on Fri, 21 September 2007
5 3318 Fri, 21 September 2007 13:10
By: BlackSwan
  0ra-1920
By: anamika_025 on Wed, 19 September 2007
3 1971 Fri, 21 September 2007 01:02
By: mson77
  About Bitmap Index
By: bagulia_pilla on Thu, 20 September 2007
5 1887 Thu, 20 September 2007 23:20
By: bagulia_pilla
  top query find through sqlplus ?
By: nomannishat on Tue, 18 September 2007
4 1709 Thu, 20 September 2007 22:00
By: mson77
  Tuning of query (Not DBA Level Tuning)
By: nawshot on Wed, 19 September 2007
4 2161 Wed, 19 September 2007 14:31
By: michael_bialik
  Heavy query with GL
By: tarmenel on Wed, 19 September 2007
1 2549 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 3268 Wed, 19 September 2007 01:22
By: Michel Cadot
  Help - Creating Stored Outlines
By: kumarsz on Thu, 13 September 2007
1 2685 Tue, 18 September 2007 08:46
By: michael_bialik
  outer join problem
By: Nusrat on Sun, 16 September 2007
9 2605 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 1317 Tue, 18 September 2007 06:12
By: Michel Cadot
  Processing lots of data
By: scottwmackey on Fri, 14 September 2007
5 1659 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 1556 Mon, 17 September 2007 05:48
By: JRowbottom
  Urgent help needed in tuning the query
By: grk28 on Thu, 13 September 2007
10 3195 Sun, 16 September 2007 23:10
By: rleishman
  statspack
By: balavignesh on Tue, 03 May 2005
12 11852 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 2150 Sat, 15 September 2007 12:22
By: kumarsz
  RMAN causing CPU boottleneck
By: sreehari on Fri, 14 September 2007
2 2994 Fri, 14 September 2007 11:22
By: srinivnp
  problem in insert
By: anamika_025 on Wed, 12 September 2007
10 1970 Fri, 14 September 2007 05:01
By: Michel Cadot
  AWR report
By: tanmoy1048 on Thu, 13 September 2007
1 1234 Thu, 13 September 2007 05:36
By: ebrian
  TIMED_STATISTICS parameter
By: tanmoy1048 on Thu, 13 September 2007
2 1569 Thu, 13 September 2007 04:57
By: tanmoy1048
  How to rebuild indexes
By: coolboy2005in on Wed, 12 September 2007
1 1252 Thu, 13 September 2007 00:03
By: Michel Cadot
  Module in Statspack Report
By: kumarsz on Wed, 12 September 2007
3 1731 Wed, 12 September 2007 13:54
By: Michel Cadot
  lots of waits sql*net
By: thorin666 on Wed, 12 September 2007
2 1980 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: Wed Jun 26 13:49:37 CDT 2024