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
MULTI TABLE INSERT USING BULK COLLECT Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production By: ramanaapps on Mon, 07 December 2015	8	4274	Mon, 07 December 2015 05:40 By: Michel Cadot
Please help for tuning .sql query Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production By: msol25 on Tue, 03 November 2015	17	5819	Tue, 01 December 2015 22:24 By: Kevin Meade
OPT_PARAM - WORK_AREA_POLICY 11.2.0.4 By: rasikeg@gmail.com on Tue, 03 November 2015	2	4188	Tue, 01 December 2015 21:57 By: Kevin Meade
Testing SPM Oracle 11.2.0.4 on Linux By: orausern on Fri, 27 November 2015	12	4868	Tue, 01 December 2015 09:18 By: orausern
Making Oracle generate and use different execution plans for any sql 11.2.0.4 By: orausern on Sat, 28 November 2015	2	4929	Sun, 29 November 2015 05:56 By: orausern
Execution plan cost 11.2.0.3 By: pointers on Wed, 25 November 2015	3	4874	Thu, 26 November 2015 00:25 By: pointers
dbms_xplan Oracle 11.2.0.3 By: pointers on Tue, 27 October 2015	3	3827	Tue, 24 November 2015 05:54 By: pointers
Locking modes 10g By: m.abdulhaq on Fri, 23 October 2015	14	6714	Wed, 11 November 2015 10:35 By: cookiemonster
SQL*Net roundtrips Oracle 12c on LInux By: gkrishn on Sat, 07 November 2015	9	4745	Sun, 08 November 2015 01:41 By: gkrishn
dynamic sampling precedence Oracle DB 12.1.0.2 By: kal_youssef on Tue, 03 November 2015	2	3463	Tue, 03 November 2015 16:12 By: John Watson
Please help for tuning .sql query Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production By: msol25 on Sun, 01 November 2015	2	3747	Mon, 02 November 2015 03:10 By: cookiemonster
Unexplained SQL Slowness (AWR Supplied) Oracle 11.2.4.0, Linux By: ganna76 on Wed, 28 October 2015	5	4198	Wed, 28 October 2015 10:19 By: ganna76
A SQL query with self join and analytical function is running slow Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi By: toitdoctor on Wed, 23 September 2015	14	7506	Mon, 19 October 2015 05:53 By: John Watson
Memory issue with PGA and AMM (merged) 12.1.0.2.0,Oracle Linux 7,x86_64 By: preet_kumar on Wed, 14 October 2015	3	3725	Sun, 18 October 2015 03:16 By: Michel Cadot
Please help for Tuning sql Query. Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production By: msol25 on Thu, 15 October 2015	13	5071	Sat, 17 October 2015 01:20 By: Kevin Meade
Facing performance issues in simple insert statement from Oracle 10g 10g By: toitdoctor on Fri, 16 October 2015	3	3944	Fri, 16 October 2015 14:56 By: Littlefoot
Any good Way to get dNFS IOPS? 11.2.0.3 / CentOS 6 By: ThomasG on Thu, 15 October 2015	2	4063	Thu, 15 October 2015 03:28 By: ThomasG
Can we manually assign certain query transaction between RAC nodes ? 11g R2 By: carillpower on Tue, 29 September 2015	11	5647	Mon, 05 October 2015 09:36 By: bpeasland
Explain plan depends on Oracle client? Oracle 11g By: Buchas on Tue, 29 September 2015	4	3953	Tue, 29 September 2015 08:57 By: John Watson
Tuning linux By: eml2raghu on Wed, 23 September 2015	11	6219	Tue, 29 September 2015 08:50 By: BlackSwan
Unable to interpret number of rows accessed during Full Table scan Oracle Enterprise Edition 11.2.0.4.0 on Linux By: orapratap on Wed, 23 September 2015	12	6430	Mon, 28 September 2015 06:43 By: Kevin Meade
Query does not error, but does not come back with a result set (as if it's in an endless loop) Oracle 11G running on UNIX AIX 6.1 O/S By: aft5425@anthem.com on Sun, 13 September 2015	20	6125	Wed, 16 September 2015 15:24 By: aft5425@anthem.com
Performance improvement required Oracle 10G By: saurabh.sha on Wed, 18 March 2015	10	19500	Fri, 11 September 2015 09:12 By: BlackSwan
Would it be useful to enable Hyper-Threading in Oracle 12.1.0.2 on Linux By: Michel Cadot on Tue, 08 September 2015	3	4279	Wed, 09 September 2015 13:57 By: John Watson
cost is more after releasing FTS on big table (partition table) 11g, 11.2.0.3, Window server By: ashishkumarmahanta80 on Tue, 08 September 2015	11	5335	Wed, 09 September 2015 01:35 By: John Watson
Query in active session for more than 2 hours 11.2.0.4 By: varunvir on Mon, 08 June 2015	5	4808	Sun, 06 September 2015 10:14 By: Kevin Meade
Huge difference between CPU Time and ELAPSED TIME and GV$SQL and high times on USER_IO_WAIT_TIME 11.2.0.4 on Linux By: orausern on Fri, 04 September 2015	6	5699	Fri, 04 September 2015 13:07 By: orausern
Oracle noforce view creates force view By: ram50958 on Tue, 25 August 2015	8	7030	Tue, 25 August 2015 11:13 By: Michel Cadot
Response time 12.1.0.1.0, solaris By: kapilavastu on Tue, 21 July 2015	5	4664	Mon, 24 August 2015 21:02 By: Kevin Meade
Interesting performance bottle neck issue Oracle 11g By: ram50958 on Wed, 19 August 2015	10	5605	Wed, 19 August 2015 10:09 By: BlackSwan
Please help for Resolving Issue for Explain plan as query taking long time for execution Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production By: msol25 on Sun, 09 August 2015	15	8429	Fri, 14 August 2015 12:27 By: Kevin Meade
statistics update 11.2.0.3 on Windows 2008 R2 By: sant_new1 on Thu, 13 August 2015	11	5383	Fri, 14 August 2015 12:07 By: BlackSwan
query with hundreds of bind variables Oracle database 11gR2 11.2.0.2.3 By: fplatel on Tue, 11 August 2015	2	3704	Tue, 11 August 2015 21:55 By: John Watson
Help to tune the query 11.2.0 By: grpatwari on Mon, 03 August 2015	11	6825	Fri, 07 August 2015 08:56 By: Kevin Meade
Cost Issue while using row_number() By: AJAYRAM on Thu, 06 August 2015	11	5989	Fri, 07 August 2015 04:48 By: cookiemonster
A way to identify the top sql other than AWR 11.2.0.4 on Linux By: orausern on Tue, 04 August 2015	5	4393	Tue, 04 August 2015 11:46 By: orausern
TKPROF output analysis windows 2012, oracle 12c By: muktha_22 on Wed, 22 July 2015	4	7338	Thu, 23 July 2015 01:39 By: Michel Cadot
Tuning data deletion that is taking long time 11.2.0.4 on Linux By: orausern on Sat, 11 July 2015	16	6427	Fri, 17 July 2015 05:59 By: orausern
Drop Unused columns 12.1.0.2.0,Linux x86_64 By: preet_kumar on Thu, 16 July 2015	3	3625	Thu, 16 July 2015 09:28 By: bpeasland
Help for tuning the sql Query 11.2.0.1 By: grpatwari on Wed, 15 July 2015	9	5129	Thu, 16 July 2015 03:22 By: cookiemonster