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
Move unused partitioned from one tablespace to another tablespace. Oracle 12c (12.1.0.1.0)- Unix By: daulat01 on Thu, 04 January 2018	2	2420	Wed, 07 February 2018 03:23 By: daulat01
View Performance Tuning By: dancko on Tue, 30 January 2018	7	2330	Tue, 30 January 2018 10:34 By: cookiemonster
Is there a equivalent of delete nologging operations 11.2.0.4 SE, Windows 2012 r2 Datacenter By: juniordbanewbie on Tue, 19 September 2017	4	3707	Thu, 25 January 2018 18:13 By: juniordbanewbie
Driving Table is not given more speed result Oracle 11g By: venkat_kayal on Thu, 18 January 2018	15	4612	Thu, 25 January 2018 03:46 By: venkat_kayal
Non-value Added Indexes Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production By: saipradyumn on Tue, 02 January 2018	12	4720	Mon, 15 January 2018 08:15 By: msol25
Consuming a more time (low performance) Oracle8i Enterprise Edition Release 8.1.7.0.0, for 32-bit Windows By: shawaj on Fri, 17 November 2017	4	3244	Sun, 24 December 2017 03:09 By: SmithXu
Query taking 20 minutes in Production ORACLE 11g By: manoj12 on Fri, 17 November 2017	3	2671	Fri, 15 December 2017 03:26 By: cookiemonster
AWR Interpretation and analysis oracle 11gr2 on linux By: dba4oracle on Tue, 05 December 2017	7	2760	Fri, 08 December 2017 02:04 By: trantuananh24hg
DB Health checks oracle 11gr2 on linux By: dba4oracle on Tue, 05 December 2017	16	3640	Thu, 07 December 2017 05:43 By: dba4oracle
Running out of 64gb Temp Space 12c By: dbogey on Tue, 05 December 2017	2	1828	Tue, 05 December 2017 15:05 By: BlackSwan
Session Trace file Location - Oracle 12c oracle 12c Windows 2012 By: muthukrish104 on Mon, 04 December 2017	3	1760	Mon, 04 December 2017 03:24 By: muthukrish104
Undo tablespace(monitoring and avoiding ORA-01555 oracle 11grw on linux By: dba4oracle on Mon, 30 October 2017	8	3007	Sat, 11 November 2017 08:02 By: trantuananh24hg
Performance Issue Oracle8i Enterprise Edition Release 8.1.7.0.0,TNS for 32-bit Windows By: shawaj on Thu, 09 November 2017	6	29923	Sat, 11 November 2017 00:59 By: shawaj
Hints Oracle 11g By: sathishsr on Wed, 25 October 2017	3	107586	Wed, 25 October 2017 07:53 By: BlackSwan
using sysdate from dual takes longer time By: manikandan23 on Tue, 17 October 2017	10	91677	Wed, 18 October 2017 09:42 By: manikandan23
Statspack snap shot at level 7 is slow 11.2.0.4. windows 2012 r2 Datacentre By: juniordbanewbie on Wed, 04 October 2017	15	75811	Fri, 06 October 2017 15:08 By: John Watson
How to partition unpartitioned existing table 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production By: jokrasa on Wed, 20 September 2017	3	63209	Wed, 20 September 2017 15:23 By: BlackSwan
Performace issue By: Genesys on Tue, 29 August 2017	6	14103	Fri, 08 September 2017 04:12 By: Clanner
sql need tuning - high cpu_time and buffer gets oracle 12cR1 EE RAC, RHEL 6.5 By: gniewko on Wed, 23 August 2017	5	11898	Thu, 24 August 2017 09:34 By: Alien
Join on index and adding default_where Forms 11G By: Ilonke on Tue, 15 August 2017	14	3085	Tue, 15 August 2017 06:47 By: cookiemonster
Performance issue to Update data Oracle 11g By: newuser on Sat, 22 July 2017	7	1823	Mon, 24 July 2017 08:21 By: Bill B
insert query oracle 11g By: POGAKU_SANTHOSH on Thu, 20 July 2017	4	1498	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	4074	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	1429	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	1332	Sat, 01 July 2017 14:29 By: kamragulshan
create partitioning a table Linux, oracle 11.2 By: kar116 on Wed, 21 June 2017	7	1543	Tue, 27 June 2017 23:11 By: trantuananh24hg
Full table scan Oracle 11g By: samiran_cts on Tue, 19 July 2016	8	4902	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	1566	Wed, 21 June 2017 09:14 By: Michel Cadot
Gathering Statistics of Partitioned table Oracle 11g By: saipradyumn on Thu, 15 June 2017	20	3470	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	2978	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	3440	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	3257	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	8986	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	3231	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	1399	Mon, 24 April 2017 01:20 By: saipradyumn
Help Tuning slow query Oracle 12c By: James_s on Sat, 15 April 2017	7	1899	Tue, 18 April 2017 01:17 By: James_s
Query became very slow Oracle 11.2.0.3 By: lotusdeva on Wed, 08 February 2017	8	1787	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	4033	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	2218	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	1057	Thu, 23 February 2017 08:26 By: cookiemonster