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
query issue oracle 10g By: prashant_ora on Wed, 02 March 2011	24	3768	Thu, 10 March 2011 21:15 By: Flyby
prev_hash_value not changing in v$session Oracle 10.2.0.4.0 on RHEL By: OraKaran on Thu, 10 March 2011	6	4240	Thu, 10 March 2011 09:04 By: OraKaran
Slow Performance Oracle 11g Windows2000 Server By: IMGS_Oracle on Fri, 18 September 2009	7	14244	Thu, 10 March 2011 07:57 By: martateixeira
Query tuning By: preethavinay on Mon, 21 February 2011	7	3254	Thu, 10 March 2011 07:36 By: marcodba
Stored Procedure is taking too long time to Execute. (2 Merged) Oracle 11.2 By: nanuvamsi on Fri, 04 March 2011	6	6052	Wed, 09 March 2011 12:36 By: BlackSwan
SQL Tuning Oracle 10.2.0.4 By: sathik on Tue, 22 February 2011	12	4814	Tue, 08 March 2011 07:43 By: marcodba
inserting data using FOR ALL 9i/10g By: ashish_sun123 on Sun, 06 March 2011	3	3618	Sun, 06 March 2011 17:35 By: Barbara Boehmer
performance tuning oracle 10g By: manidotkandan on Thu, 03 March 2011	7	3804	Fri, 04 March 2011 03:43 By: cookiemonster
Tunning the query and 4000-5000 parameter in IN clause By: forroughuse on Wed, 02 March 2011	12	4238	Thu, 03 March 2011 12:12 By: Littlefoot
Collecting stats oracle 10.2.0.1.0 - windows XP By: muktha_22 on Thu, 03 March 2011	1	1966	Thu, 03 March 2011 04:14 By: Michel Cadot
Dynamic SQL performance Oracle 10G By: uicmxz on Mon, 28 February 2011	1	2382	Mon, 28 February 2011 17:19 By: BlackSwan
faster processing of records needed: performance isue oracle 9i/10g/11g By: ashish_sun123 on Sat, 26 February 2011	2	2107	Mon, 28 February 2011 08:01 By: michael_bialik
Wrong REDO log file location Oracle 10G, Solaris 10 By: Tlg13team on Fri, 25 February 2011	4	4045	Fri, 25 February 2011 20:43 By: wkk1020
help to wrire the procedure oracle,10g,unix By: vickey_sagar1 on Fri, 25 February 2011	2	1856	Fri, 25 February 2011 15:10 By: cookiemonster
performance tuning general By: goldenshot2727 on Thu, 22 April 2010	4	2663	Fri, 25 February 2011 07:31 By: samosimo
Cursor_sharing setting in OLTP environment Oracle 9i R2, 10g R2 By: OraKaran on Tue, 22 February 2011	11	4847	Wed, 23 February 2011 08:13 By: OraKaran
Identify blocking sessions 11.1.0.7, Standard Edition By: John Watson on Mon, 21 February 2011	4	4606	Tue, 22 February 2011 03:49 By: John Watson
Slow Sql query Oracle 10.2.0.3 By: Its_me_ved on Thu, 17 February 2011	8	4966	Sun, 20 February 2011 06:00 By: Its_me_ved
full table scan 10.2.0.4 By: sathik123 on Sat, 19 February 2011	2	2086	Sun, 20 February 2011 00:26 By: Michel Cadot
Performance tuning of PL/SQL Procedure Oracle 10.2.0.5 By: Santrupta on Sun, 13 February 2011	10	4337	Thu, 17 February 2011 09:26 By: cookiemonster
Performance issue in jsp application Oracle 10.2.0.3,jsp By: Its_me_ved on Wed, 16 February 2011	2	2128	Wed, 16 February 2011 05:52 By: rleishman
Bulk Update Oracle 11g By: rcd70 on Tue, 15 February 2011	1	2561	Tue, 15 February 2011 18:54 By: BlackSwan
Optimal REDO log file size Oracle 10G, Solaris 10 By: Tlg13team on Thu, 10 February 2011	9	13070	Mon, 14 February 2011 03:44 By: Tlg13team
Performance tuning oracle 9i/10g/11g By: ashish_sun123 on Sun, 13 February 2011	6	1856	Sun, 13 February 2011 23:32 By: Michel Cadot
SELECT query Oracle,11.1.0.6,RHEL 5 By: arunb1982 on Fri, 11 February 2011	6	2341	Fri, 11 February 2011 12:44 By: Michel Cadot
Queries on PGA Settings and related Memory Management Oracle 9i on RHEL By: OraKaran on Fri, 11 February 2011	8	6991	Fri, 11 February 2011 11:14 By: OraKaran
Delete command running taking long time windows server 2003, oracle 11g DB By: pradies on Fri, 11 February 2011	9	4016	Fri, 11 February 2011 05:33 By: OraKaran
Application is slow when no of connections goes up Oracle Database 8.1.7 on Solaris By: rajan69 on Wed, 09 February 2011	2	2032	Wed, 09 February 2011 07:19 By: cookiemonster
How to Change execution plan of Currently Executing Statement? Oracle 10.2.4.0 on RHEL By: OraKaran on Tue, 08 February 2011	6	5163	Wed, 09 February 2011 03:21 By: OraKaran
data caching oraclge 10g By: gamba on Mon, 07 February 2011	7	2410	Tue, 08 February 2011 03:30 By: cookiemonster
Real time speed improvements & autotrace results. Oracle 9.2/Solaris By: Roachcoach on Fri, 04 February 2011	11	5183	Mon, 07 February 2011 09:43 By: Roachcoach
Update columns of one table using another table Oracle 10G By: priyankt on Sun, 06 February 2011	4	2589	Mon, 07 February 2011 02:08 By: priyankt
tunning oracle 10g/windows 2003 By: gxeon on Fri, 04 February 2011	5	2611	Fri, 04 February 2011 08:11 By: gxeon
Query Regarding Nested Loop Oracle 9i R2 on RHEL By: OraKaran on Thu, 27 January 2011	27	3931	Thu, 03 February 2011 06:34 By: Michel Cadot
No Snapshot Avaliable for AWR Report Oracle 11g, Windows 2003 By: pradies on Tue, 01 February 2011	8	13498	Wed, 02 February 2011 01:35 By: Michel Cadot
Problem queries of Materialized Views Oracle 9.2.0.8 , HP-UX B11.23 By: indrajit2002 on Fri, 28 January 2011	21	3384	Tue, 01 February 2011 11:36 By: Art Trifonov
Disable ADR By: renafi on Fri, 28 January 2011	2	2421	Sat, 29 January 2011 09:07 By: daverich
Index usage in order by clause on nullable column Oracle 10gR2 on RHEL By: OraKaran on Fri, 28 January 2011	5	6393	Fri, 28 January 2011 19:12 By: rleishman
Using a stats table instead of regular stats to get a plan 9i By: Kevin Meade on Thu, 27 January 2011	2	2200	Fri, 28 January 2011 02:48 By: Kevin Meade
Long Running Query Oracle 9,Unix By: gurukrishnan on Fri, 28 January 2011	1	1535	Fri, 28 January 2011 00:36 By: BlackSwan