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

    Replies Views Last message
  need to know about shared pool sizing
8.1.7,win 2003 server
By: ultgnp on Mon, 05 July 2010
1 1508 Mon, 05 July 2010 01:32
By: BlackSwan
  Logwriter processes
Hp Unix,11.3
By: sekar52 on Fri, 02 July 2010
3 2370 Fri, 02 July 2010 04:32
By: Michel Cadot
  parition of table
10.2.0.4
By: ankush_chawla on Mon, 28 June 2010
2 1594 Mon, 28 June 2010 08:09
By: Michel Cadot
  select partition table with non partition key condition
By: ekopur on Sat, 26 June 2010
3 2615 Sat, 26 June 2010 09:20
By: Michel Cadot
  Help proving a database is slow
10.2 / Solaris
By: rleishman on Tue, 01 June 2010
16 7666 Sat, 26 June 2010 05:13
By: rleishman
  Pin Sql query in shared pool
By: paradoxkhan on Fri, 25 June 2010
3 3777 Fri, 25 June 2010 08:02
By: cookiemonster
  need help tuning this query
8.1.6, win2000 server
By: ultgnp on Sun, 20 June 2010
17 2939 Wed, 23 June 2010 08:36
By: ultgnp
  How to tune order by clause without changing sort area
Oracle 9i,9.2.0.6.0,Windows XP
By: rajatratewal on Thu, 01 May 2008
10 9800 Wed, 23 June 2010 03:36
By: Kevin Meade
  My indexes was not active
Oracle 10g, Windows 32bit
By: trantuananh24hg on Mon, 21 June 2010
9 2208 Wed, 23 June 2010 02:54
By: Roachcoach
  to reduce the disk reads
By: akilabaskaran on Tue, 22 June 2010
14 3185 Tue, 22 June 2010 06:28
By: akilabaskaran
  reducing the parse-execution ration
By: akilabaskaran on Tue, 15 June 2010
12 2355 Fri, 18 June 2010 03:59
By: cookiemonster
  database fragmentation
Oracla 9i
By: Nau on Wed, 16 June 2010
2 1420 Thu, 17 June 2010 12:42
By: Kevin Meade
  Tuning PL/SQLApplications
Oracle 10g
By: rmaheshbabu on Thu, 17 June 2010
2 1508 Thu, 17 June 2010 00:49
By: rmaheshbabu
  shared pool
oracle 10.2.0.4 2 node rac,aix 6.3
By: ranganathan1984 on Mon, 14 June 2010
9 5593 Wed, 16 June 2010 00:54
By: michael_bialik
  TKPROF Output Understanding
Oracle 10g,10.2.0.3.0,AIX
By: rajatratewal on Wed, 09 June 2010
14 6555 Wed, 16 June 2010 00:44
By: michael_bialik
  Avoiding bind variable from a sql in java code
oracle 10.2.0.4 on Solaris 10
By: orausern on Tue, 15 June 2010
9 3045 Tue, 15 June 2010 13:21
By: orausern
  SGA "usage"
By: firefly on Wed, 26 May 2010
8 6375 Mon, 14 June 2010 17:17
By: mikerault
  Alternative to REPLACE function?
10gr2
By: Kevin Meade on Sat, 12 June 2010
2 1892 Mon, 14 June 2010 11:34
By: coleing
  Very first step
Oracle SQL Tuning
By: Amitabhguha on Mon, 14 June 2010
3 1561 Mon, 14 June 2010 05:36
By: Michel Cadot
  Changing execution plans
Oracle 10.2.0.4 RAC
By: NandKumar on Sat, 12 June 2010
3 2330 Sat, 12 June 2010 13:55
By: BlackSwan
  Merge Performance (wide open question here)
10g release (4?) and 11g release 1
By: Kevin Meade on Wed, 09 June 2010
6 3730 Sat, 12 June 2010 08:48
By: Kevin Meade
  tkprof question
10gr2
By: faq_dba on Fri, 11 June 2010
5 2050 Fri, 11 June 2010 22:48
By: BlackSwan
  Rule based tips still valid in 11g
By: ind9 on Fri, 11 June 2010
1 1316 Fri, 11 June 2010 07:38
By: cookiemonster
  Oracle Internal Query
11.1.0.7.0
By: jarcher on Fri, 11 June 2010
2 3682 Fri, 11 June 2010 03:10
By: Frank Naude
  Does high volume of data can change plan
Oracle 10.2.0.3
By: Its_me_ved on Fri, 04 June 2010
6 2248 Fri, 04 June 2010 09:17
By: Its_me_ved
  Why Elapsed Time Changed while execution plan and stats remains the same?
Oracle 9.2.0.6.0 on HP-UX
By: chetanaZ on Fri, 04 June 2010
10 2583 Fri, 04 June 2010 09:15
By: chetanaZ
  awr report for specific date
By: Riyasbasha on Fri, 04 June 2010
2 3320 Fri, 04 June 2010 01:32
By: Riyasbasha
  oracleorcl (LOCAL=NO) cpu 100%
Oracle10.1.0.2.0, Rhel4
By: kumarrajnishgupta on Tue, 01 June 2010
9 11444 Tue, 01 June 2010 23:19
By: Michel Cadot
  help to tune this query ot help to re write in onther way
oracle ,11.1,xp
By: krajasekhar.v on Mon, 31 May 2010
4 2342 Mon, 31 May 2010 07:22
By: Alessandro Rossi
  How to resolve query tuning?
By: elangoealngos on Sun, 30 May 2010
1 1604 Sun, 30 May 2010 02:40
By: Michel Cadot
  How to check the query performance
By: Riyasbasha on Sat, 29 May 2010
2 1651 Sat, 29 May 2010 03:42
By: Michel Cadot
  P&T Guide Question [Restructuring SQL Statements]
10g Release 2 (10.2) - Documention Related
By: Roachcoach on Fri, 28 May 2010
2 2153 Fri, 28 May 2010 05:30
By: Roachcoach
  Need help with tuning a query
8.0.6, win 2000 server
By: ateeqrahman786 on Sun, 23 May 2010
5 1798 Wed, 26 May 2010 06:07
By: michael_bialik
  V$SESSION_LONGOPS - Looking for more than last 16 ops
10.2.0.4.0
By: rleishman on Tue, 25 May 2010
3 5127 Wed, 26 May 2010 04:46
By: Michel Cadot
  Different EXPLAIN PLAN Before and after execution
Oracle 10g
By: prateekgupta1210 on Tue, 25 May 2010
7 2981 Wed, 26 May 2010 03:33
By: prateekgupta1210
  AWR report evaluation
oracle10g
By: shrinika on Thu, 20 May 2010
5 3139 Sun, 23 May 2010 00:00
By: ramoradba
  Optimize sql
Oracle 10.2.0.3
By: Its_me_ved on Wed, 19 May 2010
19 4685 Sat, 22 May 2010 03:41
By: Alessandro Rossi
  explain plan
11g
By: orafacjublu on Tue, 18 May 2010
6 2057 Tue, 18 May 2010 08:59
By: cookiemonster
  need help with rewriting the query
8.0.6
By: ateeqrahman786 on Sat, 15 May 2010
10 2582 Mon, 17 May 2010 02:50
By: ateeqrahman786
  need help to speed up data loading in form
8.0.6, forms 4.5, win 2003 server
By: ateeqrahman786 on Sat, 15 May 2010
1 1364 Sat, 15 May 2010 07:48
By: rleishman
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: Sun Jun 23 11:41:22 CDT 2024