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
Assigning Quota on morethan one tablespace Oracle Database, 10.2.0.5.0,Windows Server 2003 By: Guna4324 on Tue, 28 January 2014	4	3731	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	4085	Mon, 27 January 2014 05:44 By: cookiemonster
Is this example correct? Generic By: manubatham20 on Fri, 24 January 2014	3	16797	Sat, 25 January 2014 08:59 By: manubatham20
More Hash Value Oracle 10g By: shakthi@chettinadmail.com on Sat, 25 January 2014	1	3055	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	3560	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	3545	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	4440	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	3225	Tue, 14 January 2014 02:51 By: ishika_20
Query Regarding, Average Active Session By: VIP2013 on Mon, 13 January 2014	3	4325	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	3865	Mon, 13 January 2014 12:27 By: Amine
Checking Lock history By: VIP2013 on Mon, 13 January 2014	1	4447	Mon, 13 January 2014 09:46 By: BlackSwan
Tuning suggestions on query Oracle 11g;window2007 By: mohan1760 on Tue, 07 January 2014	3	3728	Fri, 10 January 2014 08:35 By: Kevin Meade
Performance issue oracle 11g r2 By: kurki on Tue, 31 December 2013	13	6839	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	4686	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	7599	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	4431	Sun, 29 December 2013 08:03 By: Kevin Meade
Bitmap causing deadlock 11.2.0.3 By: rishwinger on Mon, 23 December 2013	12	11176	Sun, 29 December 2013 07:59 By: Kevin Meade
Performance Issue Oracle 10g, Windows By: pstanand on Thu, 19 December 2013	20	6995	Mon, 23 December 2013 05:19 By: michael_bialik
Oracle alerts 11.2.0.3 By: ivojames on Thu, 19 December 2013	14	7353	Fri, 20 December 2013 12:24 By: BlackSwan
Query taking more time By: nishant87 on Tue, 17 December 2013	39	8934	Thu, 19 December 2013 12:53 By: BlackSwan
Performance Monitoring . By: VIP2013 on Thu, 19 December 2013	1	3013	Thu, 19 December 2013 05:22 By: martijn
Optimizing Select from VIEW Oracle 10G By: gauravgautam135 on Thu, 12 December 2013	3	3697	Sat, 14 December 2013 15:30 By: Kevin Meade
SQL Tuning Advisor 11g By: srikanthreddy001 on Fri, 13 December 2013	3	4278	Fri, 13 December 2013 04:12 By: martijn
how avoid merge join cartesian. Oracle 11g By: na.dharma@gmail.com on Thu, 05 December 2013	4	16779	Thu, 12 December 2013 02:10 By: michael_bialik
how to avoid negative values to number datatype in oracle Oracle 11g By: na.dharma@gmail.com on Wed, 11 December 2013	13	6563	Wed, 11 December 2013 04:48 By: Lalit Kumar B
look like same query, but huge query plan different. Oracle 11g By: na.dharma@gmail.com on Tue, 10 December 2013	7	4151	Wed, 11 December 2013 03:08 By: John Watson
SQL with BIND Variable Slow - Bind Peeking 11.2 By: prax_14 on Mon, 09 December 2013	3	3512	Wed, 11 December 2013 01:10 By: John Watson
How to correct completely wrong cardinality shown in query plan 10.2.0.4 on Linux By: orausern on Thu, 05 December 2013	29	9968	Fri, 06 December 2013 11:11 By: orausern
FTS on table Oracle 11g, Unix By: a_oracle on Thu, 05 December 2013	4	4476	Fri, 06 December 2013 08:35 By: Kevin Meade
Changing the defaut number of Plans checked by optimzer Aix By: deadpoet69 on Tue, 03 December 2013	3	3435	Wed, 04 December 2013 04:07 By: Roachcoach
Need help in tuning query By: nishant87 on Fri, 29 November 2013	5	6548	Sun, 01 December 2013 17:29 By: Kevin Meade
Automatic SQL Tuning oracle 10.2.0.4 - Windows server 2003 By: muktha_22 on Thu, 28 November 2013	3	3702	Fri, 29 November 2013 01:20 By: Lalit Kumar B
Need help in tuning query 11i By: nishant87 on Tue, 26 November 2013	4	3805	Tue, 26 November 2013 11:34 By: BlackSwan
Performance degrade Oracle 11gr2 , linux AS5 By: oradba123 on Sat, 23 November 2013	3	3383	Tue, 26 November 2013 08:08 By: Kevin Meade
fast query By: narang79 on Mon, 25 November 2013	6	3889	Tue, 26 November 2013 08:00 By: Kevin Meade
Please help me my query performance is bad. Oracle 11g By: ramya_162 on Wed, 20 November 2013	24	8019	Mon, 25 November 2013 06:18 By: ramya_162
SQL & PL/SQL By: varshbugad on Mon, 25 November 2013	1	3606	Mon, 25 November 2013 02:04 By: pablolee
Locking In application code. By: VIP2013 on Mon, 18 November 2013	6	3884	Fri, 22 November 2013 17:04 By: EdStevens
SELECT works, INSERT+ SELECT hangs in SQLDeveloper Tools Oracle, 11.2, SQLDeveloper By: royalyogi on Tue, 19 November 2013	15	5619	Thu, 21 November 2013 02:38 By: cookiemonster
Need advice on index to apply Oracle 11.2, Window 2008 By: jxh461 on Tue, 19 November 2013	10	4355	Wed, 20 November 2013 16:23 By: Kevin Meade