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 6762 Thu, 01 January 2009 06:30
By: rleishman
  Sql query performance
10g
By: huda10 on Mon, 29 December 2008
10 5166 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 3254 Mon, 29 December 2008 08:26
By: srinivas4u2
  Thread 1 cannot allocate new log
By: suspect on Mon, 29 December 2008
3 15031 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 2838 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 3578 Sat, 27 December 2008 17:48
By: Orna
  Left outer join taking more time
By: srihari.gurram on Tue, 23 December 2008
10 5931 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 1853 Fri, 26 December 2008 18:30
By: coleing
  Relate question to MViews
Oracle 10g, cross platform
By: trantuananh24hg on Thu, 25 December 2008
4 2149 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 2343 Thu, 25 December 2008 23:18
By: trantuananh24hg
  Bitmap indexes "drop/create" or "disable/rebuild"
By: Ferrarist on Tue, 23 December 2008
2 4586 Wed, 24 December 2008 04:38
By: Ferrarist
  sql-tuning for specific query?
oracle 9i
By: mm_kanish05 on Wed, 24 December 2008
4 2193 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 2129 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 6461 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 1441 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 1481 Tue, 23 December 2008 01:25
By: sandipshahare
  Query tuning
Oracle 10g
By: virmahi on Mon, 22 December 2008
3 1873 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 1965 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 6511 Fri, 19 December 2008 15:21
By: rleishman
  open cursors
10.2.0.1.0
By: grpatwari on Fri, 19 December 2008
12 3802 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 3162 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 7227 Thu, 18 December 2008 05:47
By: dermot_egan
  SQL tuning
oracle 8.0.6
By: mhdmehraj on Tue, 25 November 2008
3 1905 Tue, 16 December 2008 21:38
By: rleishman
  Post SHRINK Actions : REBUILD INDEX & CBO Stats ?
10gR2
By: TomG on Tue, 16 December 2008
1 4004 Tue, 16 December 2008 21:36
By: rleishman
  Histograms: 32 character limit generates inaccurate stats
By: zaff on Tue, 16 December 2008
3 2090 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 2529 Mon, 15 December 2008 23:58
By: rleishman
  Redo Log Tuning
Oracle 10.2.0.3
By: rumman on Sun, 14 December 2008
2 8260 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 2135 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 6157 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 4731 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 2248 Thu, 11 December 2008 19:12
By: coleing
  Keep buffer pool after restart of the server
By: snomula on Mon, 08 December 2008
5 2800 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 2329 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 2317 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 1665 Tue, 09 December 2008 06:57
By: Frank Naude
  Advice on SQL tuning
Oracle 10g
By: svguerin3 on Wed, 03 December 2008
8 3099 Mon, 08 December 2008 23:32
By: rleishman
  temp tablespace stats
oracle 8.1.7.3
By: Georgette on Mon, 08 December 2008
1 1643 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 11099 Mon, 08 December 2008 08:25
By: Michel Cadot
  USE_HASH
Oracle 9i
By: jageesh on Mon, 08 December 2008
2 2507 Mon, 08 December 2008 06:01
By: Frank Naude
  how to tune this query?
By: Selva on Wed, 08 December 2004
3 3619 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: Sun Jun 23 14:25:28 CDT 2024