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
performance issue with the query Oracle 11G By: ajaykumarkona on Sat, 29 June 2013	8	1527	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	2004	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	1222	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	1293	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	8776	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	1392	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	2262	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	1831	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	1015	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	1349	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	2034	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	2512	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	1346	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	2814	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	2781	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	12848	Thu, 30 May 2013 09:16 By: sysdba007
Keep Pool Oracle 11g By: orauser001 on Wed, 22 May 2013	5	3516	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	4482	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	1393	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	1076	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	4583	Fri, 17 May 2013 14:43 By: Flyby
commit_write in 10g Oracle 10g, AIX By: TRaj on Thu, 16 May 2013	3	1518	Fri, 17 May 2013 00:51 By: Michel Cadot
db cache advice 10g Oracle 10g, AIX By: TRaj on Thu, 16 May 2013	2	1308	Thu, 16 May 2013 17:55 By: TRaj
Oracle generates different execution plans for test and prod environments Oracle Database 11g By: httr on Wed, 08 May 2013	11	7566	Wed, 15 May 2013 14:07 By: pointers
Is there any way to have the DB articulate why PDML is blocked 11.2.0.3 By: Roachcoach on Fri, 10 May 2013	10	1636	Wed, 15 May 2013 06:17 By: Roachcoach
why this query is utilizing my undo so rapidly? By: piotrtal on Sat, 11 May 2013	9	4776	Sat, 11 May 2013 14:39 By: piotrtal
delete is very slow 10.2.0.4 By: grpatwari on Fri, 26 April 2013	13	2904	Thu, 09 May 2013 16:53 By: alan.kendall@nfl.com
Query performance tuning for ETL Oracle 11g By: Pms_SARA07 on Wed, 08 May 2013	2	1321	Wed, 08 May 2013 14:59 By: Pms_SARA07
Does partitioning need constraints to be copied Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production By: bhawnakaamra on Sat, 04 May 2013	10	5157	Tue, 07 May 2013 00:02 By: BlackSwan
Performance for Table analysis 11.2.0.1 By: grpatwari on Fri, 03 May 2013	5	962	Fri, 03 May 2013 08:54 By: BlackSwan
Ideas for fixing plan cardinality error By: Kevin Meade on Tue, 30 April 2013	11	2140	Wed, 01 May 2013 10:51 By: Kevin Meade
Oracle Tuning Oracle 11g By: orauser001 on Thu, 25 April 2013	7	1996	Tue, 30 April 2013 08:58 By: Kevin Meade
Sql query running slowly oracle 10g By: anand.oracle on Sat, 27 April 2013	2	1334	Mon, 29 April 2013 22:45 By: Kevin Meade
How to Improve query performance By: panyamravi on Tue, 23 April 2013	5	1901	Sun, 28 April 2013 07:02 By: Kevin Meade
Bind variable issue Oracle 9i By: savugar on Fri, 26 April 2013	7	1321	Fri, 26 April 2013 06:15 By: John Watson
v$sql_plan.object_owner incorrect? By: DKATyler on Thu, 25 April 2013	2	1648	Thu, 25 April 2013 11:56 By: DKATyler
checking the delete performance in the package 10.2.0.4 By: grpatwari on Fri, 12 April 2013	13	2310	Thu, 25 April 2013 03:31 By: grpatwari
alert.log question Oracle DB 11, SLES 11 By: Shamall on Tue, 23 October 2012	3	1717	Tue, 23 April 2013 03:25 By: Michel Cadot
update xml eating up a lot of time 11.2.0.2 By: ayush_anand on Wed, 26 September 2012	4	1777	Tue, 23 April 2013 03:22 By: Michel Cadot
Query Tuning -indexing Oracle 10g/Solaris By: prejib on Thu, 14 February 2013	8	2455	Tue, 23 April 2013 02:59 By: Michel Cadot