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

    Replies Views Last message
  Shall I kill these process...
Oracle 10g rel 2
By: ramoradba on Mon, 11 April 2011
2 675 Mon, 11 April 2011 15:01
By: ramoradba
  Hier - Query Perfomance (3 Merged)
By: mnafehm on Mon, 04 April 2011
3 944 Sat, 09 April 2011 21:04
By: rleishman
  How to index 15 columns when you cannot predict what columns will be used in a where clause?
Oracle DB 10gR2
By: vini_au on Mon, 04 April 2011
12 1748 Fri, 08 April 2011 00:20
By: rleishman
  Why Oracle don't use my predefined index?
Oracle 10G, windows
By: Tlg13team on Thu, 07 April 2011
5 1054 Thu, 07 April 2011 02:43
By: Roachcoach
  Execution plan question
Oracle Database 10g Release 10.2.0.5.0 - 64bit Production
By: Buchas on Tue, 05 April 2011
15 2433 Wed, 06 April 2011 08:29
By: cookiemonster
  Performance tuning of query with self join
By: preethavinay on Wed, 06 April 2011
2 636 Wed, 06 April 2011 06:08
By: michael_bialik
  how to use index on "ON in MERGE statement"?
10g, windows 2003 server.
By: kang on Wed, 06 April 2011
19 1002 Wed, 06 April 2011 04:59
By: Roachcoach
  Just clarification my mind about redo log file size
Oracle 10G
By: Tlg13team on Wed, 06 April 2011
3 2045 Wed, 06 April 2011 01:16
By: Michel Cadot
  please help me tune this query
By: miroconnect@yahoo.com on Sun, 03 April 2011
3 780 Mon, 04 April 2011 09:10
By: cookiemonster
  Query getting slowed running in Oracle 10g compared to Oracle 9i
Oracle 10g, Linux
By: ram anand on Wed, 30 March 2011
24 2770 Mon, 04 April 2011 06:35
By: John Watson
  Query not executing (3 Merged)
Oracle 10g
By: ajaykumarkona on Mon, 28 March 2011
11 966 Mon, 04 April 2011 02:26
By: cookiemonster
  derived column index
oralce 10g
By: miroconnect@yahoo.com on Sat, 02 April 2011
3 811 Sat, 02 April 2011 08:37
By: BlackSwan
  using between slows query
oralce 10g
By: miroconnect@yahoo.com on Sat, 02 April 2011
1 1010 Sat, 02 April 2011 01:24
By: Michel Cadot
  Performance tuning of query with self join
By: preethavinay on Thu, 31 March 2011
6 1241 Fri, 01 April 2011 02:48
By: Its_me_ved
icon5.gif split a large table to small pieces?
Oracle 10G, Solaris 10
By: Tlg13team on Mon, 28 March 2011
12 1563 Thu, 31 March 2011 03:40
By: Kevin Meade
  Can I use Oracle Hint to use index in a query which uses UNION
Oracle 10g
By: arijitdey80 on Thu, 31 March 2011
1 1490 Thu, 31 March 2011 01:52
By: Michel Cadot
  Why are these explain plans missing some info and messed up like they've been simultaneously written
Windows 7 Pro, x64bit
By: ilharco on Tue, 29 March 2011
8 1425 Tue, 29 March 2011 17:06
By: BlackSwan
  nested select / instead-of-trigger and views=no index used
10g 10.2.0.4
By: Kevin Meade on Tue, 08 September 2009
10 2250 Tue, 29 March 2011 08:47
By: ipynnonen
  Performance issue with long running query
Oracle 11i
By: prasadpsk on Wed, 23 March 2011
14 1890 Tue, 29 March 2011 03:16
By: rleishman
  How to assure partition table is better than non-partition table (2 MERGED)
Oracle 10g R2
By: Tlg13team on Fri, 25 March 2011
11 1334 Mon, 28 March 2011 21:19
By: BlackSwan
  row cache lock/dc_users??
oracle 11g solaris 10
By: chris32680 on Thu, 17 March 2011
21 10036 Mon, 28 March 2011 09:03
By: Michel Cadot
icon5.gif clarification of query EXPLAIN plan
Oracle 10G, Solaris 10
By: Tlg13team on Thu, 24 March 2011
5 874 Sun, 27 March 2011 20:15
By: Tlg13team
  why db need kill session instantly
Oracle 10G2, RedHat Linux Enterprice6
By: runinwind on Tue, 22 March 2011
2 1138 Sat, 26 March 2011 00:58
By: vjeedigunta
  sql library miss rate (2 Merged)
oracle database 10.2.0.4
By: karioookey on Fri, 18 March 2011
15 4014 Tue, 22 March 2011 14:29
By: Michel Cadot
  SQL Tuning ...
Oracle 11g R2
By: aucrun on Tue, 22 March 2011
1 932 Tue, 22 March 2011 13:02
By: BlackSwan
icon8.gif 9582.69043 gigabytes of physical read total bytes and increasing!
11gR2 on Linux RedHat
By: nabeelkhan on Thu, 17 March 2011
8 4130 Sat, 19 March 2011 03:12
By: John Watson
  INDEXES on TIMESTAMP
Oracle 11.2 WIndows Vista 64bit
By: amcghie on Thu, 17 March 2011
0 6674 Thu, 17 March 2011 12:01
By: amcghie
  help me tune this
11g
By: xpact83 on Sun, 13 March 2011
3 662 Mon, 14 March 2011 04:55
By: michael_bialik
  Update in a Loop
Oracle 11g
By: feroze on Fri, 11 March 2011
4 3125 Fri, 11 March 2011 12:08
By: flyboy
  help me tune this
oracle 11g
By: newbie69 on Fri, 11 March 2011
2 1200 Fri, 11 March 2011 04:30
By: Roachcoach
  query issue
oracle 10g
By: prashant_ora on Wed, 02 March 2011
24 1129 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 1589 Thu, 10 March 2011 09:04
By: OraKaran
  Slow Performance
Oracle 11g Windows2000 Server
By: IMGS_Oracle on Fri, 18 September 2009
7 9828 Thu, 10 March 2011 07:57
By: martateixeira
  Query tuning
By: preethavinay on Mon, 21 February 2011
7 1521 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 2413 Wed, 09 March 2011 12:36
By: BlackSwan
  SQL Tuning
Oracle 10.2.0.4
By: sathik on Tue, 22 February 2011
12 1384 Tue, 08 March 2011 07:43
By: marcodba
  inserting data using FOR ALL
9i/10g
By: ashish_sun123 on Sun, 06 March 2011
3 1807 Sun, 06 March 2011 17:35
By: Barbara Boehmer
  performance tuning
oracle 10g
By: manidotkandan on Thu, 03 March 2011
7 1025 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 827 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 543 Thu, 03 March 2011 04:14
By: Michel Cadot
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 Sep 24 00:14:39 CDT 2014

Total time taken to generate the page: 0.07108 seconds