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

    Replies Views Last message
  Need help to tune this query
Oracle 11g
By: ramya_162 on Wed, 28 August 2013
10 1943 Fri, 04 October 2013 01:50
By: 8939513598$
  Impact of RAM to oracle
11gR2 on HP-UX IA64
By: yipchunyu on Tue, 27 August 2013
11 1834 Thu, 29 August 2013 10:06
By: yipchunyu
  Please guide to improve the performance of query
Oracle 11g
By: ajaykumarkona on Mon, 26 August 2013
8 1749 Tue, 27 August 2013 03:56
By: pablolee
  Moving Tables to Encrypted Tablespace.
11.2.0.3.0 version of oracle.
By: VIP2013 on Sun, 25 August 2013
2 1332 Tue, 27 August 2013 03:20
By: VIP2013
  query tuning
oracle 010g
By: karthikmuthuraman88 on Wed, 21 August 2013
6 4099 Thu, 22 August 2013 08:15
By: Lalit Kumar B
  NOWAIT lock requests could hang (like Parallel Queries may hang "enq: TS - contention")
database enterprize edition 11.2.0.3 solaris 10
By: mshrkshl on Thu, 29 August 2013
2 1887 Thu, 29 August 2013 04:38
By: mshrkshl
  Efficient Way - Outer join Vs Not Exists
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: saipradyumn on Tue, 20 August 2013
4 2847 Wed, 21 August 2013 01:33
By: saipradyumn
  dynamic sql choosing wrong index
oracle 11g / aix
By: 4wheels on Fri, 16 August 2013
3 1559 Thu, 22 August 2013 08:31
By: Kevin Meade
  dbms_stats.set_table_prefs and "LIST STALE"
11.2.0.3.0
By: johnp12 on Wed, 14 August 2013
8 5737 Thu, 15 August 2013 10:12
By: johnp12
  identifying query problem
Oracle 10.2.0.4.0, RedHatLinux-5
By: 8939513598$ on Mon, 12 August 2013
4 1382 Tue, 20 August 2013 22:11
By: Kevin Meade
  about index
Oracle 10.2.0.4.0, RedHatLinux-5
By: 8939513598$ on Fri, 09 August 2013
4 1864 Thu, 15 August 2013 10:06
By: BlackSwan
  Stats on a partitioned table
11g
By: johnp12 on Thu, 08 August 2013
3 2166 Wed, 21 August 2013 21:47
By: Kevin Meade
  Optimize Query using Explain Plan
10g
By: developer12 on Thu, 08 August 2013
5 2005 Fri, 09 August 2013 11:47
By: developer12
  Please help on this
Oracle 11g
By: ajaykumarkona on Tue, 06 August 2013
4 1352 Fri, 30 August 2013 02:54
By: pablolee
  INSERT INTO ... SELECT FROM t@dblink
By: scottwmackey on Fri, 02 August 2013
6 1825 Sat, 03 August 2013 05:16
By: Michel Cadot
  Analyze stats running long
Oracle 11g R2, Windows 32 bit
By: nvembu on Wed, 31 July 2013
9 1872 Mon, 05 August 2013 05:15
By: pointers
  Full Index Scan issue
11.2.0.3.0
By: rishwinger on Tue, 30 July 2013
9 1859 Wed, 07 August 2013 01:50
By: rishwinger
  Howto avoid virtual circuit wait as application developer?
11gR2 (11.2.0.3)
By: bet32978 on Wed, 07 August 2013
4 12733 Thu, 19 September 2013 08:28
By: bet32978
  Need Help In Performance Tuning
10g
By: developer12 on Sat, 27 July 2013
3 1351 Sat, 27 July 2013 12:15
By: John Watson
  How to determine memory usage for a function
Toad for Oracle 11g on Windows 7
By: jxh461 on Wed, 24 July 2013
5 1042 Tue, 30 July 2013 08:57
By: Lalit Kumar B
  TDE Related Question
By: VIP2013 on Sat, 20 July 2013
4 1055 Wed, 24 July 2013 11:33
By: VIP2013
  Cannot collect Top Frequency Histogram on column
Oracle 11.2.0.2.0 on Windows Server 2003
By: Andrey_R on Tue, 23 July 2013
3 1326 Thu, 25 July 2013 10:35
By: John Watson
  Different execution plan in Different DB
Oracle 10g
By: sss111ind on Sat, 20 July 2013
6 1287 Sun, 21 July 2013 05:22
By: Lalit Kumar B
  Exec plan explanation
11.2.0.3
By: John Watson on Fri, 19 July 2013
10 1775 Sun, 21 July 2013 07:55
By: Michel Cadot
  About NO_INDEX Hint
Oracle 11.2.0.3.0
By: mkdeepak87 on Thu, 18 July 2013
2 1699 Fri, 19 July 2013 03:43
By: John Watson
  SQL Execution Plan Export/Import within 10.2.0.4 version databases
10.2.0.4 in AIX
By: TRaj on Tue, 16 July 2013
2 2183 Sun, 21 July 2013 14:27
By: Lalit Kumar B
  Script to load Trace files errors to a Table
IBM AIX
By: user81 on Sat, 13 July 2013
3 835 Sat, 13 July 2013 14:38
By: Michel Cadot
  How to enable AWR in oracle 10g
10g, 10.2.0.1, windows XP
By: suman1986 on Fri, 12 July 2013
3 3749 Fri, 12 July 2013 06:10
By: suman1986
  Lost Index from the second execution time
Oracle 11gR2, Windows 64 bit
By: trantuananh24hg on Thu, 11 July 2013
7 2651 Tue, 30 July 2013 21:24
By: trantuananh24hg
  Full Table scan - Query without where clause
11g, 11.2.0.5, AIX
By: ishika_20 on Thu, 11 July 2013
6 1506 Fri, 12 July 2013 00:10
By: ishika_20
  Please help me to improve the performance of this query.
Oracle 11G ( 1 2)
By: ajaykumarkona on Mon, 08 July 2013
41 4837 Mon, 12 August 2013 05:58
By: Lalit Kumar B
  Oracle Performance Test Tools
Oracle 10.2, 11.2
By: snowball on Mon, 08 July 2013
6 993 Mon, 08 July 2013 05:34
By: snowball
  Efficient Way to Alter Column For TDE.
By: VIP2013 on Thu, 04 July 2013
5 1198 Mon, 08 July 2013 05:51
By: VIP2013
  SQL & PL/SQL Performance Tuning
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: saipradyumn on Tue, 02 July 2013
1 1080 Tue, 02 July 2013 07:27
By: Michel Cadot
  Simple query is taking long time
Oracle 11G
By: ajaykumarkona on Sat, 29 June 2013
16 2488 Tue, 09 July 2013 08:38
By: Kevin Meade
  Histograms issue During DB Upgrade.
Oracle - 11.2.0.3 G
By: VIP2013 on Sat, 29 June 2013
3 1527 Mon, 01 July 2013 11:35
By: BlackSwan
  performance issue with the query
Oracle 11G
By: ajaykumarkona on Sat, 29 June 2013
8 1311 Mon, 01 July 2013 03:27
By: Michel Cadot
  Different Timings between 2 Nodes
Oracle 11g Release2
By: feroze on Wed, 26 June 2013
2 1014 Wed, 26 June 2013 16:56
By: feroze
  Sql query is slow
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
By: prashanth7582 on Wed, 26 June 2013
9 1535 Thu, 27 June 2013 07:49
By: Andrey_R
  Please tune this query.
Oracle 11G
By: ajaykumarkona on Wed, 26 June 2013
24 2891 Tue, 30 July 2013 04:17
By: Lalit Kumar B
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 Sep 24 09:12:28 CDT 2017

Total time taken to generate the page: 0.07804 seconds