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
SGA related queries By: charuamit on Mon, 25 June 2012	1	1620	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	3771	Fri, 22 June 2012 20:15 By: BlackSwan
SQL Tuning Help oracle 11g By: thalladas on Thu, 21 June 2012	11	19016	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	1800	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	2256	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	4497	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	2072	Wed, 20 June 2012 02:16 By: Andrey_R
"px send round-robin " By: cutekido on Tue, 19 June 2012	1	2257	Tue, 19 June 2012 17:08 By: BlackSwan
Creation of Index By: suryamz on Thu, 30 March 2006	4	2486	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	1462	Tue, 19 June 2012 02:01 By: Rektanocrit
combination index issue 10.2.0.1 By: andy huang on Sat, 16 June 2012	4	2106	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	1291	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	6329	Thu, 14 June 2012 12:41 By: LNossov
query for optimisation oracle 10g By: raja859 on Thu, 14 June 2012	4	1531	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	1702	Tue, 12 June 2012 13:40 By: LNossov
about V$SQL ...... By: lonion on Fri, 08 June 2012	5	1817	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	2577	Fri, 08 June 2012 03:24 By: Michel Cadot
Optimizing sql By: ora_dev_2012 on Tue, 05 June 2012	3	1884	Wed, 06 June 2012 06:13 By: cookiemonster
Oracle documentation on details of AWR report By: bobbydurrettdba on Mon, 04 June 2012	3	3737	Tue, 05 June 2012 14:47 By: bobbydurrettdba
Optimize my Query By: tarek_land on Tue, 05 June 2012	1	1350	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	1879	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	4057	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	1497	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	1800	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	47522	Fri, 25 May 2012 04:22 By: Jack14
BULK COLLECT issue 10.2.0.1 By: andy huang on Tue, 22 May 2012	14	5141	Wed, 23 May 2012 04:42 By: Michel Cadot
Index skip scan oracle,11.2.0.2,aix6.1 By: chandusatyam on Sat, 19 May 2012	8	3287	Tue, 22 May 2012 16:30 By: rleishman
Tune data coming from legacy system into Oracle DB Oracle 11gR1 By: vivekgupta15 on Tue, 22 May 2012	6	2268	Tue, 22 May 2012 14:03 By: vivekgupta15
Application Slow in EE but fast in XE (2 Merged) Oracle 10g, Windows 2003 By: syed.dastagir on Tue, 22 May 2012	1	1545	Tue, 22 May 2012 09:41 By: BlackSwan
Query not hitting index on date column Oracle 10G By: priyankt on Fri, 18 May 2012	6	2686	Tue, 22 May 2012 08:21 By: John Watson
Problem in Update ORACLE 10g By: priyankt on Fri, 11 May 2012	7	2294	Fri, 18 May 2012 03:46 By: priyankt
query slow in application, fast on SQL*Plus executing Oracle Database 10g(RAC) Enterprise Edition Release 10.2.0.4.0 - 64bit By: Andrey_R on Mon, 14 May 2012	6	6396	Tue, 15 May 2012 06:08 By: LNossov
PLSQL taking long time 11.2.0.2.5 By: getzeeshan on Thu, 10 May 2012	5	2787	Fri, 11 May 2012 11:34 By: Kevin Meade
filesystemio_options=SETALL is slower than ASYNCH, why? 11gr2 hp redhat By: Kevin Meade on Sat, 28 January 2012	7	21354	Fri, 11 May 2012 10:27 By: Kevin Meade
Query hang oracle 10g r2,windows 2003 server By: zeeshan047 on Thu, 10 May 2012	5	2239	Thu, 10 May 2012 08:57 By: Michel Cadot
Help to alternate or rewrite the query (5 threads merged by bb) oracle10.2.0.2,Unix By: krajasekhar.v on Wed, 09 May 2012	2	1538	Thu, 10 May 2012 03:07 By: cookiemonster
Slow İnsert Fast Select problem Oracle 10.2.0.4 Enterprise Edition Operation sys Linux By: fabi88 on Thu, 10 May 2012	1	1840	Thu, 10 May 2012 02:14 By: Michel Cadot
Expplain plan output 10.1.0.1 By: guddu_12 on Wed, 09 May 2012	6	2175	Wed, 09 May 2012 07:29 By: John Watson
how to set the sql_profile 10.2.0.1 By: andy huang on Tue, 08 May 2012	2	2129	Tue, 08 May 2012 21:13 By: andy huang
Performance issue in query Oracle 10 G By: rangan.s on Wed, 02 May 2012	3	2673	Tue, 08 May 2012 09:52 By: LNossov

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: Sun Jan 17 10:48:02 CST 2021