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
Incremental logic on a complex query By: iammanohar on Tue, 05 February 2008	6	3037	Tue, 05 February 2008 08:53 By: S.Rajaram
oracle 10g analyze table temporary segments oracle 10g By: vipull.sayal on Tue, 05 February 2008	1	6586	Tue, 05 February 2008 03:40 By: Michel Cadot
db job oracle 8.1.6.3,HP UNIX By: fortheppl on Tue, 05 February 2008	1	1595	Tue, 05 February 2008 00:55 By: Michel Cadot
Query not running in oracle 10.2.0.3 Oracle, 10.2.0.3, windows By: shankar muthusamy on Fri, 01 February 2008	7	3885	Mon, 04 February 2008 11:12 By: Kevin Meade
select query taking long time By: varu123 on Sun, 03 February 2008	25	7536	Mon, 04 February 2008 04:53 By: varu123
patch 4589082 By: dirish on Mon, 04 February 2008	4	3754	Mon, 04 February 2008 03:08 By: Michel Cadot
Questions about measuring job execution time By: kingming on Sun, 03 February 2008	1	1690	Sun, 03 February 2008 20:13 By: kingming
if RULE BASE exists in 11G By: lioracle on Fri, 01 February 2008	3	2413	Fri, 01 February 2008 04:54 By: Michel Cadot
Newbie, help with ADDM finding By: hristo on Mon, 14 January 2008	7	15539	Thu, 31 January 2008 22:29 By: trantuananh24hg
Materialized View issue Solaris, Oracle 10.2.0.2 By: Oraclist on Thu, 31 January 2008	1	1602	Thu, 31 January 2008 01:41 By: Michel Cadot
Only Select Query Running . Concurrency Problem Solaris, Oracle 10.2.0.2 By: Oraclist on Wed, 30 January 2008	3	2973	Wed, 30 January 2008 01:21 By: Michel Cadot
How to determine blocksize for new data warehouse? By: DrNeko on Tue, 29 January 2008	1	2158	Tue, 29 January 2008 20:16 By: rleishman
Query is running long 10.2.0.2.0 , sun solris By: amarg.dba@gmail.com on Tue, 29 January 2008	5	3401	Tue, 29 January 2008 08:37 By: Michel Cadot
about update perform By: zxx2403 on Mon, 28 January 2008	3	2258	Mon, 28 January 2008 19:56 By: rleishman
Measurements By: durgadas.menon on Thu, 24 January 2008	3	2255	Sun, 27 January 2008 22:37 By: durgadas.menon
Help- slow running sql By: orasaket on Wed, 23 January 2008	3	2309	Sun, 27 January 2008 08:05 By: KrishnaBoppana
Rollback and trace/tkprof By: psynaps3 on Sun, 20 January 2008	4	2803	Sat, 26 January 2008 09:05 By: psynaps3
Insert using DB Link (merged) By: Leonard Martin on Wed, 23 January 2008	9	11324	Fri, 25 January 2008 10:36 By: Michel Cadot
Index hint inside the view is not working ORACLE 10g, AIX By: junaidsystems on Wed, 23 January 2008	1	2610	Thu, 24 January 2008 00:40 By: Michel Cadot
Reproduce performance problem in test Oracle 9i By: toshidas2000 on Wed, 23 January 2008	2	2281	Wed, 23 January 2008 20:59 By: rleishman
bitmap conversion in explain plan oracle 9.2 windows 2000 server By: agemaia on Wed, 23 January 2008	2	2978	Wed, 23 January 2008 20:35 By: rleishman
Query Profiler tool Oracle 10g Linux for Java Application By: amit_nanote on Wed, 23 January 2008	4	2481	Wed, 23 January 2008 02:31 By: amit_nanote
Sparodic database slowness By: oraclestew on Tue, 22 January 2008	2	1943	Tue, 22 January 2008 10:16 By: Michel Cadot
how to specify priority of active sql sessions running in the database Oracle database 10 g,Windows 2000 professional By: psaraj12 on Tue, 22 January 2008	1	1864	Tue, 22 January 2008 10:15 By: Michel Cadot
Performance issue By: ruchika.wadhwa on Mon, 21 January 2008	8	3673	Tue, 22 January 2008 08:43 By: Michel Cadot
Concurrency wait. How I can resolve. Oracle 10.2.0.2, Solaris. By: Oraclist on Tue, 22 January 2008	5	31977	Tue, 22 January 2008 04:06 By: Michel Cadot
From Where should i want to start for tuning sqls By: mm_kanish05 on Tue, 22 January 2008	1	1883	Tue, 22 January 2008 00:26 By: Michel Cadot
DBMS_STATS.gather_table_stats By: a_developer on Sat, 01 April 2006	12	230405	Mon, 21 January 2008 20:53 By: Mahesh Rajendran
Newbie: SQL runs slow on 10g, not on 9i By: hristo on Tue, 04 December 2007	31	7524	Sat, 19 January 2008 04:01 By: rleishman
Delete data and transaction log problem By: juicyapple on Thu, 17 January 2008	10	2960	Fri, 18 January 2008 02:00 By: Michel Cadot
Query wih bind variables By: gkrishn on Wed, 16 January 2008	6	3267	Thu, 17 January 2008 05:00 By: Michel Cadot
SQL statement takes too long to run By: sachinp36 on Mon, 14 January 2008	7	4168	Wed, 16 January 2008 21:06 By: rleishman
last queries oracle 9i windows 2000 server sp4 By: agemaia on Wed, 16 January 2008	1	1573	Wed, 16 January 2008 20:56 By: rleishman
index monitoring Oracle 9i windows 2000 server sp4 By: agemaia on Wed, 16 January 2008	2	1917	Wed, 16 January 2008 16:41 By: agemaia
Update only 8 rows in a huge Table Oracle 10g Rel 2 By: faiz_hyd on Tue, 15 January 2008	7	3226	Wed, 16 January 2008 12:51 By: Kevin Meade
Performance tuning of SQL query oracle 9i By: mrosireddy on Wed, 16 January 2008	1	1964	Wed, 16 January 2008 09:22 By: S.Rajaram
Help oracle 9.2.0 , solaris 8 By: sushilkumarmohanty on Tue, 15 January 2008	1	1745	Tue, 15 January 2008 21:45 By: BlackSwan
Query slow Oracle 9i By: gkrishn on Tue, 15 January 2008	5	1691	Tue, 15 January 2008 16:47 By: gkrishn
Newbie: Query uses index and runs slow By: hristo on Mon, 14 January 2008	4	1957	Mon, 14 January 2008 20:29 By: rleishman
How get full data from table By: bornlooser on Thu, 10 January 2008	6	2695	Mon, 14 January 2008 05:05 By: rleishman