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
Sql Tuning Advisor - Privileges (sqltrpt.sql) Oracle DB 11g Enterprise - 11.2.0.3 - Linux x86 64-bit By: hitesh.bhatt on Thu, 13 March 2014	2	5442	Thu, 13 March 2014 22:49 By: hitesh.bhatt
Incorrect cardinalty estimate when using a local non-prefixed unique index DB 12.1.0.1 By: John Watson on Fri, 07 March 2014	7	2070	Thu, 13 March 2014 20:04 By: rleishman
SQL Repair Oracle 11g , Unix By: younusc on Mon, 10 March 2014	3	1385	Thu, 13 March 2014 00:02 By: Markwillium
database performance tuning By: likhonisrat on Tue, 11 March 2014	1	1048	Tue, 11 March 2014 06:42 By: John Watson
Query is taking long time 11i By: Vivek_Garg on Sun, 09 March 2014	16	3501	Mon, 10 March 2014 04:49 By: John Watson
How to find throughput by query, session and database wise? Oracle 11.2.0.3, Redhat Linux 5. By: suresh.wst on Sun, 02 March 2014	9	2593	Fri, 07 March 2014 01:41 By: suresh.wst
Difference in elapsed time of the query where everything in the trace seems to be identical Oracle 11g, Windows 7 By: Vivek_Garg on Thu, 06 March 2014	1	1049	Thu, 06 March 2014 07:09 By: John Watson
AWR - "db file parallel read" + "direct path read" wait events, wait class - "User I/O" Oracle 11.2.0.3.0 on HP-UX (64-Bit) By: hitesh.bhatt on Tue, 18 February 2014	3	2651	Sun, 02 March 2014 22:03 By: trantuananh24hg
Oracle contain clause performance issue Oracle / 11g r2/unix By: balaji123 on Fri, 28 February 2014	2	1125	Fri, 28 February 2014 02:13 By: balaji123
Oracle Architecture By: gasbie on Sun, 23 February 2014	2	1829	Mon, 24 February 2014 00:49 By: John Watson
AWR top events:: enq: TX - row lock contention Oracle 11.2.0.3 on HP-UX (64-bit) By: hitesh.bhatt on Thu, 20 February 2014	2	5840	Fri, 21 February 2014 20:44 By: Kevin Meade
Bloom filter joins By: Kevin Meade on Thu, 20 February 2014	4	4655	Fri, 21 February 2014 20:16 By: Kevin Meade
Tuning query without where clause Oracle 11g, Windows Server 2008 using Toad 11 By: jxh461 on Tue, 21 January 2014	6	2242	Thu, 20 February 2014 06:57 By: Kevin Meade
package size oracle 11.2.g OS windows, By: anncao on Thu, 06 February 2014	6	1817	Sat, 08 February 2014 00:44 By: Kevin Meade
result cache physical reads 0 on the first execution.What could be the reason 11g By: ashwanth77 on Fri, 07 February 2014	1	1047	Fri, 07 February 2014 07:51 By: John Watson
Useful quotes to share with developers 11.2.0.2. on Linux By: orausern on Sat, 01 February 2014	4	2296	Mon, 03 February 2014 12:33 By: orausern
I/O Tuning 11.2.0.2 By: varunvir on Fri, 31 January 2014	1	1210	Fri, 31 January 2014 11:12 By: BlackSwan
Assigning Quota on morethan one tablespace Oracle Database, 10.2.0.5.0,Windows Server 2003 By: Guna4324 on Tue, 28 January 2014	4	1296	Tue, 28 January 2014 02:41 By: John Watson
Sudden decrease in performance of query Oracle, 10g, Linux By: qmg1 on Mon, 27 January 2014	4	1778	Mon, 27 January 2014 05:44 By: cookiemonster
Is this example correct? Generic By: manubatham20 on Fri, 24 January 2014	3	13730	Sat, 25 January 2014 08:59 By: manubatham20
More Hash Value Oracle 10g By: shakthi@chettinadmail.com on Sat, 25 January 2014	1	997	Sat, 25 January 2014 00:35 By: BlackSwan
DB in snail's pace or bad SQL query or bad DB design? Oracle 10g By: rc3d on Tue, 21 January 2014	2	1671	Tue, 21 January 2014 22:17 By: Kevin Meade
Tuning for select query oracle 10g,win xp By: Xandot on Tue, 14 January 2014	1	1500	Wed, 15 January 2014 03:12 By: cookiemonster
something similar to mysqlslap (Load Emulation Client) for Oracle DB? Oracle 10g By: rc3d on Tue, 14 January 2014	1	1783	Tue, 14 January 2014 09:27 By: BlackSwan
general view is also takin long time, all of sudden... 11g,11.2.0.3,solaris 10 By: ishika_20 on Mon, 13 January 2014	2	1253	Tue, 14 January 2014 02:51 By: ishika_20
Query Regarding, Average Active Session By: VIP2013 on Mon, 13 January 2014	3	2108	Mon, 13 January 2014 12:29 By: VIP2013
Performance issue 9.2.0.8 and 11.2.0.3 By: Amine on Fri, 10 January 2014	4	1674	Mon, 13 January 2014 12:27 By: Amine
Checking Lock history By: VIP2013 on Mon, 13 January 2014	1	1292	Mon, 13 January 2014 09:46 By: BlackSwan
Tuning suggestions on query Oracle 11g;window2007 By: mohan1760 on Tue, 07 January 2014	3	1570	Fri, 10 January 2014 08:35 By: Kevin Meade
Performance issue oracle 11g r2 By: kurki on Tue, 31 December 2013	13	2727	Wed, 08 January 2014 00:39 By: pablolee
Please help me merge query is taking more time Oracle 11g By: ramya_162 on Sat, 04 January 2014	10	1977	Mon, 06 January 2014 02:44 By: cookiemonster
Query is taking huge time to display the record Oracle e-business Suite 12.1.3. By: ajit.jha31 on Mon, 30 December 2013	8	3580	Sat, 04 January 2014 07:20 By: Kevin Meade
Normally why count () taking so much of time when compare to select By: na.dharma@gmail.com on Thu, 19 December 2013	4	2042	Sun, 29 December 2013 08:03 By: Kevin Meade
Bitmap causing deadlock 11.2.0.3 By: rishwinger on Mon, 23 December 2013	12	6266	Sun, 29 December 2013 07:59 By: Kevin Meade
Performance Issue Oracle 10g, Windows By: pstanand on Thu, 19 December 2013	20	3175	Mon, 23 December 2013 05:19 By: michael_bialik
Oracle alerts 11.2.0.3 By: ivojames on Thu, 19 December 2013	14	3431	Fri, 20 December 2013 12:24 By: BlackSwan
Query taking more time By: nishant87 on Tue, 17 December 2013	39	4607	Thu, 19 December 2013 12:53 By: BlackSwan
Performance Monitoring . By: VIP2013 on Thu, 19 December 2013	1	1037	Thu, 19 December 2013 05:22 By: martijn
Optimizing Select from VIEW Oracle 10G By: gauravgautam135 on Thu, 12 December 2013	3	1411	Sat, 14 December 2013 15:30 By: Kevin Meade
SQL Tuning Advisor 11g By: srikanthreddy001 on Fri, 13 December 2013	3	1530	Fri, 13 December 2013 04:12 By: martijn