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

    Replies Views Last message
  SQL/PL/SQL Tunning Hints
Connected to Oracle Database 10g Enterprise Edition Release 10.2.0.3.0
By: sonalir on Fri, 02 January 2009
1 4377 Fri, 02 January 2009 04:01
By: Michel Cadot
  Merge join Cartesian and Buffer Sort
Oracle 10.2.0.1, Solaris 10
By: trantuananh24hg on Tue, 30 December 2008
3 6913 Thu, 01 January 2009 06:30
By: rleishman
  Sql query performance
10g
By: huda10 on Mon, 29 December 2008
10 5391 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 3433 Mon, 29 December 2008 08:26
By: srinivas4u2
  Thread 1 cannot allocate new log
By: suspect on Mon, 29 December 2008
3 15227 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 3023 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 3833 Sat, 27 December 2008 17:48
By: Orna
  Left outer join taking more time
By: srihari.gurram on Tue, 23 December 2008
10 6138 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 1999 Fri, 26 December 2008 18:30
By: coleing
  Relate question to MViews
Oracle 10g, cross platform
By: trantuananh24hg on Thu, 25 December 2008
4 2334 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 2504 Thu, 25 December 2008 23:18
By: trantuananh24hg
  Bitmap indexes "drop/create" or "disable/rebuild"
By: Ferrarist on Tue, 23 December 2008
2 4781 Wed, 24 December 2008 04:38
By: Ferrarist
  sql-tuning for specific query?
oracle 9i
By: mm_kanish05 on Wed, 24 December 2008
4 2356 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 2317 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 6667 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 1579 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 1635 Tue, 23 December 2008 01:25
By: sandipshahare
  Query tuning
Oracle 10g
By: virmahi on Mon, 22 December 2008
3 2033 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 2109 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 6711 Fri, 19 December 2008 15:21
By: rleishman
  open cursors
10.2.0.1.0
By: grpatwari on Fri, 19 December 2008
12 4026 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 3340 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 7338 Thu, 18 December 2008 05:47
By: dermot_egan
  SQL tuning
oracle 8.0.6
By: mhdmehraj on Tue, 25 November 2008
3 2083 Tue, 16 December 2008 21:38
By: rleishman
  Post SHRINK Actions : REBUILD INDEX & CBO Stats ?
10gR2
By: TomG on Tue, 16 December 2008
1 4141 Tue, 16 December 2008 21:36
By: rleishman
  Histograms: 32 character limit generates inaccurate stats
By: zaff on Tue, 16 December 2008
3 2238 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 2727 Mon, 15 December 2008 23:58
By: rleishman
  Redo Log Tuning
Oracle 10.2.0.3
By: rumman on Sun, 14 December 2008
2 8454 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 2306 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 6292 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 4942 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 2412 Thu, 11 December 2008 19:12
By: coleing
  Keep buffer pool after restart of the server
By: snomula on Mon, 08 December 2008
5 2958 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 2506 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 2473 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 1815 Tue, 09 December 2008 06:57
By: Frank Naude
  Advice on SQL tuning
Oracle 10g
By: svguerin3 on Wed, 03 December 2008
8 3324 Mon, 08 December 2008 23:32
By: rleishman
  temp tablespace stats
oracle 8.1.7.3
By: Georgette on Mon, 08 December 2008
1 1788 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 11299 Mon, 08 December 2008 08:25
By: Michel Cadot
  USE_HASH
Oracle 9i
By: jageesh on Mon, 08 December 2008
2 2666 Mon, 08 December 2008 06:01
By: Frank Naude
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: Thu Sep 12 18:55:23 CDT 2024