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

    Replies Views Last message
  Undo space
By: jack55 on Sun, 15 January 2012
3 1354 Thu, 19 January 2012 07:01
By: Michel Cadot
  truncate table
Linux 2.6.18-92.1.13.el5
By: dba_7722 on Fri, 13 January 2012
4 1116 Fri, 13 January 2012 04:50
By: Michel Cadot
  HTML AWR Report
Red Hat Linux 5.3 and oracle 10g
By: morad_dba on Tue, 10 January 2012
9 9143 Tue, 10 January 2012 09:13
By: ramoradba
  Query running more time
Oracle 11g standard Version
By: sank on Mon, 09 January 2012
4 2377 Tue, 10 January 2012 14:50
By: sank
  What info should be gathered while doing sql tuning?
Oracle 10.2.0.4, Redhat Enterprise Linux 5 64bit
By: snowball on Tue, 10 January 2012
19 1944 Sat, 04 February 2012 02:14
By: snowball
  performace tunning
By: sb0024297 on Fri, 30 December 2011
1 769 Fri, 30 December 2011 03:04
By: Littlefoot
  Remove Table Fragmentation
oracle 11.2.0 , linux X86
By: crussed_sonu on Thu, 29 December 2011
7 2143 Fri, 30 December 2011 04:09
By: Michel Cadot
  Performance problem with table when using one column as reserved word METHOD
Oracle 10g,Windows XP
By: shajat on Thu, 29 December 2011
2 625 Fri, 30 December 2011 05:58
By: shajat
  Query taking long time on MVs
Oracle 11g, UNIX
By: ind9 on Thu, 29 December 2011
4 1372 Wed, 04 January 2012 12:00
By: LNossov
  Query cost
oracle, 10g, HP-UX B.11.23
By: aruldts on Tue, 27 December 2011
1 828 Tue, 27 December 2011 01:32
By: Michel Cadot
  Same query using different execution plans, why??
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0
By: manubatham20 on Mon, 26 December 2011
8 1739 Wed, 04 January 2012 09:15
By: LNossov
icon1.gif Explain Plan
Oracle 10g Hp-UX
By: pokhraj_d on Thu, 05 January 2012
3 1412 Thu, 05 January 2012 06:05
By: rleishman
  Query running long time
Oracle ,10.2.0.4.0 , SunOS
By: Jack14 on Mon, 26 December 2011
5 3814 Wed, 28 December 2011 09:48
By: Kevin Meade
  Tuning a small but complicated query
Oracle
By: neel_Tannu on Thu, 29 December 2011
2 880 Thu, 29 December 2011 17:35
By: BlackSwan
  How to Track Delay in Displaying data on application GUI
Oracle 10.2.0.4
By: orapratap on Wed, 21 December 2011
3 1114 Wed, 21 December 2011 03:59
By: Roachcoach
  buffer busy wait
Linux 2.6.18-92.1.13.el5
By: dba_7722 on Tue, 20 December 2011
4 2161 Tue, 20 December 2011 06:35
By: Michel Cadot
  Rowid Range Scan
By: gajini on Mon, 19 December 2011
9 8085 Mon, 19 December 2011 04:53
By: Roachcoach
  connect database
By: sirumon on Mon, 19 December 2011
13 1281 Wed, 01 August 2012 06:13
By: Michel Cadot
  Bitmap Conversion
Oracle 10.2.0.3.0 on AIX
By: chuckstoker on Tue, 20 December 2011
8 1578 Wed, 28 December 2011 09:49
By: Kevin Meade
  Situations where FAST REFRESH Materialized View does a COMPLETE REFRESH?
Oracle 10g
By: tsteinmaurer on Thu, 15 December 2011
0 1717 Thu, 15 December 2011 06:03
By: tsteinmaurer
  Query on Explain Plan Steps
Oracle 10.2.0.4 on RHEL
By: orapratap on Wed, 14 December 2011
9 1353 Tue, 20 December 2011 23:57
By: orapratap
  Question on table statistics
Oracle 10.2.0.4.0 ,Sun solaris
By: Jack14 on Tue, 13 December 2011
23 3667 Thu, 15 December 2011 23:56
By: Jack14
  simple select * from table is taking lot of time
11.2.0.1.0
By: gogol_1987 on Tue, 13 December 2011
9 1416 Wed, 14 December 2011 04:33
By: gogol_1987
  Time Calculation in AWR report
Oracle 11g R2 on windows 7 64 bit
By: orapratap on Mon, 12 December 2011
2 4380 Tue, 13 December 2011 00:13
By: orapratap
  Performance access direct table vs view
Oracle 10g / Windows XP
By: eeriehunk on Fri, 09 December 2011
9 1601 Tue, 27 December 2011 20:23
By: Kevin Meade
  SQL Profiles
Solaris 10, Oracle 10.2.0.4
By: suddhasatwa_bhaumik on Fri, 09 December 2011
0 1384 Fri, 09 December 2011 06:28
By: suddhasatwa_bhaumik
  Difficulty in using bind variable to check explain plan
Oracle 10.2.0.4 on Linux
By: orapratap on Mon, 12 December 2011
12 2530 Mon, 12 December 2011 03:56
By: Michel Cadot
  sql tuning for one query
11g 11.2.0,2,IBM aix 64 bit
By: pvgangadar on Thu, 08 December 2011
9 1328 Fri, 09 December 2011 08:48
By: John Watson
  Performance Across DB Links
Oracle 11g2, LINUX
By: mjm22 on Wed, 07 December 2011
1 1886 Wed, 07 December 2011 15:17
By: cookiemonster
  create index
10.2.0.4
By: varunvir on Tue, 06 December 2011
13 1023 Wed, 07 December 2011 07:57
By: Michel Cadot
  How to improve the performance of export job(expdp)?
Oracle10gr2, Linux.
By: konkalasiva on Tue, 06 December 2011
1 1928 Tue, 06 December 2011 03:44
By: Michel Cadot
  performance problem
Oracle 9i
By: ajaykumarkona on Wed, 07 December 2011
3 712 Wed, 07 December 2011 02:39
By: Michel Cadot
  How to improve performance
Oracle 9i
By: ravi_n on Wed, 07 December 2011
6 1322 Wed, 14 December 2011 01:28
By: jameslongenecker
  How to reduce cost of my query?
sql developer
By: Naga_naga_naga on Sat, 03 December 2011
3 2401 Sat, 03 December 2011 01:16
By: flyboy
  urgent please modify this query frenz sloww performance
By: arivazhagancsegmailcom on Thu, 01 December 2011
12 1585 Fri, 02 December 2011 16:07
By: LNossov
  memory_max_target and 11g memory utilization - question
11.2.0.1.0
By: piotrtal on Wed, 30 November 2011
5 2573 Wed, 30 November 2011 13:27
By: BlackSwan
  WINDOW SORT
Oracle 11g
By: sachi09 on Wed, 30 November 2011
5 4855 Wed, 30 November 2011 04:37
By: Michel Cadot
  I/O issue
11g r2 HP-UX
By: dba_7722 on Wed, 30 November 2011
4 4710 Thu, 01 December 2011 13:43
By: LNossov
  Tune long running query
Oracle 10.2.0.4.0, SunOS
By: Database admin on Mon, 05 December 2011
24 2320 Tue, 13 December 2011 00:05
By: Database admin
  SGA AND PGA PARAMETER SETTINGS
WINDOWS 2000 SERVER ORACLE 9I
By: mrdb on Sun, 27 November 2011
5 3385 Sun, 27 November 2011 02:49
By: John Watson
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 Oct 22 10:53:03 CDT 2017

Total time taken to generate the page: 0.01411 seconds