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
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	2386	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	1129	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	17720	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	1850	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	2456	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	3026	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	1988	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	1450	Fri, 20 January 2017 10:58 By: Michel Cadot
query Dead Slow oRACLE EBS R12 By: annu-agi on Fri, 20 January 2017	9	1639	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	1642	Thu, 19 January 2017 03:37 By: saipradyumn
SGA AND PGA TUNING Oracle 11.2 By: arin.oradba on Thu, 05 January 2017	20	11238	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	1692	Thu, 12 January 2017 10:53 By: skooman
slow while inserting 10g By: arifmd1705 on Sun, 08 January 2017	4	1245	Mon, 09 January 2017 00:50 By: Michel Cadot
db file sequential read causing Performance Issues Oracle 12c By: subbaiyan on Fri, 06 January 2017	11	1681	Fri, 06 January 2017 07:47 By: BlackSwan
Union all tables with View and using the Index Oracle 11g By: preet_kumar on Fri, 23 December 2016	5	2820	Tue, 03 January 2017 03:48 By: cookiemonster
Identifying the parsing of the query (merged by MC) Oracle 11g By: saipradyumn on Tue, 27 December 2016	13	10761	Thu, 29 December 2016 06:36 By: Michel Cadot
Which index to choose local or global for attached scenario 10.2.0.3 db and AIX OS By: oratech10 on Mon, 19 December 2016	24	3589	Tue, 20 December 2016 21:19 By: John Watson
stale stats Oracle 12c By: srinivas.k2005 on Wed, 07 December 2016	18	46227	Tue, 13 December 2016 03:44 By: srinivas.k2005
Oracle Advance Queue consumes messages very slowly Oracle 10g, HP-UX/ia64 By: panos9 on Wed, 07 December 2016	2	1494	Wed, 07 December 2016 10:11 By: panos9
query Dead Slow 11g, 11.2.0.3.0 By: annu-agi on Wed, 07 December 2016	2	1450	Wed, 07 December 2016 09:06 By: John Watson
ORA-01555 error during expdp Oracle 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production, Windows Server 2008 R2 By: ashussain on Tue, 06 December 2016	4	1503	Wed, 07 December 2016 06:44 By: Michel Cadot
Materlized View Oracle 11 By: meetmallela on Sat, 03 December 2016	5	1572	Mon, 05 December 2016 02:59 By: cookiemonster
In-database archival Oracle 12C By: srinivas.k2005 on Thu, 01 December 2016	2	866	Thu, 01 December 2016 05:11 By: srinivas.k2005
java.sql.SQLTimeoutException: ORA-01013 Oracle 12c By: ajamitjain129@gmail.com on Thu, 20 October 2016	8	2217	Mon, 28 November 2016 17:24 By: ajamitjain129@gmail.com
Query Tuning Oracle 12c, Unix By: pstanand on Sun, 27 November 2016	1	1719	Mon, 28 November 2016 00:28 By: Michel Cadot
DATABASE TUNING PRINCIPLE AND DATABASE TROUBLESHOOTING. LINUX By: osama.mansoor on Wed, 26 October 2016	7	1522	Thu, 27 October 2016 03:05 By: Roachcoach
Cursor Optimization Oracle 11g By: abhijeetkumar.patil@cogni on Tue, 18 October 2016	8	1630	Mon, 24 October 2016 14:56 By: Kevin Meade
Exceeding maxi,um number of cursors 11g r2, linux By: qazims92 on Mon, 24 October 2016	7	1265	Mon, 24 October 2016 06:04 By: Michel Cadot
Slow Query Sql Oracle 10g By: rayrevan on Thu, 06 October 2016	14	5550	Thu, 13 October 2016 03:47 By: cookiemonster
Partitioning huge table 10g By: arifmd1705 on Sun, 09 October 2016	8	1451	Wed, 12 October 2016 02:42 By: gazzag
compare two procedures for performance Oracle 11.2.0.3 By: pointers on Fri, 30 September 2016	5	1125	Fri, 30 September 2016 04:40 By: Michel Cadot
Do we need to sit down with custom about determining which statspack snapshot to be used as baseline 11.2.0.4 SE, RHEL 7.1 By: juniordbanewbie on Tue, 27 September 2016	1	856	Tue, 27 September 2016 03:03 By: Michel Cadot
Database options to address work load increase By: caprikar on Mon, 19 September 2016	4	1218	Fri, 23 September 2016 08:41 By: bpeasland
Application is running slow time to time linux By: dbabertrand on Wed, 21 September 2016	4	1117	Fri, 23 September 2016 08:39 By: bpeasland
What should i do for tuning this query Oracle 10g By: rayrevan on Mon, 12 September 2016	16	2407	Tue, 20 September 2016 03:24 By: cookiemonster
MR (Metadata Repository) SQL caused poor performance Oracle Portal 10g, OID, IAS, Windows x86_64 By: trantuananh24hg on Wed, 14 September 2016	5	1752	Thu, 15 September 2016 22:54 By: trantuananh24hg
Improve query execution times oracle 12c By: gorants on Thu, 01 September 2016	4	1380	Sat, 03 September 2016 02:13 By: John Watson
Commit interval Oracle 11g, Unix By: ninan on Sat, 20 August 2016	11	1763	Thu, 01 September 2016 04:58 By: John Watson
How to Optimise this query Oracle 11G By: tarundas2016 on Mon, 22 August 2016	3	963	Thu, 01 September 2016 04:10 By: Kevin Meade
SQL Query - Just too big 11g By: nathan59 on Thu, 01 September 2016	16	1573	Thu, 01 September 2016 03:50 By: Kevin Meade

Pages (117): [ « ‹ 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 › »]

Goto Forum:

[ Syndicate this forum (XML) ] [

]

Legend

New Messages

No New messages

Locked (w/ unread messages) Locked

Locked

Moved to another forum

Current Time: Tue Nov 20 17:29:54 CST 2018