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
excess redo generation By: dalu on Thu, 01 July 2010	3	4042	Tue, 06 July 2010 21:55 By: Kevin Meade
Description of Events Windows Server 2003 By: saharookiedba on Tue, 28 July 2009	2	3330	Tue, 06 July 2010 04:19 By: Michel Cadot
need to know about shared pool sizing 8.1.7,win 2003 server By: ultgnp on Mon, 05 July 2010	1	2159	Mon, 05 July 2010 01:32 By: BlackSwan
Logwriter processes Hp Unix,11.3 By: sekar52 on Fri, 02 July 2010	3	3157	Fri, 02 July 2010 04:32 By: Michel Cadot
parition of table 10.2.0.4 By: ankush_chawla on Mon, 28 June 2010	2	2380	Mon, 28 June 2010 08:09 By: Michel Cadot
select partition table with non partition key condition By: ekopur on Sat, 26 June 2010	3	3657	Sat, 26 June 2010 09:20 By: Michel Cadot
Help proving a database is slow 10.2 / Solaris By: rleishman on Tue, 01 June 2010	16	8255	Sat, 26 June 2010 05:13 By: rleishman
Pin Sql query in shared pool By: paradoxkhan on Fri, 25 June 2010	3	4702	Fri, 25 June 2010 08:02 By: cookiemonster
need help tuning this query 8.1.6, win2000 server By: ultgnp on Sun, 20 June 2010	17	3545	Wed, 23 June 2010 08:36 By: ultgnp
How to tune order by clause without changing sort area Oracle 9i,9.2.0.6.0,Windows XP By: rajatratewal on Thu, 01 May 2008	10	10294	Wed, 23 June 2010 03:36 By: Kevin Meade
My indexes was not active Oracle 10g, Windows 32bit By: trantuananh24hg on Mon, 21 June 2010	9	2554	Wed, 23 June 2010 02:54 By: Roachcoach
to reduce the disk reads By: akilabaskaran on Tue, 22 June 2010	14	3674	Tue, 22 June 2010 06:28 By: akilabaskaran
reducing the parse-execution ration By: akilabaskaran on Tue, 15 June 2010	12	2825	Fri, 18 June 2010 03:59 By: cookiemonster
database fragmentation Oracla 9i By: Nau on Wed, 16 June 2010	2	1849	Thu, 17 June 2010 12:42 By: Kevin Meade
Tuning PL/SQLApplications Oracle 10g By: rmaheshbabu on Thu, 17 June 2010	2	2358	Thu, 17 June 2010 00:49 By: rmaheshbabu
shared pool oracle 10.2.0.4 2 node rac,aix 6.3 By: ranganathan1984 on Mon, 14 June 2010	9	6862	Wed, 16 June 2010 00:54 By: michael_bialik
TKPROF Output Understanding Oracle 10g,10.2.0.3.0,AIX By: rajatratewal on Wed, 09 June 2010	14	7336	Wed, 16 June 2010 00:44 By: michael_bialik
Avoiding bind variable from a sql in java code oracle 10.2.0.4 on Solaris 10 By: orausern on Tue, 15 June 2010	9	3577	Tue, 15 June 2010 13:21 By: orausern
SGA "usage" By: firefly on Wed, 26 May 2010	8	7005	Mon, 14 June 2010 17:17 By: mikerault
Alternative to REPLACE function? 10gr2 By: Kevin Meade on Sat, 12 June 2010	2	2197	Mon, 14 June 2010 11:34 By: coleing
Very first step Oracle SQL Tuning By: Amitabhguha on Mon, 14 June 2010	3	2023	Mon, 14 June 2010 05:36 By: Michel Cadot
Changing execution plans Oracle 10.2.0.4 RAC By: NandKumar on Sat, 12 June 2010	3	3183	Sat, 12 June 2010 13:55 By: BlackSwan
Merge Performance (wide open question here) 10g release (4?) and 11g release 1 By: Kevin Meade on Wed, 09 June 2010	6	4229	Sat, 12 June 2010 08:48 By: Kevin Meade
tkprof question 10gr2 By: faq_dba on Fri, 11 June 2010	5	3359	Fri, 11 June 2010 22:48 By: BlackSwan
Rule based tips still valid in 11g By: ind9 on Fri, 11 June 2010	1	1575	Fri, 11 June 2010 07:38 By: cookiemonster
Oracle Internal Query 11.1.0.7.0 By: jarcher on Fri, 11 June 2010	2	4295	Fri, 11 June 2010 03:10 By: Frank Naude
Does high volume of data can change plan Oracle 10.2.0.3 By: Its_me_ved on Fri, 04 June 2010	6	2614	Fri, 04 June 2010 09:17 By: Its_me_ved
Why Elapsed Time Changed while execution plan and stats remains the same? Oracle 9.2.0.6.0 on HP-UX By: chetanaZ on Fri, 04 June 2010	10	2998	Fri, 04 June 2010 09:15 By: chetanaZ
awr report for specific date By: Riyasbasha on Fri, 04 June 2010	2	4047	Fri, 04 June 2010 01:32 By: Riyasbasha
oracleorcl (LOCAL=NO) cpu 100% Oracle10.1.0.2.0, Rhel4 By: kumarrajnishgupta on Tue, 01 June 2010	9	12111	Tue, 01 June 2010 23:19 By: Michel Cadot
help to tune this query ot help to re write in onther way oracle ,11.1,xp By: krajasekhar.v on Mon, 31 May 2010	4	2778	Mon, 31 May 2010 07:22 By: Alessandro Rossi
How to resolve query tuning? By: elangoealngos on Sun, 30 May 2010	1	2320	Sun, 30 May 2010 02:40 By: Michel Cadot
How to check the query performance By: Riyasbasha on Sat, 29 May 2010	2	2338	Sat, 29 May 2010 03:42 By: Michel Cadot
P&T Guide Question [Restructuring SQL Statements] 10g Release 2 (10.2) - Documention Related By: Roachcoach on Fri, 28 May 2010	2	2410	Fri, 28 May 2010 05:30 By: Roachcoach
Need help with tuning a query 8.0.6, win 2000 server By: ateeqrahman786 on Sun, 23 May 2010	5	3143	Wed, 26 May 2010 06:07 By: michael_bialik
V$SESSION_LONGOPS - Looking for more than last 16 ops 10.2.0.4.0 By: rleishman on Tue, 25 May 2010	3	6001	Wed, 26 May 2010 04:46 By: Michel Cadot
Different EXPLAIN PLAN Before and after execution Oracle 10g By: prateekgupta1210 on Tue, 25 May 2010	7	4190	Wed, 26 May 2010 03:33 By: prateekgupta1210
AWR report evaluation oracle10g By: shrinika on Thu, 20 May 2010	5	3549	Sun, 23 May 2010 00:00 By: ramoradba
Optimize sql Oracle 10.2.0.3 By: Its_me_ved on Wed, 19 May 2010	19	5325	Sat, 22 May 2010 03:41 By: Alessandro Rossi
explain plan 11g By: orafacjublu on Tue, 18 May 2010	6	3382	Tue, 18 May 2010 08:59 By: cookiemonster

Pages (119): [ « ‹ 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 › »]

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 Feb 15 10:52:07 CST 2025