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

    Replies Views Last message
  Merge join Cartesian and Buffer Sort
Oracle 10.2.0.1, Solaris 10
By: trantuananh24hg on Tue, 30 December 2008
3 6791 Thu, 01 January 2009 06:30
By: rleishman
  Sql query performance
10g
By: huda10 on Mon, 29 December 2008
10 5206 Mon, 29 December 2008 20:57
By: rleishman
  Fetch is taking too long
10.2.0.3
By: srinivas4u2 on Mon, 22 December 2008
5 3280 Mon, 29 December 2008 08:26
By: srinivas4u2
  Thread 1 cannot allocate new log
By: suspect on Mon, 29 December 2008
3 15063 Mon, 29 December 2008 03:59
By: suspect
  One query with two where Conditions on same column
Oracle 10g
By: virmahi on Tue, 23 December 2008
8 2866 Mon, 29 December 2008 03:09
By: virmahi
  performance of delete/insert deteriorate over time
10.2
By: Orna on Wed, 24 December 2008
17 3610 Sat, 27 December 2008 17:48
By: Orna
  Left outer join taking more time
By: srihari.gurram on Tue, 23 December 2008
10 5960 Sat, 27 December 2008 11:18
By: Kevin Meade
  Query Rewrite to Utilize Materialized Views on a Remote Database
By: gunalmel on Tue, 23 December 2008
3 1884 Fri, 26 December 2008 18:30
By: coleing
  Relate question to MViews
Oracle 10g, cross platform
By: trantuananh24hg on Thu, 25 December 2008
4 2187 Fri, 26 December 2008 03:09
By: trantuananh24hg
  I've got a slowly query
Oracle 10.2.0.1, Solaris 10
By: trantuananh24hg on Wed, 24 December 2008
2 2372 Thu, 25 December 2008 23:18
By: trantuananh24hg
  Bitmap indexes "drop/create" or "disable/rebuild"
By: Ferrarist on Tue, 23 December 2008
2 4622 Wed, 24 December 2008 04:38
By: Ferrarist
  sql-tuning for specific query?
oracle 9i
By: mm_kanish05 on Wed, 24 December 2008
4 2223 Wed, 24 December 2008 03:16
By: mm_kanish05
  SQL Tuning
Oracle Database, 10.1.0.2.0, Win 2003 Server
By: sd_md_rizwan@yahoo.com on Tue, 23 December 2008
6 2156 Wed, 24 December 2008 00:45
By: michael_bialik
  Substr,LTrim,Rtrim making query run slow
Oracle 10g
By: virmahi on Tue, 23 December 2008
3 6500 Tue, 23 December 2008 08:17
By: michael_bialik
  Full table scan when one type of records
Oracle 9.2.0.5.0, Windows
By: senaka on Tue, 23 December 2008
1 1473 Tue, 23 December 2008 06:48
By: Michel Cadot
  Querying the database faster
8.1.7.4
By: sandipshahare on Mon, 22 December 2008
2 1508 Tue, 23 December 2008 01:25
By: sandipshahare
  Query tuning
Oracle 10g
By: virmahi on Mon, 22 December 2008
3 1903 Mon, 22 December 2008 04:17
By: Frank Naude
  What is difference between 2 statements?
Oracle 10g, cross platform
By: trantuananh24hg on Fri, 19 December 2008
3 1996 Sat, 20 December 2008 21:56
By: trantuananh24hg
  poor performance of Exchange partition on composite range-hash tables
Oracle 10.2.0.3
By: ora_tune on Fri, 12 December 2008
7 6543 Fri, 19 December 2008 15:21
By: rleishman
  open cursors
10.2.0.1.0
By: grpatwari on Fri, 19 December 2008
12 3836 Fri, 19 December 2008 04:27
By: Frank Naude
  Identifying trace files and how to retrieve from the server (merged)
By: sathyam2627 on Tue, 16 December 2008
4 3189 Thu, 18 December 2008 20:18
By: trantuananh24hg
  metric defintion for SYSMETRIC
Oracle server enterprise 10.2.0.3
By: dermot_egan on Thu, 18 December 2008
0 7258 Thu, 18 December 2008 05:47
By: dermot_egan
  SQL tuning
oracle 8.0.6
By: mhdmehraj on Tue, 25 November 2008
3 1939 Tue, 16 December 2008 21:38
By: rleishman
  Post SHRINK Actions : REBUILD INDEX & CBO Stats ?
10gR2
By: TomG on Tue, 16 December 2008
1 4033 Tue, 16 December 2008 21:36
By: rleishman
  Histograms: 32 character limit generates inaccurate stats
By: zaff on Tue, 16 December 2008
3 2117 Tue, 16 December 2008 13:11
By: Mahesh Rajendran
  Simple query taking too long - looking for Index Suggestion
9.2.0.7
By: agurm on Fri, 12 December 2008
6 2561 Mon, 15 December 2008 23:58
By: rleishman
  Redo Log Tuning
Oracle 10.2.0.3
By: rumman on Sun, 14 December 2008
2 8293 Mon, 15 December 2008 02:00
By: Frank Naude
  How SELECT affects remote database from which data is selected
By: lotusdeva on Fri, 12 December 2008
7 2162 Sat, 13 December 2008 01:31
By: Michel Cadot
  data pull from a table
oracle 10g unix
By: dr46014 on Fri, 12 December 2008
0 6183 Fri, 12 December 2008 12:08
By: dr46014
  Converting Trace (.TRC) file to readable(HTML) file in forms 10g
10.1.2.0.2
By: sureshAToracle on Thu, 04 December 2008
1 4763 Fri, 12 December 2008 01:04
By: Kevin Meade
icon4.gif How to improve the performance of "creating partition".
oracle 10g R1 on Red Hat linux
By: abs_amit on Mon, 08 December 2008
4 2276 Thu, 11 December 2008 19:12
By: coleing
  Keep buffer pool after restart of the server
By: snomula on Mon, 08 December 2008
5 2839 Wed, 10 December 2008 03:59
By: JRowbottom
  Table extents
10g ver 10.2.0.3.0
By: rcd70 on Sun, 07 December 2008
6 2363 Tue, 09 December 2008 15:22
By: Michel Cadot
  Problems with with-statement
Oracle 10.2.0
By: eigeneachse on Tue, 09 December 2008
3 2349 Tue, 09 December 2008 11:23
By: coleing
icon5.gif Oracle Benchmark Results for Different Servers brand name
Oracle 10g
By: chara on Tue, 09 December 2008
1 1698 Tue, 09 December 2008 06:57
By: Frank Naude
  Advice on SQL tuning
Oracle 10g
By: svguerin3 on Wed, 03 December 2008
8 3132 Mon, 08 December 2008 23:32
By: rleishman
  temp tablespace stats
oracle 8.1.7.3
By: Georgette on Mon, 08 December 2008
1 1673 Mon, 08 December 2008 22:59
By: Michel Cadot
  INDEX_DESC Hint
Oracle 10.2.0.3
By: Olivia on Mon, 08 December 2008
3 11132 Mon, 08 December 2008 08:25
By: Michel Cadot
  USE_HASH
Oracle 9i
By: jageesh on Mon, 08 December 2008
2 2540 Mon, 08 December 2008 06:01
By: Frank Naude
  how to tune this query?
By: Selva on Wed, 08 December 2004
3 3646 Sun, 07 December 2008 22:45
By: dmerin
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 Jul 05 13:25:18 CDT 2024