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

    Replies Views Last message
  Call from specified Machine not assigned to Database resource consumer.
Release 11.2.0.3.0 - 64bit
By: VIP2013 on Fri, 06 September 2013
9 1251 Sun, 08 September 2013 00:45
By: VIP2013
  Database crash Due To CPU Starvation
11.2.0.3 Version Oracle.
By: VIP2013 on Sun, 01 September 2013
9 1149 Wed, 04 September 2013 14:04
By: VIP2013
  Parallel hints with cursor queries
Oracle 11.2.0.2.0, Windows XP
By: a_oracle on Wed, 28 August 2013
13 1607 Sun, 01 September 2013 13:56
By: Lalit Kumar B
  Performance issue with a query using DB links
am on Oracle 11.2.0.3 on Solaris 10 on one database and oracle 10.2.0.4 on Solaris 10 on another database
By: orausern on Wed, 28 August 2013
18 1380 Fri, 30 August 2013 13:06
By: orausern
  Please help on this
Oracle 11g
By: ajaykumarkona on Tue, 06 August 2013
4 846 Fri, 30 August 2013 02:54
By: pablolee
  Impact of RAM to oracle
11gR2 on HP-UX IA64
By: yipchunyu on Tue, 27 August 2013
11 1016 Thu, 29 August 2013 10:06
By: yipchunyu
  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 700 Thu, 29 August 2013 04:38
By: mshrkshl
  Please guide to improve the performance of query
Oracle 11g
By: ajaykumarkona on Mon, 26 August 2013
8 1112 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 670 Tue, 27 August 2013 03:20
By: VIP2013
  dynamic sql choosing wrong index
oracle 11g / aix
By: 4wheels on Fri, 16 August 2013
3 788 Thu, 22 August 2013 08:31
By: Kevin Meade
  query tuning
oracle 010g
By: karthikmuthuraman88 on Wed, 21 August 2013
6 1406 Thu, 22 August 2013 08:15
By: Lalit Kumar B
  Stats on a partitioned table
11g
By: johnp12 on Thu, 08 August 2013
3 943 Wed, 21 August 2013 21:47
By: Kevin Meade
  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 1398 Wed, 21 August 2013 01:33
By: saipradyumn
  identifying query problem
Oracle 10.2.0.4.0, RedHatLinux-5
By: 8939513598$ on Mon, 12 August 2013
4 949 Tue, 20 August 2013 22:11
By: Kevin Meade
  dbms_stats.set_table_prefs and "LIST STALE"
11.2.0.3.0
By: johnp12 on Wed, 14 August 2013
8 2639 Thu, 15 August 2013 10:12
By: johnp12
  about index
Oracle 10.2.0.4.0, RedHatLinux-5
By: 8939513598$ on Fri, 09 August 2013
4 1160 Thu, 15 August 2013 10:06
By: BlackSwan
  Please help me to improve the performance of this query.
Oracle 11G ( 1 2)
By: ajaykumarkona on Mon, 08 July 2013
41 3688 Mon, 12 August 2013 05:58
By: Lalit Kumar B
  Optimize Query using Explain Plan
10g
By: developer12 on Thu, 08 August 2013
5 1226 Fri, 09 August 2013 11:47
By: developer12
  Full Index Scan issue
11.2.0.3.0
By: rishwinger on Tue, 30 July 2013
9 1229 Wed, 07 August 2013 01:50
By: rishwinger
  Analyze stats running long
Oracle 11g R2, Windows 32 bit
By: nvembu on Wed, 31 July 2013
9 1203 Mon, 05 August 2013 05:15
By: pointers
  INSERT INTO ... SELECT FROM t@dblink
By: scottwmackey on Fri, 02 August 2013
6 1105 Sat, 03 August 2013 05:16
By: Michel Cadot
  Performance tunning
By: arnaud.courbiere on Thu, 30 May 2013
2 984 Thu, 01 August 2013 23:49
By: BlackSwan
  Lost Index from the second execution time
Oracle 11gR2, Windows 64 bit
By: trantuananh24hg on Thu, 11 July 2013
7 1184 Tue, 30 July 2013 21:24
By: trantuananh24hg
  How to determine memory usage for a function
Toad for Oracle 11g on Windows 7
By: jxh461 on Wed, 24 July 2013
5 634 Tue, 30 July 2013 08:57
By: Lalit Kumar B
  Please tune this query.
Oracle 11G
By: ajaykumarkona on Wed, 26 June 2013
24 2008 Tue, 30 July 2013 04:17
By: Lalit Kumar B
  Need Help In Performance Tuning
10g
By: developer12 on Sat, 27 July 2013
3 616 Sat, 27 July 2013 12:15
By: John Watson
  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 672 Thu, 25 July 2013 10:35
By: John Watson
  TDE Related Question
By: VIP2013 on Sat, 20 July 2013
4 610 Wed, 24 July 2013 11:33
By: VIP2013
  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 970 Sun, 21 July 2013 14:27
By: Lalit Kumar B
  Exec plan explanation
11.2.0.3
By: John Watson on Fri, 19 July 2013
10 1038 Sun, 21 July 2013 07:55
By: Michel Cadot
  Different execution plan in Different DB
Oracle 10g
By: sss111ind on Sat, 20 July 2013
6 749 Sun, 21 July 2013 05:22
By: Lalit Kumar B
  About NO_INDEX Hint
Oracle 11.2.0.3.0
By: mkdeepak87 on Thu, 18 July 2013
2 976 Fri, 19 July 2013 03:43
By: John Watson
  Script to load Trace files errors to a Table
IBM AIX
By: user81 on Sat, 13 July 2013
3 437 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 1290 Fri, 12 July 2013 06:10
By: suman1986
  Full Table scan - Query without where clause
11g, 11.2.0.5, AIX
By: ishika_20 on Thu, 11 July 2013
6 917 Fri, 12 July 2013 00:10
By: ishika_20
  Simple query is taking long time
Oracle 11G
By: ajaykumarkona on Sat, 29 June 2013
16 1618 Tue, 09 July 2013 08:38
By: Kevin Meade
  Efficient Way to Alter Column For TDE.
By: VIP2013 on Thu, 04 July 2013
5 732 Mon, 08 July 2013 05:51
By: VIP2013
  Oracle Performance Test Tools
Oracle 10.2, 11.2
By: snowball on Mon, 08 July 2013
6 624 Mon, 08 July 2013 05:34
By: snowball
  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 596 Tue, 02 July 2013 07:27
By: Michel Cadot
  Histograms issue During DB Upgrade.
Oracle - 11.2.0.3 G
By: VIP2013 on Sat, 29 June 2013
3 762 Mon, 01 July 2013 11:35
By: BlackSwan
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: Sat Oct 25 11:14:35 CDT 2014

Total time taken to generate the page: 0.11638 seconds