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
Performance issue to Update data Oracle 11g By: newuser on Sat, 22 July 2017	7	4435	Mon, 24 July 2017 08:21 By: Bill B
insert query oracle 11g By: POGAKU_SANTHOSH on Thu, 20 July 2017	4	4072	Fri, 21 July 2017 01:41 By: John Watson
insert time is drastically reduced Oracle 12.1.0.2 ,Windows server 2012 64bit By: fabi88 on Mon, 03 July 2017	23	8683	Fri, 07 July 2017 22:53 By: BlackSwan
Why my function based did not use? Oracle 11gr2, any platform By: trantuananh24hg on Wed, 05 July 2017	7	3989	Wed, 05 July 2017 20:37 By: trantuananh24hg
SQL hint between view & table 11.2.0.4 on Solaris 10 By: kamragulshan on Wed, 28 June 2017	4	3685	Sat, 01 July 2017 14:29 By: kamragulshan
create partitioning a table Linux, oracle 11.2 By: kar116 on Wed, 21 June 2017	7	4377	Tue, 27 June 2017 23:11 By: trantuananh24hg
Full table scan Oracle 11g By: samiran_cts on Tue, 19 July 2016	8	49120	Mon, 26 June 2017 04:44 By: samiran_cts
While creating of M-View, lock the SYS.OBJ$ table SunOS 5.8 - 9.2.0.5.0 By: hitesh.bhatt on Tue, 20 June 2017	11	4569	Wed, 21 June 2017 09:14 By: Michel Cadot
Gathering Statistics of Partitioned table Oracle 11g By: saipradyumn on Thu, 15 June 2017	20	7941	Mon, 19 June 2017 05:22 By: saipradyumn
query issue with execute immediate 11.2.0.4 By: grpatwari on Thu, 01 June 2017	8	32634	Sun, 11 June 2017 22:59 By: trantuananh24hg
PLS-00201: identifier 'DBMS_AWR.ENABLE_AWR' must be declared Oracle 11.2.0.4 / Solaris 11 By: SamuelJk on Thu, 01 June 2017	3	18863	Thu, 01 June 2017 18:54 By: BlackSwan
Same query runs way better in 10g than in 12c Oracle 10g, 12c By: Asfakul on Thu, 18 May 2017	6	37180	Tue, 23 May 2017 14:35 By: LNossov
cannot see a-rows while querying dbms_xplan.display_cursor Oracle Database 10g Enterprise (RAC) Edition Release 10.2.0.4.0 - 64bit, LINUX By: Andrey_R on Thu, 03 May 2012	17	32585	Sun, 14 May 2017 07:18 By: BlackSwan
How to identify index type for partitioned tables Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production By: saipradyumn on Wed, 01 February 2017	16	7953	Mon, 24 April 2017 22:16 By: trantuananh24hg
Number of values in Not in list Oracle 11 g By: saipradyumn on Tue, 14 March 2017	6	3712	Mon, 24 April 2017 01:20 By: saipradyumn
Help Tuning slow query Oracle 12c By: James_s on Sat, 15 April 2017	6	7125	Tue, 18 April 2017 01:16 By: James_s
Query became very slow Oracle 11.2.0.3 By: lotusdeva on Wed, 08 February 2017	8	4362	Fri, 24 March 2017 02:54 By: Roachcoach
IM Column Store ( indexes,lob data) Oracle 12.1.0.2 By: chad_2000 on Sat, 18 February 2017	27	9570	Sat, 04 March 2017 02:33 By: LNossov
Oracle 12c -Query CPU Cost is very high Oracle 12c Release 1, Linux(Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production) By: anil_mk on Tue, 27 December 2016	5	7316	Mon, 27 February 2017 13:00 By: Caffeine+
Performance issue in oracle 10g database WINDOW SERVER 2008 By: NIJ1611 on Thu, 23 February 2017	4	4234	Thu, 23 February 2017 08:26 By: cookiemonster
Query is taking longer duration Oracle 11g 11.2.0.1.0 By: manoj12 on Fri, 10 February 2017	19	21993	Wed, 22 February 2017 16:03 By: mikek
BULK INSERT PERFORMANCE ON PROD Oracle 12c, RHEL 6 By: jesuisantony on Sat, 14 May 2016	7	4871	Mon, 30 January 2017 13:00 By: forums.sqltop
TOP_LEVEL_SQL_ID Oracle 11.2.0.4, Windows 2008 Server By: jesuisantony on Tue, 07 June 2016	8	6715	Fri, 27 January 2017 12:07 By: jesuisantony
Identify index key entry by rowid Oracle SE 11.2.0.4.0 By: michael_bialik on Tue, 17 January 2017	14	6116	Tue, 24 January 2017 04:51 By: Michel Cadot
Tuning update query - for more than 3 billion rows By: kurki on Fri, 20 January 2017	12	4784	Mon, 23 January 2017 03:41 By: Roachcoach
ora-01555 snapshot too old. Query executed 4000s 10g, 10.2.0.5, hp-unix By: ashishkumarmahanta80 on Tue, 07 June 2016	4	3967	Fri, 20 January 2017 10:58 By: Michel Cadot
query Dead Slow oRACLE EBS R12 By: annu-agi on Fri, 20 January 2017	9	5274	Fri, 20 January 2017 10:37 By: Michel Cadot
Avoiding the -ve execute to parse for MV refresh(highest parse calls total than execution totals) Oracle 11 By: saipradyumn on Wed, 18 January 2017	11	4939	Thu, 19 January 2017 03:37 By: saipradyumn
SGA AND PGA TUNING Oracle 11.2 By: arin.oradba on Thu, 05 January 2017	20	19889	Fri, 13 January 2017 01:57 By: arin.oradba
Need your help to optimize the Query Oracle 10g and Windows 12 By: mahatab on Tue, 15 November 2016	8	4143	Thu, 12 January 2017 10:53 By: skooman
slow while inserting 10g By: arifmd1705 on Sun, 08 January 2017	4	3401	Mon, 09 January 2017 00:50 By: Michel Cadot
db file sequential read causing Performance Issues Oracle 12c By: subbaiyan on Fri, 06 January 2017	11	6378	Fri, 06 January 2017 07:47 By: BlackSwan
Union all tables with View and using the Index Oracle 11g By: preet_kumar on Fri, 23 December 2016	5	35412	Tue, 03 January 2017 03:48 By: cookiemonster
Identifying the parsing of the query (merged by MC) Oracle 11g By: saipradyumn on Tue, 27 December 2016	13	48116	Thu, 29 December 2016 06:36 By: Michel Cadot
Which index to choose local or global for attached scenario 10.2.0.3 db and AIX OS By: oratech10 on Mon, 19 December 2016	24	27962	Tue, 20 December 2016 21:19 By: John Watson
stale stats Oracle 12c By: srinivas.k2005 on Wed, 07 December 2016	18	74053	Tue, 13 December 2016 03:44 By: srinivas.k2005
Oracle Advance Queue consumes messages very slowly Oracle 10g, HP-UX/ia64 By: panos9 on Wed, 07 December 2016	2	10726	Wed, 07 December 2016 10:11 By: panos9
query Dead Slow 11g, 11.2.0.3.0 By: annu-agi on Wed, 07 December 2016	2	10740	Wed, 07 December 2016 09:06 By: John Watson
ORA-01555 error during expdp Oracle 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production, Windows Server 2008 R2 By: ashussain on Tue, 06 December 2016	4	5783	Wed, 07 December 2016 06:44 By: Michel Cadot
Materlized View Oracle 11 By: meetmallela on Sat, 03 December 2016	5	4564	Mon, 05 December 2016 02:59 By: cookiemonster