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 :: Show Polls :: Message Navigator

Topic	Replies	Views	Last message
Lost Index from the second execution time Oracle 11gR2, Windows 64 bit By: trantuananh24hg on Thu, 11 July 2013	7	3692	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	1565	Tue, 30 July 2013 08:57 By: Lalit Kumar B
Please tune this query. Oracle 11G By: ajaykumarkona on Wed, 26 June 2013	24	3905	Tue, 30 July 2013 04:17 By: Lalit Kumar B
Need Help In Performance Tuning 10g By: developer12 on Sat, 27 July 2013	3	2160	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	1814	Thu, 25 July 2013 10:35 By: John Watson
TDE Related Question By: VIP2013 on Sat, 20 July 2013	4	1563	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	2807	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	2761	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	1862	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	2326	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	1312	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	4858	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	2077	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	3476	Tue, 09 July 2013 08:38 By: Kevin Meade
Efficient Way to Alter Column For TDE. By: VIP2013 on Thu, 04 July 2013	5	1770	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	1551	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	1761	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	2365	Mon, 01 July 2013 11:35 By: BlackSwan
performance issue with the query Oracle 11G By: ajaykumarkona on Sat, 29 June 2013	8	1855	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	2479	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	1558	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	1600	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	10161	Fri, 21 June 2013 10:15 By: Kevin Meade
DB designing from performance point of view. Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 By: Manoj.Gupta.91 on Mon, 17 June 2013	8	1774	Mon, 17 June 2013 02:32 By: John Watson
Tuning a query with an EXISTS clause Oracle 10.2.0.4 on Solaris 10 By: orausern on Tue, 11 June 2013	4	2713	Fri, 14 June 2013 17:42 By: Kevin Meade
Performance tuning made easy Oracle 10g, Windows 7 64 bit By: stalin4d on Tue, 11 June 2013	9	2203	Fri, 14 June 2013 17:33 By: Kevin Meade
How to Refresh a Materialized view Data. Oracle 10g, Windows 7 64 bit By: stalin4d on Wed, 12 June 2013	2	1293	Wed, 12 June 2013 06:48 By: stalin4d
Memory Allocation in 11 G oracle 11.2.0.3.0 - Windows server 2008 R2 By: muktha_22 on Mon, 10 June 2013	5	1713	Mon, 10 June 2013 07:36 By: Michel Cadot
SQL not using index from application. Oracle 11gR1 By: kanas on Thu, 06 June 2013	9	2546	Mon, 10 June 2013 00:27 By: michael_bialik
System statistics: demonstration 11.2.0.3 By: John Watson on Thu, 06 June 2013	6	2872	Thu, 06 June 2013 07:12 By: Michel Cadot
How to avoid repeat where clause in oracle sql Oracle 11g, Windows By: murman on Tue, 04 June 2013	2	1648	Tue, 04 June 2013 15:20 By: John Watson
Unable to update newly added column in existing table Oracle 9.2.0.6, OS - AIX 6.1 By: s.m.ramachandran on Tue, 21 May 2013	15	3267	Mon, 03 June 2013 12:52 By: s.m.ramachandran
LogMiner Doubt 11.2.0.3.0 By: rishwinger on Mon, 03 June 2013	6	3306	Mon, 03 June 2013 03:46 By: Michel Cadot
High System I/O Wait Class on AWR Oracle 10.2.0.4 EE 64-bit, Solaris 10 By: cklh2000 on Fri, 04 January 2013	10	14160	Thu, 30 May 2013 09:16 By: sysdba007
Keep Pool Oracle 11g By: orauser001 on Wed, 22 May 2013	5	3963	Thu, 30 May 2013 05:30 By: anjugarg66
Help required in analyzing Network waits from AWR Oracle 10.2.0.3 on AIX By: sysdba007 on Wed, 29 May 2013	3	5022	Thu, 30 May 2013 02:40 By: sysdba007
Best disk config for SME scale datawarehouse Oracle std 10Gx64, windows 2008 x64 By: clementstore on Wed, 15 May 2013	2	1669	Mon, 20 May 2013 04:27 By: clementstore
Need help in performance tunning for querying table oracle 10g By: supiash on Sun, 19 May 2013	4	1386	Sun, 19 May 2013 08:39 By: Michel Cadot
enable row movement - ok, but why internally this thing is needed 11.2.0.3.0 By: piotrtal on Fri, 17 May 2013	4	4878	Fri, 17 May 2013 14:43 By: Flyby
commit_write in 10g Oracle 10g, AIX By: TRaj on Thu, 16 May 2013	3	1898	Fri, 17 May 2013 00:51 By: Michel Cadot