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
Queries "break" after automatic statistic gathering. 11.2.0.3 / CentOS Linux By: ThomasG on Fri, 01 August 2014	4	6779	Fri, 01 August 2014 13:34 By: Lalit Kumar B
gather table stats 11.2.0.3, sun sol 10 By: AviatoR on Wed, 30 July 2014	8	8644	Thu, 31 July 2014 19:31 By: BlackSwan
How to remove left join and ON JOIN from query and use better things in place of that 11i ( 1 2) By: nishantranjan00787 on Mon, 21 July 2014	51	22305	Thu, 31 July 2014 05:50 By: John Watson
After Table analyze, the number of blocks goes Down Oracle 11gR2 By: hitesh.bhatt on Thu, 24 July 2014	7	6836	Wed, 30 July 2014 04:14 By: hitesh.bhatt
Partitioning on a VARCHAR2 column 11g By: mafoe on Mon, 28 July 2014	6	8306	Tue, 29 July 2014 04:29 By: Roachcoach
Performance issue 10.2.0.5.0 By: ramanaapps on Fri, 25 July 2014	16	12446	Sat, 26 July 2014 08:55 By: Kevin Meade
A question about SPM 11.2.0.4 on Linux By: orausern on Thu, 24 July 2014	2	5404	Thu, 24 July 2014 12:48 By: orausern
performance lag of the quey 11g By: andrewscharles89 on Tue, 01 July 2014	17	10326	Thu, 24 July 2014 11:36 By: LNossov
Performance Tuning 11g By: andrewscharles89 on Thu, 10 July 2014	11	8544	Tue, 22 July 2014 08:20 By: michael_bialik
How to revert the work done by accept_sql_profile procedure & Issues to watch out with SPM (merged) Oracle 11.2.0.4 on Linux By: orausern on Mon, 14 July 2014	20	15696	Wed, 16 July 2014 11:16 By: orausern
Oracle 11g on VMWARE Oracle 11g, Windows Server 2008 By: josephmaan on Wed, 16 July 2014	3	5608	Wed, 16 July 2014 07:18 By: Michel Cadot
Query Performance Oracle 11g By: rohan10k on Tue, 17 June 2014	3	5907	Sat, 12 July 2014 02:09 By: Kevin Meade
How about performance using index on the column which is using in WHERE and SET clause. Oracle 11g By: ramya_162 on Wed, 18 June 2014	3	6607	Sat, 12 July 2014 02:03 By: Kevin Meade
AWR and ASH report analyze Oracle 10g,11g,Linux By: Database admin on Mon, 07 July 2014	13	9365	Mon, 07 July 2014 10:46 By: Lalit Kumar B
Shameless plug By: rleishman on Sat, 05 July 2014	5	8226	Sun, 06 July 2014 07:48 By: rleishman
I/O calibration By: John Watson on Wed, 02 July 2014	9	7803	Fri, 04 July 2014 06:34 By: Roachcoach
Table Shrink Space and Performance 11g Standard Edition,Linux x86_64 By: preet_kumar on Mon, 16 June 2014	11	8742	Tue, 01 July 2014 08:10 By: martens_b2014
UNDO Setup Issue By: VIP2013 on Sat, 21 June 2014	9	11426	Sun, 29 June 2014 04:32 By: Flyby
Debug Procedure Oracle 11g,Win7 32 bit By: Xandot on Thu, 26 June 2014	7	6881	Thu, 26 June 2014 09:10 By: Xandot
Materialized View- Delay refresh By: preethi_s0 on Tue, 24 June 2014	7	7763	Tue, 24 June 2014 07:44 By: Michel Cadot
Calculating schema statistics during a huge 10 hour batch job Oracle 11gR2(11.2.0.4) on Linux By: orausern on Thu, 19 June 2014	7	7387	Fri, 20 June 2014 01:13 By: Michel Cadot
DBA_HIST_SEG_STAT view 11.2.0.3 By: rishwinger on Mon, 06 January 2014	7	16776	Fri, 20 June 2014 00:50 By: Michel Cadot
SQL performance tunning :- DBMS_STATS procedure errored out Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production By: msinha8 on Thu, 12 June 2014	22	13611	Tue, 17 June 2014 02:52 By: Michel Cadot
General question on dbms_stats 11g By: kiranrathodkr916 on Sat, 14 June 2014	2	5802	Sat, 14 June 2014 10:43 By: Lalit Kumar B
how to troubleshoot slow running queries? 11g By: kiranrathodkr916 on Thu, 12 June 2014	11	8659	Sat, 14 June 2014 02:04 By: John Watson
Indexing and Tuning Oracle 10g By: m.abdulhaq on Thu, 29 May 2014	5	7520	Tue, 10 June 2014 20:33 By: Kevin Meade
Table with 40 million records problem By: viba1987 on Fri, 30 May 2014	4	6261	Tue, 10 June 2014 20:21 By: Kevin Meade
Staging table without indexes, slow queries Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 By: rkhatiwala on Wed, 04 June 2014	4	13852	Thu, 05 June 2014 15:05 By: BlackSwan
SQL performance tunning Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production By: msinha8 on Thu, 29 May 2014	21	12195	Thu, 05 June 2014 08:56 By: msinha8
SQL id shows multiple plan table 11g, 11.2.0.3, sun-solaris10 By: ashishkumarmahanta80 on Tue, 27 May 2014	5	6564	Tue, 27 May 2014 02:47 By: Roachcoach
monitoring 11.2.0.3 By: guru_karnam on Thu, 22 May 2014	3	5510	Fri, 23 May 2014 23:56 By: Michel Cadot
Direct Path Wait event Tune Direct path write temp, Direct path read, Direct path read temp By: guru_karnam on Thu, 22 May 2014	6	10010	Fri, 23 May 2014 20:27 By: Kevin Meade
what are the disadvan of using incremental stats in oracle 11g? By: ashwanth77 on Fri, 09 May 2014	5	7946	Thu, 22 May 2014 05:26 By: ashwanth77
dba_hist_snapshot vs dba_hist_active_sess_history oracle 11g rel 2 (11.2.0.3.0) By: ind9 on Tue, 20 May 2014	1	6609	Tue, 20 May 2014 07:30 By: BlackSwan
% cpu used by a session By: Malakay79 on Sat, 17 May 2014	2	6090	Sat, 17 May 2014 11:00 By: Michel Cadot
Procedure runs slow whereas 11.2.0.1 By: guru_karnam on Wed, 14 May 2014	7	6959	Thu, 15 May 2014 09:43 By: guru_karnam
LOV taking long time By: mist598 on Wed, 14 May 2014	29	17487	Thu, 15 May 2014 00:40 By: Lalit Kumar B
database performance issue oracle 11gr2 By: guddu_12 on Tue, 13 May 2014	3	18114	Tue, 13 May 2014 21:40 By: BlackSwan
Please help me execution plan is looking bad Oracle 11g By: ramya_162 on Mon, 12 May 2014	23	12083	Tue, 13 May 2014 10:50 By: ramya_162
SQL Query too slow 11g, Windows By: aldy on Thu, 08 May 2014	20	12591	Sat, 10 May 2014 10:21 By: Kevin Meade

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

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 28 03:22:22 CDT 2024