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
stale stats Oracle 12c By: srinivas.k2005 on Wed, 07 December 2016	18	74601	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	11394	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	11099	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	6392	Wed, 07 December 2016 06:44 By: Michel Cadot
Materlized View Oracle 11 By: meetmallela on Sat, 03 December 2016	5	4991	Mon, 05 December 2016 02:59 By: cookiemonster
In-database archival Oracle 12C By: srinivas.k2005 on Thu, 01 December 2016	2	3206	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	7038	Mon, 28 November 2016 17:24 By: ajamitjain129@gmail.com
Query Tuning Oracle 12c, Unix By: pstanand on Sun, 27 November 2016	1	12207	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	4767	Thu, 27 October 2016 03:05 By: Roachcoach
Cursor Optimization Oracle 11g By: abhijeetkumar.patil@cogni on Tue, 18 October 2016	8	4728	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	3814	Mon, 24 October 2016 06:04 By: Michel Cadot
Slow Query Sql Oracle 10g By: rayrevan on Thu, 06 October 2016	14	8666	Thu, 13 October 2016 03:47 By: cookiemonster
Partitioning huge table 10g By: arifmd1705 on Sun, 09 October 2016	8	4222	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	3761	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	3438	Tue, 27 September 2016 03:03 By: Michel Cadot
Database options to address work load increase By: caprikar on Mon, 19 September 2016	4	3837	Fri, 23 September 2016 08:41 By: bpeasland
Application is running slow time to time linux By: dbabertrand on Wed, 21 September 2016	4	3658	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	6263	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	5569	Thu, 15 September 2016 22:54 By: trantuananh24hg
Improve query execution times oracle 12c By: gorants on Thu, 01 September 2016	4	4136	Sat, 03 September 2016 02:13 By: John Watson
Commit interval Oracle 11g, Unix By: ninan on Sat, 20 August 2016	11	5027	Thu, 01 September 2016 04:58 By: John Watson
How to Optimise this query Oracle 11G By: tarundas2016 on Mon, 22 August 2016	3	3315	Thu, 01 September 2016 04:10 By: Kevin Meade
SQL Query - Just too big 11g By: nathan59 on Thu, 01 September 2016	16	5440	Thu, 01 September 2016 03:50 By: Kevin Meade
Driving site hint on a single remote table OEL 6.5,Oracle 10g By: swas_recall on Thu, 01 September 2016	7	6566	Thu, 01 September 2016 03:35 By: Michel Cadot
Tuning Multiple Not Exists Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production By: ricky_s on Mon, 22 August 2016	10	6819	Fri, 26 August 2016 01:00 By: Michel Cadot
improve performance using partitioning oracle 11g By: tarundas2016 on Mon, 22 August 2016	3	3472	Tue, 23 August 2016 02:39 By: Roachcoach
slow running sql 10g By: arifmd1705 on Mon, 08 August 2016	16	5892	Sat, 13 August 2016 23:22 By: arifmd1705
server session exceed By: rameshrk0206@gmail.com on Mon, 08 August 2016	1	2753	Mon, 08 August 2016 01:30 By: Michel Cadot
Data related to DB Metrics for a period Oracle 11.2.0.4 on Linux By: orausern on Thu, 04 August 2016	5	3430	Thu, 04 August 2016 03:52 By: John Watson
Why rownum is not used in the query By: samiran_cts on Tue, 02 August 2016	13	8059	Wed, 03 August 2016 08:14 By: cookiemonster
Approach for Oracle Profiles to tune queries Oracle 11.2.0.4 on LInux By: orausern on Tue, 02 August 2016	4	4169	Tue, 02 August 2016 04:19 By: orausern
consecutive executions Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production By: bibhuti037 on Wed, 27 July 2016	7	5912	Thu, 28 July 2016 02:24 By: pablolee
Compare spatial and attributive query Oracle Locator 11g By: moehre on Tue, 05 July 2016	11	7057	Wed, 13 July 2016 03:55 By: Barbara Boehmer
Whast is connect$_by$_pump$ in explain plan Oracle Database 11g Release 11.2.0.3.0 - 64bit By: javed.khan on Tue, 28 June 2016	1	3782	Tue, 28 June 2016 23:35 By: javed.khan
Performance worse for given workflow query 11i By: nishant87 on Wed, 22 June 2016	16	5060	Wed, 22 June 2016 09:48 By: John Watson
How to make sure no archivelog being generated for a particular table 11.2.0.2 SE, windows 2008 r2 By: juniordbanewbie on Tue, 14 June 2016	10	4238	Tue, 14 June 2016 09:37 By: Michel Cadot
Is there a way to find out a killed session associated sql 11.2.0.2,SE windows 2008 r2 By: juniordbanewbie on Tue, 14 June 2016	6	4110	Tue, 14 June 2016 06:11 By: juniordbanewbie
Performance degrade after migration from 11g exadata to 12c 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production By: knw15pwr on Tue, 07 June 2016	2	3415	Wed, 08 June 2016 14:42 By: knw15pwr
LEFT OUTER JOIN of Large Tables - Performance issue ORACLE, 12.1.0.2.0, WINDOWS 10 By: anil_mk on Thu, 28 April 2016	8	13084	Tue, 07 June 2016 08:15 By: Kevin Meade
count(*) anomaly DB 12.1.0.2, Windows 10 By: John Watson on Sat, 28 May 2016	5	3932	Sat, 28 May 2016 12:24 By: John Watson

Pages (119): [ « ‹ 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: Sat Sep 30 22:24:09 CDT 2023