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
On which columns to apply index Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit By: manubatham20 on Mon, 05 March 2012	15	7307	Fri, 23 March 2012 05:48 By: S.Rajaram
Order of steps in execution path and order of predicates in the Plan Oracle 10.2.0.4 By: orapratap on Tue, 20 March 2012	3	3182	Thu, 22 March 2012 07:34 By: S.Rajaram
Ugly View Not Cooperating By: scottwmackey on Tue, 20 March 2012	5	3866	Thu, 22 March 2012 07:30 By: S.Rajaram
TABLESPACE EXTENT 11g By: sathish16787 on Mon, 19 March 2012	13	5298	Wed, 21 March 2012 00:22 By: Michel Cadot
New User Help Me Out (merged 2) Oracle 11gR2, Linux By: shehzaadkareem on Tue, 20 March 2012	6	4468	Tue, 20 March 2012 15:45 By: shehzaadkareem
Materialized View, which should refresh every Tuesday and Friday at 5am. (merged 2) Oracle 11.2.0.2.0 By: vishnu_ora on Tue, 20 March 2012	2	3965	Tue, 20 March 2012 08:56 By: Michel Cadot
How to find Local and global indexes on Particular Table Oracle 10g Release 2 By: msol25 on Mon, 19 March 2012	2	4142	Mon, 19 March 2012 03:12 By: msol25
Reading AWR By: ninan on Tue, 13 March 2012	20	14166	Thu, 15 March 2012 07:33 By: Michel Cadot
Wait/Sleep command in SQL Oracle 11G By: santoshwithu@gmail.com on Thu, 15 March 2012	1	3037	Thu, 15 March 2012 03:56 By: Littlefoot
join condition in index ora 11.2.0.2 By: orarule on Wed, 14 March 2012	19	9711	Thu, 15 March 2012 03:38 By: rleishman
Need to know Sql ID and text HP-UX,Oracle 10g By: pokhraj_d on Wed, 22 February 2012	4	5283	Wed, 14 March 2012 06:18 By: orarule
Oracle sequence performance Oracle 10.2.0.4.0, sun solaris By: a_oracle on Tue, 28 February 2012	20	9139	Wed, 14 March 2012 06:03 By: cookiemonster
Sql statement taking very time Oracle E-Business Suite R12 By: Osafa on Fri, 09 March 2012	16	7311	Mon, 12 March 2012 05:47 By: Osafa
Disk i/o Oracle 11.2.0.2, AIX By: lg123 on Sun, 11 March 2012	1	3243	Sun, 11 March 2012 12:08 By: Michel Cadot
how oracle organises records in partitions 11gr2 By: gogol_1987 on Fri, 09 March 2012	5	4657	Fri, 09 March 2012 04:57 By: gogol_1987
Disk reads By: gkrishn on Fri, 02 March 2012	10	6741	Fri, 09 March 2012 02:39 By: gkrishn
undo tbalespace full, which is rectified but now having big WAIT ORACLE 11G R2 (11.2.0.1.0), ASM , SOLARIS 10, RAC of two Nodes By: janakors on Wed, 07 March 2012	8	4797	Thu, 08 March 2012 12:37 By: janakors
Slow Query Oracle 10 g By: RAM_PIPL on Wed, 29 February 2012	3	3823	Thu, 01 March 2012 02:09 By: Roachcoach
Explain plan got changed suddenly Oracle , 10.2.0.4 By: sathik on Thu, 23 February 2012	3	5392	Fri, 24 February 2012 17:00 By: LNossov
Issue with bulk collect over a db link oracle,10.2.0.3,HP-UX By: vishith13 on Thu, 23 February 2012	4	4745	Fri, 24 February 2012 06:03 By: vishith
Function Based Index is not being used Oracle 10.2.0.4 By: orapratap on Wed, 22 February 2012	7	4469	Thu, 23 February 2012 03:45 By: Roachcoach
how to find top query running on a table Oracle EE 10.2.0.3 Linux 64-bit By: freak_vss on Sun, 19 February 2012	2	5363	Mon, 20 February 2012 13:16 By: LNossov
Oracle parameters - processes, session, and transactions Oracle 11.2.0.1 By: djmartin on Mon, 13 February 2012	7	21217	Sun, 19 February 2012 23:07 By: djmartin
application is slow? what to check immediately oracle 11.2.0.1 RAC of two nodes,solaris10 By: janakors on Thu, 16 February 2012	4	4064	Sat, 18 February 2012 16:04 By: LNossov
need help to understand this execution plan oracle 10.2.0.5 By: n2fontenay on Mon, 13 February 2012	5	4043	Thu, 16 February 2012 10:51 By: S.Rajaram
Help - dropping partitions(2 Merged) Oracle, 10.2.0.4 By: sathik on Fri, 10 February 2012	7	5393	Thu, 16 February 2012 10:45 By: S.Rajaram
Handling NULL values in the Database Oracle 10.2.0.4 By: orapratap on Mon, 06 February 2012	3	5386	Fri, 10 February 2012 19:56 By: rleishman
Options for querying on the skewed data Oracle 10.2.0.4 on RHEL By: orapratap on Fri, 10 February 2012	3	4646	Fri, 10 February 2012 19:42 By: rleishman
Query Rewrite Oracle 10g, windows By: oraranjangmailcom on Tue, 07 February 2012	13	5583	Wed, 08 February 2012 05:14 By: cookiemonster
comparing SQL plans between 2 DB's Oracle 11203 Solaris 2.10 By: BeefStu on Fri, 03 February 2012	4	4988	Mon, 06 February 2012 09:05 By: BeefStu
What info should be gathered while doing sql tuning? Oracle 10.2.0.4, Redhat Enterprise Linux 5 64bit By: snowball on Tue, 10 January 2012	19	6953	Sat, 04 February 2012 02:14 By: snowball
Materialized view to improve Search queries Oracle 10g R2 on RHEL By: orapratap on Tue, 31 January 2012	2	4334	Wed, 01 February 2012 10:43 By: orapratap
How to find Literal SQL statement Oracle 10g Hp-UX By: pokhraj_d on Mon, 30 January 2012	4	5997	Mon, 30 January 2012 05:27 By: LNossov
Performance tuning in View Oracle By: bamugan81 on Mon, 30 January 2012	1	3390	Mon, 30 January 2012 04:07 By: cookiemonster
scripts on tablespaces,Indexes and DBJobs linux 4.0 with oracle 10g By: faiz123 on Thu, 19 January 2012	4	3980	Sun, 29 January 2012 02:53 By: John Watson
Subquery Transformation 11gR2, win-xp By: Rahm on Fri, 27 January 2012	14	5298	Fri, 27 January 2012 23:53 By: Michel Cadot
Is it possible to display alternate execution plans ? 11gR2, win-xp By: Rahm on Fri, 27 January 2012	1	3089	Fri, 27 January 2012 09:31 By: BlackSwan
Tune Query or Modify Index or Partition By: p2004 on Fri, 27 January 2012	1	3067	Fri, 27 January 2012 02:29 By: Michel Cadot
PLSQL and related cursors generated in v$sql 10gr2 By: nikko on Thu, 26 January 2012	1	2921	Thu, 26 January 2012 03:01 By: Michel Cadot
Can anyone help to do some tuning on ORACLE 9i? ORACLE 9i By: cooldude_no1 on Wed, 25 January 2012	1	2915	Wed, 25 January 2012 04:28 By: Michel Cadot