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

    Replies Views Last message
  help me tune this
oracle 11g
By: newbie69 on Fri, 11 March 2011
2 1107 Fri, 11 March 2011 04:30
By: Roachcoach
  query issue
oracle 10g
By: prashant_ora on Wed, 02 March 2011
24 1042 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 1502 Thu, 10 March 2011 09:04
By: OraKaran
  Slow Performance
Oracle 11g Windows2000 Server
By: IMGS_Oracle on Fri, 18 September 2009
7 9397 Thu, 10 March 2011 07:57
By: martateixeira
  Query tuning
By: preethavinay on Mon, 21 February 2011
7 1425 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 2229 Wed, 09 March 2011 12:36
By: BlackSwan
  SQL Tuning
Oracle 10.2.0.4
By: sathik on Tue, 22 February 2011
12 1254 Tue, 08 March 2011 07:43
By: marcodba
  inserting data using FOR ALL
9i/10g
By: ashish_sun123 on Sun, 06 March 2011
3 1716 Sun, 06 March 2011 17:35
By: Barbara Boehmer
  performance tuning
oracle 10g
By: manidotkandan on Thu, 03 March 2011
7 910 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 757 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 514 Thu, 03 March 2011 04:14
By: Michel Cadot
  Dynamic SQL performance
Oracle 10G
By: uicmxz on Mon, 28 February 2011
1 1109 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 1024 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 891 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 553 Fri, 25 February 2011 15:10
By: cookiemonster
  performance tuning
general
By: goldenshot2727 on Thu, 22 April 2010
4 1154 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 1788 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 1671 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 1592 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 893 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 1563 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 1017 Wed, 16 February 2011 05:52
By: rleishman
  Bulk Update
Oracle 11g
By: rcd70 on Tue, 15 February 2011
1 1259 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 3789 Mon, 14 February 2011 03:44
By: Tlg13team
  Performance tuning
oracle 9i/10g/11g
By: ashish_sun123 on Sun, 13 February 2011
6 658 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 628 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 3032 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 1573 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 862 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 2289 Wed, 09 February 2011 03:21
By: OraKaran
  data caching
oraclge 10g
By: gamba on Mon, 07 February 2011
7 660 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 2737 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 949 Mon, 07 February 2011 02:08
By: priyankt
  tunning
oracle 10g/windows 2003
By: gxeon on Fri, 04 February 2011
5 677 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 1067 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 3837 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 827 Tue, 01 February 2011 11:36
By: Art Trifonov
  Disable ADR
By: renafi on Fri, 28 January 2011
2 1370 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 1665 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 987 Fri, 28 January 2011 02:48
By: Kevin Meade
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: Sat Apr 19 17:09:52 CDT 2014

Total time taken to generate the page: 0.10676 seconds