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
Can we delete specific execution plan in the db buffer for a statement 12.1.0.2 DB Linux 64 Bit By: juniordbanewbie on Mon, 28 August 2017	2	13651	Thu, 08 February 2018 02:36 By: juniordbanewbie
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	4137	Wed, 07 February 2018 03:23 By: daulat01
View Performance Tuning By: dancko on Tue, 30 January 2018	7	4514	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	6092	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	8283	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	7606	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	3	5516	Fri, 15 December 2017 07:06 By: JohnMax
Query taking 20 minutes in Production ORACLE 11g By: manoj12 on Fri, 17 November 2017	3	4793	Fri, 15 December 2017 03:26 By: cookiemonster
AWR Interpretation and analysis oracle 11gr2 on linux By: dba4oracle on Tue, 05 December 2017	7	4753	Fri, 08 December 2017 02:04 By: trantuananh24hg
DB Health checks oracle 11gr2 on linux By: dba4oracle on Tue, 05 December 2017	16	6300	Thu, 07 December 2017 05:43 By: dba4oracle
Running out of 64gb Temp Space 12c By: dbogey on Tue, 05 December 2017	2	3885	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	3500	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	5151	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	33277	Sat, 11 November 2017 00:59 By: shawaj
Hints Oracle 11g By: sathishsr on Wed, 25 October 2017	3	115647	Wed, 25 October 2017 07:53 By: BlackSwan
using sysdate from dual takes longer time By: manikandan23 on Tue, 17 October 2017	10	98248	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	85097	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	70019	Wed, 20 September 2017 15:23 By: BlackSwan
Performace issue By: Genesys on Tue, 29 August 2017	6	16894	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	14631	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	5518	Tue, 15 August 2017 06:47 By: cookiemonster
Performance issue to Update data Oracle 11g By: newuser on Sat, 22 July 2017	7	3701	Mon, 24 July 2017 08:21 By: Bill B
insert query oracle 11g By: POGAKU_SANTHOSH on Thu, 20 July 2017	4	3369	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	7631	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	3274	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	2908	Sat, 01 July 2017 14:29 By: kamragulshan
create partitioning a table Linux, oracle 11.2 By: kar116 on Wed, 21 June 2017	7	3423	Tue, 27 June 2017 23:11 By: trantuananh24hg
Full table scan Oracle 11g By: samiran_cts on Tue, 19 July 2016	8	8458	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	3630	Wed, 21 June 2017 09:14 By: Michel Cadot
Gathering Statistics of Partitioned table Oracle 11g By: saipradyumn on Thu, 15 June 2017	20	6675	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	6101	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	6155	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	6890	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	13556	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	6879	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	3102	Mon, 24 April 2017 01:20 By: saipradyumn
Help Tuning slow query Oracle 12c By: James_s on Sat, 15 April 2017	6	5770	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	3692	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	8583	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	5620	Mon, 27 February 2017 13:00 By: Caffeine+