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

    Replies Views Last message
  query issue
oracle 10g
By: prashant_ora on Wed, 02 March 2011
24 3826 Thu, 10 March 2011 21:15
By: Flyby
  prev_hash_value not changing in v$session
Oracle 10.2.0.4.0 on RHEL
By: OraKaran on Thu, 10 March 2011
6 4298 Thu, 10 March 2011 09:04
By: OraKaran
  Slow Performance
Oracle 11g Windows2000 Server
By: IMGS_Oracle on Fri, 18 September 2009
7 14317 Thu, 10 March 2011 07:57
By: martateixeira
  Query tuning
By: preethavinay on Mon, 21 February 2011
7 3317 Thu, 10 March 2011 07:36
By: marcodba
  Stored Procedure is taking too long time to Execute. (2 Merged)
Oracle 11.2
By: nanuvamsi on Fri, 04 March 2011
6 6122 Wed, 09 March 2011 12:36
By: BlackSwan
  SQL Tuning
Oracle 10.2.0.4
By: sathik on Tue, 22 February 2011
12 4884 Tue, 08 March 2011 07:43
By: marcodba
  inserting data using FOR ALL
9i/10g
By: ashish_sun123 on Sun, 06 March 2011
3 3675 Sun, 06 March 2011 17:35
By: Barbara Boehmer
  performance tuning
oracle 10g
By: manidotkandan on Thu, 03 March 2011
7 3862 Fri, 04 March 2011 03:43
By: cookiemonster
  Tunning the query and 4000-5000 parameter in IN clause
By: forroughuse on Wed, 02 March 2011
12 4300 Thu, 03 March 2011 12:12
By: Littlefoot
  Collecting stats
oracle 10.2.0.1.0 - windows XP
By: muktha_22 on Thu, 03 March 2011
1 2032 Thu, 03 March 2011 04:14
By: Michel Cadot
  Dynamic SQL performance
Oracle 10G
By: uicmxz on Mon, 28 February 2011
1 2441 Mon, 28 February 2011 17:19
By: BlackSwan
  faster processing of records needed: performance isue
oracle 9i/10g/11g
By: ashish_sun123 on Sat, 26 February 2011
2 2166 Mon, 28 February 2011 08:01
By: michael_bialik
icon4.gif Wrong REDO log file location
Oracle 10G, Solaris 10
By: Tlg13team on Fri, 25 February 2011
4 4103 Fri, 25 February 2011 20:43
By: wkk1020
  help to wrire the procedure
oracle,10g,unix
By: vickey_sagar1 on Fri, 25 February 2011
2 1916 Fri, 25 February 2011 15:10
By: cookiemonster
  performance tuning
general
By: goldenshot2727 on Thu, 22 April 2010
4 2717 Fri, 25 February 2011 07:31
By: samosimo
  Cursor_sharing setting in OLTP environment
Oracle 9i R2, 10g R2
By: OraKaran on Tue, 22 February 2011
11 4911 Wed, 23 February 2011 08:13
By: OraKaran
  Identify blocking sessions
11.1.0.7, Standard Edition
By: John Watson on Mon, 21 February 2011
4 4663 Tue, 22 February 2011 03:49
By: John Watson
  Slow Sql query
Oracle 10.2.0.3
By: Its_me_ved on Thu, 17 February 2011
8 5038 Sun, 20 February 2011 06:00
By: Its_me_ved
  full table scan
10.2.0.4
By: sathik123 on Sat, 19 February 2011
2 2146 Sun, 20 February 2011 00:26
By: Michel Cadot
icon5.gif Performance tuning of PL/SQL Procedure
Oracle 10.2.0.5
By: Santrupta on Sun, 13 February 2011
10 4399 Thu, 17 February 2011 09:26
By: cookiemonster
  Performance issue in jsp application
Oracle 10.2.0.3,jsp
By: Its_me_ved on Wed, 16 February 2011
2 2190 Wed, 16 February 2011 05:52
By: rleishman
  Bulk Update
Oracle 11g
By: rcd70 on Tue, 15 February 2011
1 2615 Tue, 15 February 2011 18:54
By: BlackSwan
icon7.gif Optimal REDO log file size
Oracle 10G, Solaris 10
By: Tlg13team on Thu, 10 February 2011
9 13155 Mon, 14 February 2011 03:44
By: Tlg13team
  Performance tuning
oracle 9i/10g/11g
By: ashish_sun123 on Sun, 13 February 2011
6 1910 Sun, 13 February 2011 23:32
By: Michel Cadot
  SELECT query
Oracle,11.1.0.6,RHEL 5
By: arunb1982 on Fri, 11 February 2011
6 2404 Fri, 11 February 2011 12:44
By: Michel Cadot
  Queries on PGA Settings and related Memory Management
Oracle 9i on RHEL
By: OraKaran on Fri, 11 February 2011
8 7056 Fri, 11 February 2011 11:14
By: OraKaran
  Delete command running taking long time
windows server 2003, oracle 11g DB
By: pradies on Fri, 11 February 2011
9 4073 Fri, 11 February 2011 05:33
By: OraKaran
  Application is slow when no of connections goes up
Oracle Database 8.1.7 on Solaris
By: rajan69 on Wed, 09 February 2011
2 2087 Wed, 09 February 2011 07:19
By: cookiemonster
  How to Change execution plan of Currently Executing Statement?
Oracle 10.2.4.0 on RHEL
By: OraKaran on Tue, 08 February 2011
6 5218 Wed, 09 February 2011 03:21
By: OraKaran
  data caching
oraclge 10g
By: gamba on Mon, 07 February 2011
7 2465 Tue, 08 February 2011 03:30
By: cookiemonster
  Real time speed improvements & autotrace results.
Oracle 9.2/Solaris
By: Roachcoach on Fri, 04 February 2011
11 5243 Mon, 07 February 2011 09:43
By: Roachcoach
  Update columns of one table using another table
Oracle 10G
By: priyankt on Sun, 06 February 2011
4 2641 Mon, 07 February 2011 02:08
By: priyankt
  tunning
oracle 10g/windows 2003
By: gxeon on Fri, 04 February 2011
5 2697 Fri, 04 February 2011 08:11
By: gxeon
  Query Regarding Nested Loop
Oracle 9i R2 on RHEL
By: OraKaran on Thu, 27 January 2011
27 3997 Thu, 03 February 2011 06:34
By: Michel Cadot
  No Snapshot Avaliable for AWR Report
Oracle 11g, Windows 2003
By: pradies on Tue, 01 February 2011
8 13563 Wed, 02 February 2011 01:35
By: Michel Cadot
  Problem queries of Materialized Views
Oracle 9.2.0.8 , HP-UX B11.23
By: indrajit2002 on Fri, 28 January 2011
21 3454 Tue, 01 February 2011 11:36
By: Art Trifonov
  Disable ADR
By: renafi on Fri, 28 January 2011
2 2482 Sat, 29 January 2011 09:07
By: daverich
  Index usage in order by clause on nullable column
Oracle 10gR2 on RHEL
By: OraKaran on Fri, 28 January 2011
5 6454 Fri, 28 January 2011 19:12
By: rleishman
  Using a stats table instead of regular stats to get a plan
9i
By: Kevin Meade on Thu, 27 January 2011
2 2260 Fri, 28 January 2011 02:48
By: Kevin Meade
icon5.gif Long Running Query
Oracle 9,Unix
By: gurukrishnan on Fri, 28 January 2011
1 1594 Fri, 28 January 2011 00:36
By: BlackSwan
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: Fri May 24 20:28:18 CDT 2024