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
sticky: How to tune SQL or Identify Performance Problem and Bottleneck By: Michel Cadot on Fri, 22 June 2007	7	79545	Sat, 07 March 2015 12:25 By: Kevin Meade
A case need to help clear Oracle 11.2.0.4, any platform By: trantuananh24hg on Wed, 21 March 2018	12	1739	Thu, 19 April 2018 05:03 By: John Watson
Remove Merge cartesian Join Oracle 10g By: pradies on Wed, 11 April 2018	1	521	Wed, 11 April 2018 08:46 By: John Watson
Finding downgraded sql Oracle 12.1.0.2 By: LarsFranzen on Thu, 05 April 2018	2	513	Thu, 05 April 2018 10:14 By: John Watson
Is there a way to find out activities due to redo logs 11.2.0.4 Windows 2008 R2 Data Center By: juniordbanewbie on Sun, 10 September 2017	15	45358	Wed, 04 April 2018 23:52 By: juniordbanewbie
Better query for max(date) per account in big table 12.1.0.2.0 By: nciteamo on Tue, 03 April 2018	15	817	Tue, 03 April 2018 08:10 By: Roachcoach
Fine Tune Big SQL Reporting Query By: dinavahi.saradhi@gmail.co on Fri, 30 March 2018	6	1018	Sun, 01 April 2018 16:18 By: dinavahi.saradhi@gmail.co
Direct path load insert take much longer than query inside it 12.1.0.2.0 By: nciteamo on Wed, 28 March 2018	4	998	Thu, 29 March 2018 08:33 By: Roachcoach
Incosistent Wait Event 12.1.0.2.0 By: nciteamo on Thu, 29 March 2018	6	523	Thu, 29 March 2018 05:06 By: Roachcoach
optimzer dynmic smpling By: elixir86 on Wed, 28 March 2018	9	773	Thu, 29 March 2018 02:34 By: John Watson
Oracle Golden gate- Compression tables Oracle 12CR2 By: srinivas.k2005 on Fri, 16 March 2018	4	1462	Thu, 29 March 2018 02:24 By: Roachcoach
Reorganizing index datafiles with tables in partition (merged) Oracle 10g 10.2.0.5, RHEL 6.2 By: reym21 on Mon, 26 March 2018	11	1555	Wed, 28 March 2018 08:34 By: JPBoileau
SQL Query performance Tuning RDBMS : 11.2.0.4.0 By: saketsingare on Thu, 08 March 2018	9	1392	Tue, 13 March 2018 09:21 By: msol25
Partitioning in table Oracle 11gr2 rhel By: dba4oracle on Fri, 23 February 2018	15	1542	Mon, 26 February 2018 09:55 By: Roachcoach
How long lock should be in order to take snapshot of locks 11.2.0.4, windows 2012 SE By: juniordbanewbie on Tue, 24 January 2017	6	1250	Thu, 08 February 2018 02:49 By: juniordbanewbie
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	8120	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	1214	Wed, 07 February 2018 03:23 By: daulat01
View Performance Tuning By: dancko on Tue, 30 January 2018	7	1053	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	2278	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	2268	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	2652	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	2018	Sun, 24 December 2017 03:09 By: SmithXu
Query taking 20 minutes in Production ORACLE 11g By: manoj12 on Fri, 17 November 2017	3	1511	Fri, 15 December 2017 03:26 By: cookiemonster
AWR Interpretation and analysis oracle 11gr2 on linux By: dba4oracle on Tue, 05 December 2017	7	1529	Fri, 08 December 2017 02:04 By: trantuananh24hg
DB Health checks oracle 11gr2 on linux By: dba4oracle on Tue, 05 December 2017	16	1801	Thu, 07 December 2017 05:43 By: dba4oracle
Running out of 64gb Temp Space 12c By: dbogey on Tue, 05 December 2017	2	846	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	869	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	1914	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	26116	Sat, 11 November 2017 00:59 By: shawaj
Hints Oracle 11g By: sathishsr on Wed, 25 October 2017	3	92519	Wed, 25 October 2017 07:53 By: BlackSwan
using sysdate from dual takes longer time By: manikandan23 on Tue, 17 October 2017	10	84299	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	62799	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	52027	Wed, 20 September 2017 15:23 By: BlackSwan
Performace issue By: Genesys on Tue, 29 August 2017	6	11698	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	9745	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	1700	Tue, 15 August 2017 06:47 By: cookiemonster
Performance issue to Update data Oracle 11g By: newuser on Sat, 22 July 2017	7	1242	Mon, 24 July 2017 08:21 By: Bill B
insert query oracle 11g By: POGAKU_SANTHOSH on Thu, 20 July 2017	4	1043	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	2310	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	996	Wed, 05 July 2017 20:37 By: trantuananh24hg