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
How to improve performance? (merged) Oracle Database 11g Release 11.2.0.1.0 - Production, WINDOWS 7 By: mokarem on Tue, 17 February 2015	15	6204	Thu, 26 February 2015 01:30 By: mokarem
Parallel direct path insert no quicker (merged 2 ) Oracle 11 By: brown_zzz on Tue, 24 February 2015	15	8372	Tue, 24 February 2015 08:39 By: Roachcoach
query to data dictionary tables taking long time 11.2.0.4 on Linux By: orausern on Tue, 24 February 2015	6	3882	Tue, 24 February 2015 04:32 By: John Watson
A oracle query causing 100% cpu utilization and blocking other sessions. oracle 11g,(11.2.0.3), Sun Solaris By: RamanaRocks on Sun, 22 February 2015	10	4950	Mon, 23 February 2015 04:00 By: John Watson
Execution plan oracle,11.2.0.2,RHEL By: Prathikesh on Thu, 12 February 2015	4	4214	Fri, 20 February 2015 16:31 By: Kevin Meade
Why does monitoring index fix performance? Oracle Database/Forms 11g, Windows 7 By: nait1234 on Sun, 15 February 2015	8	5748	Wed, 18 February 2015 15:04 By: Michel Cadot
Alert log file size can impact database performance 10g, 10.2.0.1, window server 2008 By: ashishkumarmahanta80 on Tue, 10 February 2015	3	3906	Tue, 10 February 2015 07:31 By: cookiemonster
Updating text string to mask address characters Oracle 11 By: brown_zzz on Thu, 05 February 2015	20	11546	Sun, 08 February 2015 23:42 By: FDAVIDOV
Oracle Database 11g 11.2.0.4.0 running slow Oracle Database 11g 11.2.0.4.0 By: DevilzAdvocate on Sat, 03 January 2015	14	17662	Sat, 07 February 2015 17:02 By: LNossov
update statement takes too long 11.2.0.1.0 By: OraFerro on Sun, 01 February 2015	16	10611	Sat, 07 February 2015 09:20 By: Kevin Meade
what is ** TRANSIENT: 12029568 oracle db 11.2.0.3 on solaris By: mshrkshl on Fri, 30 January 2015	2	5929	Thu, 05 February 2015 03:13 By: Michel Cadot
Explain plan oracle 10g windows 7 By: hdba on Thu, 29 January 2015	10	5513	Thu, 29 January 2015 06:26 By: hdba
What should be recommended percentage of memory to be used for oracle 11.2.0.3 Standard Edition, SLES SP 3 64 bit By: juniordbanewbie on Wed, 28 January 2015	6	6336	Thu, 29 January 2015 01:31 By: John Watson
AWR - licensing question By: piotrtal on Tue, 12 July 2011	28	22069	Mon, 19 January 2015 10:58 By: Kevin Meade
Updating compressed rows All with compression options By: Roachcoach on Tue, 13 January 2015	0	4881	Tue, 13 January 2015 08:22 By: Roachcoach
table lock in past Oracle 10.2.0.4.0, Aix 6.1 By: oradba123 on Mon, 12 January 2015	7	3851	Mon, 12 January 2015 13:42 By: BlackSwan
advice to rewrite a query with a bad desing By: jojoyk on Sat, 10 January 2015	9	5260	Sat, 10 January 2015 14:59 By: John Watson
redo buffer allocation retries not near 0, how do I set _log_parallelism_max 11.2.0.3 SE, SLES 11 SP3 By: juniordbanewbie on Thu, 08 January 2015	4	9948	Fri, 09 January 2015 00:34 By: Michel Cadot
max and min function taking lot of time oracle 10g By: vivek_rol on Tue, 06 January 2015	4	5859	Wed, 07 January 2015 22:45 By: Kevin Meade
How To Check Performace Tuning By: mastansky@gmail.com on Mon, 05 January 2015	8	7036	Tue, 06 January 2015 09:39 By: Kevin Meade
Optimizing Dynamic SQL Usage G12 By: FDAVIDOV on Mon, 29 December 2014	15	10372	Sat, 03 January 2015 10:30 By: FDAVIDOV
LNS wait on SENDREQ+ARCH wait on SENDREQ on ASYNC dataguard at primary database 11g, 11.2.0.3, solaris10 By: ashishkumarmahanta80 on Fri, 02 January 2015	3	9555	Fri, 02 January 2015 10:43 By: Michel Cadot
Optimisation of query sql ORacle 9i By: achraf_ef on Thu, 25 December 2014	35	11864	Mon, 29 December 2014 19:24 By: EdStevens
Monitor performance By: Banurs on Mon, 22 December 2014	11	13211	Sun, 28 December 2014 21:34 By: Banurs
Library cache (PIPES) 11g By: mrinouk on Fri, 19 December 2014	0	7446	Fri, 19 December 2014 08:10 By: mrinouk
Complete sql_text with DBMS_XPLAN.DISPLAY_CURSOR Oracle SE 11.2.0.4.4 on Linux Red Hat 6 By: Malakay79 on Fri, 19 December 2014	1	4445	Fri, 19 December 2014 03:14 By: John Watson
Remote query performance in BO reports Oracle 11g By: lavk on Mon, 15 December 2014	4	6659	Thu, 18 December 2014 09:48 By: BlackSwan
tuning basics Oracle 10g By: m.abdulhaq on Thu, 11 December 2014	3	5117	Fri, 12 December 2014 16:23 By: Kevin Meade
performance issue with sql query in UAT, But good in local By: raja.i on Fri, 05 December 2014	2	3656	Fri, 05 December 2014 03:45 By: cookiemonster
Has anyone ever seen BEGIN_OUTLINE_DATA alone change a plan 11.2.0.4 By: Roachcoach on Fri, 05 December 2014	0	4070	Fri, 05 December 2014 02:55 By: Roachcoach
Effective way to update a column to null (based on a condition) quickly in a huge 800 GB table Oracle 11.2.0.4 on Linux By: orausern on Thu, 04 December 2014	2	3116	Thu, 04 December 2014 13:05 By: orausern
INTERNAL_FUNCTION appears at explain plan 11g, 11.2.0.3, solaris10 By: ashishkumarmahanta80 on Thu, 13 November 2014	4	4204	Wed, 03 December 2014 00:02 By: ashishkumarmahanta80
AWR report oracle 12c - Windows server 2012 ( 1 2) By: muktha_22 on Tue, 18 November 2014	41	12057	Tue, 02 December 2014 15:29 By: Kevin Meade
SQL tuning 11g Enterprise Edition Release 11.2.0.3.0 By: rahul1982 on Fri, 28 November 2014	10	5262	Sun, 30 November 2014 12:00 By: Kevin Meade
Change from LOGGING to NOLOGGING for a table Oracle 11G R2 By: OlafCologne on Fri, 28 November 2014	1	2830	Fri, 28 November 2014 08:20 By: John Watson
Please help me to understand why the query works longer of server_A than on server_B Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bi By: ecivgamer on Wed, 26 November 2014	10	5743	Thu, 27 November 2014 06:22 By: ecivgamer
A question about execution plan Oracle 11.2.0.4. on Linux By: orausern on Tue, 25 November 2014	2	3404	Tue, 25 November 2014 12:52 By: orausern
Index vs Full table scan on sysdate 11.2.0.3,Linux X86_64 By: preet_kumar on Wed, 12 November 2014	7	4750	Tue, 25 November 2014 08:38 By: Andrey_R
Decide on Partitioning Column/Purge Approach Oracle 11g Release 2 By: azeem87 on Thu, 13 November 2014	9	5176	Fri, 14 November 2014 08:33 By: cookiemonster
Logging operation takes longer but no wait events Oracle 11.2.0.4 EE, Linux 64 bit By: d_seng on Mon, 01 September 2014	15	8177	Fri, 14 November 2014 05:54 By: d_seng