OraFAQ Forum: Performance Tuning

Home » RDBMS Server » Performance Tuning

Please read the OraFAQ Forum Guide before posting.

Please contribute good answers to the wiki.

Show: Today's Messages :: Unanswered Messages :: Polls :: Message Navigator

Topic	Replies	Views	Last message
Impact of RAM to oracle 11gR2 on HP-UX IA64 By: yipchunyu on Tue, 27 August 2013	11	5450	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	4303	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	4611	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	4141	Tue, 27 August 2013 03:20 By: VIP2013
dynamic sql choosing wrong index oracle 11g / aix By: 4wheels on Fri, 16 August 2013	3	5120	Thu, 22 August 2013 08:31 By: Kevin Meade
query tuning oracle 010g By: karthikmuthuraman88 on Wed, 21 August 2013	6	9385	Thu, 22 August 2013 08:15 By: Lalit Kumar B
Stats on a partitioned table 11g By: johnp12 on Thu, 08 August 2013	3	5750	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	6051	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	4175	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	10674	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	5164	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	13425	Mon, 12 August 2013 05:58 By: Lalit Kumar B
Optimize Query using Explain Plan 10g By: developer12 on Thu, 08 August 2013	5	5358	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	5137	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	5227	Mon, 05 August 2013 05:15 By: pointers
INSERT INTO ... SELECT FROM t@dblink By: scottwmackey on Fri, 02 August 2013	6	5051	Sat, 03 August 2013 05:16 By: Michel Cadot
Performance tunning By: arnaud.courbiere on Thu, 30 May 2013	2	3555	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	6284	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	3850	Tue, 30 July 2013 08:57 By: Lalit Kumar B
Please tune this query. Oracle 11G By: ajaykumarkona on Wed, 26 June 2013	24	7129	Tue, 30 July 2013 04:17 By: Lalit Kumar B
Need Help In Performance Tuning 10g By: developer12 on Sat, 27 July 2013	3	4668	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	3780	Thu, 25 July 2013 10:35 By: John Watson
TDE Related Question By: VIP2013 on Sat, 20 July 2013	4	3695	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	4861	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	5958	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	4277	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	4789	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	3084	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	8360	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	4273	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	6691	Tue, 09 July 2013 08:38 By: Kevin Meade
Efficient Way to Alter Column For TDE. By: VIP2013 on Thu, 04 July 2013	5	3768	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	3472	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	3726	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	4632	Mon, 01 July 2013 11:35 By: BlackSwan
performance issue with the query Oracle 11G By: ajaykumarkona on Sat, 29 June 2013	8	3813	Mon, 01 July 2013 03:27 By: Michel Cadot
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	5058	Thu, 27 June 2013 07:49 By: Andrey_R
Different Timings between 2 Nodes Oracle 11g Release2 By: feroze on Wed, 26 June 2013	2	3648	Wed, 26 June 2013 16:56 By: feroze
Top wait events Oracle ,11.2.0.3.0 , Solaris 10 sparc 64 bit By: zeeshan047 on Mon, 24 June 2013	2	3536	Mon, 24 June 2013 05:30 By: Flyby
Tuning a SQL query Oracle Database 10g Release 2 By: guptasum on Mon, 02 May 2011	17	17658	Fri, 21 June 2013 10:15 By: Kevin Meade