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
Session Trace file Location - Oracle 12c oracle 12c Windows 2012 By: muthukrish104 on Mon, 04 December 2017	3	6639	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	9415	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	36930	Sat, 11 November 2017 00:59 By: shawaj
Hints Oracle 11g By: sathishsr on Wed, 25 October 2017	3	119182	Wed, 25 October 2017 07:53 By: BlackSwan
using sysdate from dual takes longer time By: manikandan23 on Tue, 17 October 2017	10	102753	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	1455655	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	75113	Wed, 20 September 2017 15:23 By: BlackSwan
Performace issue By: Genesys on Tue, 29 August 2017	6	20797	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	18288	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	10464	Tue, 15 August 2017 06:47 By: cookiemonster
Performance issue to Update data Oracle 11g By: newuser on Sat, 22 July 2017	7	9075	Mon, 24 July 2017 08:21 By: Bill B
insert query oracle 11g By: POGAKU_SANTHOSH on Thu, 20 July 2017	4	6565	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	13678	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	6919	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	6192	Sat, 01 July 2017 14:29 By: kamragulshan
create partitioning a table Linux, oracle 11.2 By: kar116 on Wed, 21 June 2017	7	7383	Tue, 27 June 2017 23:11 By: trantuananh24hg
Full table scan Oracle 11g By: samiran_cts on Tue, 19 July 2016	8	52379	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	7965	Wed, 21 June 2017 09:14 By: Michel Cadot
Gathering Statistics of Partitioned table Oracle 11g By: saipradyumn on Thu, 15 June 2017	20	12087	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	35764	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	21460	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	40264	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	37794	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	11896	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	6383	Mon, 24 April 2017 01:20 By: saipradyumn
Help Tuning slow query Oracle 12c By: James_s on Sat, 15 April 2017	6	10079	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	7456	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	14905	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	11336	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	7064	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	26334	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	7725	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	11086	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	9962	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	8114	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	6447	Fri, 20 January 2017 10:58 By: Michel Cadot
query Dead Slow oRACLE EBS R12 By: annu-agi on Fri, 20 January 2017	9	8346	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	8403	Thu, 19 January 2017 03:37 By: saipradyumn
SGA AND PGA TUNING Oracle 11.2 By: arin.oradba on Thu, 05 January 2017	20	25404	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	7313	Thu, 12 January 2017 10:53 By: skooman