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
Need your help in tuning the query 11.5.10.2 By: nishantranjan87 on Wed, 16 October 2013	28	6300	Fri, 18 October 2013 05:21 By: Lalit Kumar B
Help with 12c vs 10.2g 12c By: hesaigo999ca on Tue, 15 October 2013	19	7682	Thu, 17 October 2013 10:39 By: cookiemonster
Insert data fast on table Oracle 11.2 RAC By: nehaverma on Tue, 15 October 2013	14	2666	Tue, 15 October 2013 08:59 By: Lalit Kumar B
database links question oracle 11g By: manoj12 on Mon, 14 October 2013	6	2324	Mon, 14 October 2013 11:42 By: BlackSwan
Force the optimizer to consider all join permutations 11.2.0.4 RHEL By: Roachcoach on Mon, 14 October 2013	5	2033	Mon, 14 October 2013 09:45 By: Roachcoach
Please help me to tune this procedure Oracle 11g By: ajaykumarkona on Fri, 11 October 2013	25	3991	Mon, 14 October 2013 06:48 By: pablolee
performance - index creation on text column Oracle 10g,Solaris By: prejib on Thu, 10 October 2013	9	2330	Fri, 11 October 2013 00:46 By: prejib
about increasing performance speed of slow running package Oracle 11.2.0.2.0, Oracle Enterprise Linux -5 By: 8939513598$ on Fri, 04 October 2013	7	2023	Mon, 07 October 2013 02:19 By: 8939513598$
MEMORY_TARGET error Oracle 11.2.0.1.0, Oracle Enterprise Linux -5 By: 8939513598$ on Fri, 04 October 2013	2	1549	Fri, 04 October 2013 11:02 By: Michel Cadot
How to configure SGA_MAX_SIZE parameter Oracle Enterprise 11.2.0.3, RH Enterprise Linux 5 By: rcct on Tue, 24 September 2013	7	3254	Fri, 04 October 2013 11:01 By: Michel Cadot
Please advise on configuring memory Oracle 11.1, Windows Server 2008 R2 By: jxh461 on Wed, 18 September 2013	23	3695	Fri, 04 October 2013 02:24 By: Michel Cadot
Need help to tune this query Oracle 11g By: ramya_162 on Wed, 28 August 2013	10	2800	Fri, 04 October 2013 01:50 By: 8939513598$
Buffer Busy Wait DBMS_ALERT_INFO Oracle DB 11.2.0.3, Standard 64-bit, Windows 2008 R2 By: Flyby on Wed, 02 October 2013	7	2862	Thu, 03 October 2013 04:19 By: 8939513598$
Big table joining Oracle 10g By: sss111ind on Tue, 01 October 2013	4	1983	Tue, 01 October 2013 10:19 By: BlackSwan
Question for List partition By: dba10 on Mon, 30 September 2013	2	1371	Mon, 30 September 2013 17:36 By: Lalit Kumar B
ISSUE IN THE PERFORMANCE ORACLE 10G By: db_learner on Fri, 27 September 2013	5	1943	Sun, 29 September 2013 09:14 By: BlackSwan
pagging oracle 11.2.0.3 sun solaris 10.5 By: guddu_12 on Thu, 26 September 2013	3	1857	Thu, 26 September 2013 16:28 By: rleishman
Split Data separated by comma ; then create a collection with data mapped from other columns By: abhenav123 on Wed, 25 September 2013	4	1918	Wed, 25 September 2013 07:45 By: abhenav123
Select query taking time even after using PARALLEL hint Oracle 11.2.0.3,Linux x86-64 By: arunshrish on Wed, 25 September 2013	2	1797	Wed, 25 September 2013 04:24 By: arunshrish
Please help me to tune this query By: ramya_162 on Tue, 24 September 2013	2	2041	Tue, 24 September 2013 13:29 By: John Watson
Howto avoid virtual circuit wait as application developer? 11gR2 (11.2.0.3) By: bet32978 on Wed, 07 August 2013	4	15393	Thu, 19 September 2013 08:28 By: bet32978
snapshot skipped in between the scheduled time (AWR) 11g, 11.2.0.1, window server 2008 By: ishika_20 on Wed, 11 September 2013	7	8225	Sat, 14 September 2013 10:48 By: trantuananh24hg
Need your help in tuning the query 11i By: nishant87 on Thu, 12 September 2013	22	3673	Fri, 13 September 2013 00:00 By: Kevin Meade
Call from specified Machine not assigned to Database resource consumer. Release 11.2.0.3.0 - 64bit By: VIP2013 on Fri, 06 September 2013	9	3953	Sun, 08 September 2013 00:45 By: VIP2013
Database crash Due To CPU Starvation 11.2.0.3 Version Oracle. By: VIP2013 on Sun, 01 September 2013	9	2913	Wed, 04 September 2013 14:04 By: VIP2013
Parallel hints with cursor queries Oracle 11.2.0.2.0, Windows XP By: a_oracle on Wed, 28 August 2013	13	7667	Sun, 01 September 2013 13:56 By: Lalit Kumar B
Performance issue with a query using DB links am on Oracle 11.2.0.3 on Solaris 10 on one database and oracle 10.2.0.4 on Solaris 10 on another database By: orausern on Wed, 28 August 2013	18	4591	Fri, 30 August 2013 13:06 By: orausern
Please help on this Oracle 11g By: ajaykumarkona on Tue, 06 August 2013	4	1994	Fri, 30 August 2013 02:54 By: pablolee
Impact of RAM to oracle 11gR2 on HP-UX IA64 By: yipchunyu on Tue, 27 August 2013	11	3174	Thu, 29 August 2013 10:06 By: yipchunyu
NOWAIT lock requests could hang (like Parallel Queries may hang "enq: TS - contention") database enterprize edition 11.2.0.3 solaris 10 By: mshrkshl on Thu, 29 August 2013	2	2515	Thu, 29 August 2013 04:38 By: mshrkshl
Please guide to improve the performance of query Oracle 11g By: ajaykumarkona on Mon, 26 August 2013	8	2592	Tue, 27 August 2013 03:56 By: pablolee
Moving Tables to Encrypted Tablespace. 11.2.0.3.0 version of oracle. By: VIP2013 on Sun, 25 August 2013	2	2010	Tue, 27 August 2013 03:20 By: VIP2013
dynamic sql choosing wrong index oracle 11g / aix By: 4wheels on Fri, 16 August 2013	3	2610	Thu, 22 August 2013 08:31 By: Kevin Meade
query tuning oracle 010g By: karthikmuthuraman88 on Wed, 21 August 2013	6	5730	Thu, 22 August 2013 08:15 By: Lalit Kumar B
Stats on a partitioned table 11g By: johnp12 on Thu, 08 August 2013	3	3110	Wed, 21 August 2013 21:47 By: Kevin Meade
Efficient Way - Outer join Vs Not Exists Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production By: saipradyumn on Tue, 20 August 2013	4	3685	Wed, 21 August 2013 01:33 By: saipradyumn
identifying query problem Oracle 10.2.0.4.0, RedHatLinux-5 By: 8939513598$ on Mon, 12 August 2013	4	2077	Tue, 20 August 2013 22:11 By: Kevin Meade
dbms_stats.set_table_prefs and "LIST STALE" 11.2.0.3.0 By: johnp12 on Wed, 14 August 2013	8	7406	Thu, 15 August 2013 10:12 By: johnp12
about index Oracle 10.2.0.4.0, RedHatLinux-5 By: 8939513598$ on Fri, 09 August 2013	4	2894	Thu, 15 August 2013 10:06 By: BlackSwan
Please help me to improve the performance of this query. Oracle 11G ( 1 2) By: ajaykumarkona on Mon, 08 July 2013	41	7713	Mon, 12 August 2013 05:58 By: Lalit Kumar B