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 to know about shared pool sizing 8.1.7,win 2003 server By: ultgnp on Mon, 05 July 2010	1	1417	Mon, 05 July 2010 01:32 By: BlackSwan
Logwriter processes Hp Unix,11.3 By: sekar52 on Fri, 02 July 2010	3	2287	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	1514	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	2527	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	7545	Sat, 26 June 2010 05:13 By: rleishman
Pin Sql query in shared pool By: paradoxkhan on Fri, 25 June 2010	3	3686	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	2850	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	9717	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	2127	Wed, 23 June 2010 02:54 By: Roachcoach
to reduce the disk reads By: akilabaskaran on Tue, 22 June 2010	14	3106	Tue, 22 June 2010 06:28 By: akilabaskaran
reducing the parse-execution ration By: akilabaskaran on Tue, 15 June 2010	12	2281	Fri, 18 June 2010 03:59 By: cookiemonster
database fragmentation Oracla 9i By: Nau on Wed, 16 June 2010	2	1345	Thu, 17 June 2010 12:42 By: Kevin Meade
Tuning PL/SQLApplications Oracle 10g By: rmaheshbabu on Thu, 17 June 2010	2	1432	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	5474	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	6430	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	2961	Tue, 15 June 2010 13:21 By: orausern
SGA "usage" By: firefly on Wed, 26 May 2010	8	6259	Mon, 14 June 2010 17:17 By: mikerault
Alternative to REPLACE function? 10gr2 By: Kevin Meade on Sat, 12 June 2010	2	1802	Mon, 14 June 2010 11:34 By: coleing
Very first step Oracle SQL Tuning By: Amitabhguha on Mon, 14 June 2010	3	1479	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	2251	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	3645	Sat, 12 June 2010 08:48 By: Kevin Meade
tkprof question 10gr2 By: faq_dba on Fri, 11 June 2010	5	1978	Fri, 11 June 2010 22:48 By: BlackSwan
Rule based tips still valid in 11g By: ind9 on Fri, 11 June 2010	1	1237	Fri, 11 June 2010 07:38 By: cookiemonster
Oracle Internal Query 11.1.0.7.0 By: jarcher on Fri, 11 June 2010	2	3587	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	2164	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	2490	Fri, 04 June 2010 09:15 By: chetanaZ
awr report for specific date By: Riyasbasha on Fri, 04 June 2010	2	3240	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	11300	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	2269	Mon, 31 May 2010 07:22 By: Alessandro Rossi
How to resolve query tuning? By: elangoealngos on Sun, 30 May 2010	1	1525	Sun, 30 May 2010 02:40 By: Michel Cadot
How to check the query performance By: Riyasbasha on Sat, 29 May 2010	2	1568	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	2070	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	1732	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	5026	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	2895	Wed, 26 May 2010 03:33 By: prateekgupta1210
AWR report evaluation oracle10g By: shrinika on Thu, 20 May 2010	5	3059	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	4601	Sat, 22 May 2010 03:41 By: Alessandro Rossi
explain plan 11g By: orafacjublu on Tue, 18 May 2010	6	1968	Tue, 18 May 2010 08:59 By: cookiemonster
need help with rewriting the query 8.0.6 By: ateeqrahman786 on Sat, 15 May 2010	10	2495	Mon, 17 May 2010 02:50 By: ateeqrahman786
need help to speed up data loading in form 8.0.6, forms 4.5, win 2003 server By: ateeqrahman786 on Sat, 15 May 2010	1	1287	Sat, 15 May 2010 07:48 By: rleishman

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: Fri Apr 19 16:52:18 CDT 2024