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
How to find out who is the locking SQL statement? Oracle Database 11g Release 11.2.0.1.0 - 64bit Production By: Andrey_R on Wed, 04 July 2012	13	4466	Wed, 04 July 2012 13:16 By: Andrey_R
Investigating sudden Temp Tablespace growth from AWR? Oracle 10.2.0.4 By: orapratap on Wed, 04 July 2012	0	2303	Wed, 04 July 2012 05:24 By: orapratap
use_hash hint without arguments Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit By: manubatham20 on Tue, 03 July 2012	3	1967	Wed, 04 July 2012 01:52 By: Michel Cadot
partition pruning oracle 10.2 By: guddu_12 on Tue, 03 July 2012	2	2596	Tue, 03 July 2012 06:44 By: guddu_12
Slow db performance on Oracle 11.2.0.3 Oracle 11.2.0..3, Linux By: u570744 on Sat, 30 June 2012	6	19809	Mon, 02 July 2012 11:28 By: LNossov
SGA related queries Oracle 10.1.0.2.0 By: charuamit on Sat, 30 June 2012	4	2298	Sat, 30 June 2012 01:50 By: charuamit
tools for monitoring the load of the db oracle 10g By: crocuta on Fri, 03 December 2010	4	2528	Fri, 29 June 2012 21:24 By: alan.kendall@nfl.com
Performance issue Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 ,Windows XP By: a_oracle on Thu, 14 June 2012	6	1920	Fri, 29 June 2012 02:22 By: John Watson
how to reduce dml locks? oracle 11.2.0.1.0,windows server 2008 R2 By: vijenderkdba on Thu, 24 May 2012	6	3720	Thu, 28 June 2012 23:22 By: Michel Cadot
Tuning Queries Oracle 10.1.0.2 By: arif_md2009 on Wed, 16 May 2012	13	3990	Thu, 28 June 2012 15:44 By: alan.kendall@nfl.com
redo size Oracle version 11.2.0.2.0, OS AIX basedSystems(64 bit) By: ashishrnv on Mon, 18 June 2012	18	8983	Thu, 28 June 2012 14:29 By: BlackSwan
Value for sga_target Oracle 10.2.0.4.0 on AIX 5.3 By: raj9999 on Fri, 15 June 2012	8	6066	Wed, 27 June 2012 23:15 By: Michel Cadot
a table deleted or updated frequency issue By: andy huang on Thu, 14 June 2012	8	3291	Wed, 27 June 2012 19:09 By: alan.kendall@nfl.com
Outer join causes much slower performance By: projecttoday on Tue, 26 June 2012	3	1674	Wed, 27 June 2012 10:00 By: BlackSwan
performance improvement of clob data oracle 10.2.0.5 solaris 64 bit By: guddu_12 on Tue, 26 June 2012	1	1748	Tue, 26 June 2012 07:04 By: Michel Cadot
SGA related queries By: charuamit on Mon, 25 June 2012	1	1855	Mon, 25 June 2012 05:12 By: Michel Cadot
what's the relationship between the number of blocks and consistent gets ? By: lonion on Wed, 20 June 2012	4	4314	Fri, 22 June 2012 20:15 By: BlackSwan
SQL Tuning Help oracle 11g By: thalladas on Thu, 21 June 2012	11	19981	Fri, 22 June 2012 08:52 By: thalladas
Reg Awrrpt report in oracle database oracle 10.2.0.2.0 By: nilesh_pawaskar on Thu, 21 June 2012	1	2155	Thu, 21 June 2012 07:04 By: Michel Cadot
How to determine the system memory usage by oracle processes Solaris 10 By: getzeeshan on Wed, 20 June 2012	6	2696	Wed, 20 June 2012 15:26 By: getzeeshan
Oracle (HP-UX) connection very slow from Windows client Oracle 9.2.0.7 installed on HP-UX By: C4poster on Mon, 18 June 2012	13	4864	Wed, 20 June 2012 11:19 By: bobbydurrettdba
How can i trace a different from current session with LEVEL 4? Oracle Database 10g Enterprise (RAC) Edition Release 10.2.0.4.0 - 64bit, LINUX By: Andrey_R on Wed, 13 June 2012	8	2347	Wed, 20 June 2012 02:16 By: Andrey_R
"px send round-robin " By: cutekido on Tue, 19 June 2012	1	2580	Tue, 19 June 2012 17:08 By: BlackSwan
Creation of Index By: suryamz on Thu, 30 March 2006	4	2862	Tue, 19 June 2012 11:27 By: Jack14
PL/SQL Block (LOOP) Comparison Oracle 10gR2 10.2.0.5, AIX 6.1 By: Rektanocrit on Tue, 19 June 2012	4	1722	Tue, 19 June 2012 02:01 By: Rektanocrit
combination index issue 10.2.0.1 By: andy huang on Sat, 16 June 2012	4	2496	Mon, 18 June 2012 22:36 By: andy huang
Passing record to a variable - Performance Issue Oracle 10gR2 10.2.0.5 Server:AIX Client:Windows By: Rektanocrit on Fri, 15 June 2012	3	1566	Fri, 15 June 2012 03:34 By: Michel Cadot
how to find the SQL statement which have many hard parse By: lonion on Thu, 31 May 2012	11	7348	Thu, 14 June 2012 12:41 By: LNossov
query for optimisation oracle 10g By: raja859 on Thu, 14 June 2012	4	1799	Thu, 14 June 2012 10:11 By: flyboy
Performace issue in transaction system oracle 10.2.0.5 solaris 64 bit By: guddu_12 on Wed, 06 June 2012	6	1905	Tue, 12 June 2012 13:40 By: LNossov
about V$SQL ...... By: lonion on Fri, 08 June 2012	5	2134	Fri, 08 June 2012 20:51 By: BlackSwan
how to reduce the clustering_factor's value? 10g,linux By: lonion on Thu, 07 June 2012	10	2816	Fri, 08 June 2012 03:24 By: Michel Cadot
Optimizing sql By: ora_dev_2012 on Tue, 05 June 2012	3	2113	Wed, 06 June 2012 06:13 By: cookiemonster
Oracle documentation on details of AWR report By: bobbydurrettdba on Mon, 04 June 2012	3	4153	Tue, 05 June 2012 14:47 By: bobbydurrettdba
Optimize my Query By: tarek_land on Tue, 05 June 2012	1	1566	Tue, 05 June 2012 13:06 By: BlackSwan
block size oracle 10.2.0.5 solaris 64 bit By: guddu_12 on Fri, 01 June 2012	7	2141	Fri, 01 June 2012 09:56 By: guddu_12
Why delete a where rowid=:1 go to index? oracle 10g 10203 By: zengmuansha on Fri, 01 June 2012	12	4342	Fri, 01 June 2012 07:47 By: Michel Cadot
Query optimize oracle, 10.2.0.2, AIX5.3 By: soft_doctor on Fri, 01 June 2012	2	1745	Fri, 01 June 2012 06:15 By: Michel Cadot
Verify statspack Oracle 9.2.0.8.0,windows By: Jack14 on Tue, 29 May 2012	5	2008	Tue, 29 May 2012 02:47 By: Michel Cadot
Privilege to run explain plan Oracle 11.2.0.1.0, Windows By: Jack14 on Thu, 24 May 2012	9	50418	Fri, 25 May 2012 04:22 By: Jack14

Pages (118): [ « ‹ 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 › »]

Goto Forum:

[ Syndicate this forum (XML) ] [

]

Legend

New Messages

No New messages

Locked (w/ unread messages) Locked

Locked

Moved to another forum

Current Time: Wed May 25 08:08:28 CDT 2022