Home » RDBMS Server » Performance Tuning
Please read the OraFAQ Forum Guide before posting.
Please contribute good answers to the wiki.

    Replies Views Last message
  scripts of Oracle SQL Performance Tuning and Optimization
Oracle
By: big on Thu, 25 October 2018
2 7664 Thu, 25 October 2018 06:36
By: big
  Is there a need to install os monitoring tools since gv$osstat already has the os statistics
12.2.0.1 Windows 2016
By: juniordbanewbie on Wed, 17 October 2018
2 8489 Wed, 17 October 2018 02:43
By: juniordbanewbie
  No more data to read from socket
No more data to read from socket (Oracle error 17410 )
By: saipradyumn on Sat, 22 September 2018
14 13468 Mon, 15 October 2018 05:04
By: saipradyumn
  How do I know who are running the long running ops sql?
12.1.0.2 RH7
By: juniordbanewbie on Tue, 02 October 2018
1 7113 Tue, 02 October 2018 02:45
By: Michel Cadot
  Transaction Isolation Level
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
By: saipradyumn on Fri, 28 September 2018
2 6126 Sat, 29 September 2018 06:31
By: saipradyumn
  Pleaese clear my doubt about View and synonym having same name
UNIX 11.35
By: Akmmhto on Wed, 26 September 2018
6 8060 Fri, 28 September 2018 12:07
By: Akmmhto
  Index on order by column
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
By: saipradyumn on Sat, 15 September 2018
9 9147 Tue, 18 September 2018 02:53
By: saipradyumn
  Range Scan Index
Oracle 11g, any platforms
By: trantuananh24hg on Tue, 28 August 2018
18 11010 Thu, 30 August 2018 09:34
By: JPBoileau
  Exporting AWR data in a csv file
RHEL 6 64-bit, Oracle 12.2.0.1
By: Nagesh1985 on Tue, 28 August 2018
8 8329 Thu, 30 August 2018 02:22
By: Roachcoach
  Appropriate join to the desired output
Oracle 11.2
By: senmng on Fri, 27 July 2018
3 7926 Tue, 28 August 2018 02:47
By: jennifer roche
  performance tuning
Oracle rdbms 11gR2 and #statspack
By: alanm on Mon, 30 July 2018
3 7125 Mon, 30 July 2018 04:37
By: Roachcoach
  Sql query to get Max,min and max-1 row from a table
Oracle 11.2
By: senmng on Sun, 22 July 2018
2 5907 Sun, 22 July 2018 09:36
By: senmng
  please help for sql query to find out total number of concurrent connections in database
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
By: msol25 on Thu, 05 July 2018
6 8006 Thu, 05 July 2018 06:57
By: msol25
icon5.gif Oracle Text index column when searching multiple tables
12.1.0.2.0
By: LFranz on Fri, 27 April 2018
7 12523 Thu, 28 June 2018 03:12
By: Barbara Boehmer
  Encountering issues with join condition in stored procedure
Oracle 11.2
By: senmng on Fri, 22 June 2018
4 7134 Sat, 23 June 2018 18:01
By: BlackSwan
  join is slow
Oracle12g
By: Buchas on Fri, 25 May 2018
2 6206 Wed, 20 June 2018 05:22
By: michael_bialik
  Used Left Join - Query goes for Full Table scan
Oracle 11.2
By: saravanantgu on Fri, 25 May 2018
7 8368 Wed, 20 June 2018 02:47
By: John Watson
  Wrong plan chosen by optimizer
Oracle Database 11g Release 11.2.0.1.0 - 64bit Production OEL 6
By: Andrey_R on Wed, 30 May 2018
11 6588 Wed, 30 May 2018 09:32
By: Andrey_R
  Wrong plan chosen by optimizer
Oracle 11.1.0.6 , OEL 6
By: Andrey_R on Tue, 22 May 2018
14 7059 Wed, 23 May 2018 08:03
By: Andrey_R
  Distinct query taking long time to run
Oracle 11.2,Linux 6
By: senmng on Thu, 10 May 2018
7 6514 Tue, 22 May 2018 14:17
By: senmng
  ORA-07445: exception encountered: core dump [audplsfailure()+54]
Oracle DB 11.2.0.4 OS: Redhat Linux 6.9 64 Bit
By: suhaspdba on Tue, 15 May 2018
4 14858 Tue, 15 May 2018 11:25
By: Michel Cadot
  Stored procedure taking long time to run
Oracle 11.2, Linux v6
By: senmng on Thu, 03 May 2018
4 6040 Tue, 08 May 2018 10:17
By: BlackSwan
  Update Query Performance
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0
By: kangula17 on Wed, 02 May 2018
2 4971 Thu, 03 May 2018 00:49
By: John Watson
  A case need to help clear
Oracle 11.2.0.4, any platform
By: trantuananh24hg on Wed, 21 March 2018
12 7809 Thu, 19 April 2018 05:03
By: John Watson
  Remove Merge cartesian Join
Oracle 10g
By: pradies on Wed, 11 April 2018
1 4676 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 4624 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 64238 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 6826 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 5895 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 4914 Thu, 29 March 2018 08:33
By: Roachcoach
  Incosistent Wait Event
12.1.0.2.0
By: nciteamo on Thu, 29 March 2018
6 4217 Thu, 29 March 2018 05:06
By: Roachcoach
  optimzer dynmic smpling
By: elixir86 on Wed, 28 March 2018
9 5505 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 5599 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 5442 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 6884 Tue, 13 March 2018 09:21
By: msol25
  Partitioning in table
Oracle 11gr2 rhel
By: dba4oracle on Fri, 23 February 2018
15 7585 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 5150 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 13593 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 4084 Wed, 07 February 2018 03:23
By: daulat01
  View Performance Tuning
By: dancko on Tue, 30 January 2018
7 4458 Tue, 30 January 2018 10:34
By: cookiemonster
Goto Forum:
  
Legend New Messages New Messages   No New messages No New messages   Locked (w/ unread messages) Locked (w/ unread messages)   Locked Locked   Moved to another forum Moved to another forum

Current Time: Mon Jan 18 21:05:53 CST 2021