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	2993	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	6554	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	1569	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	3853	Mon, 04 February 2008 11:12 By: Kevin Meade
select query taking long time By: varu123 on Sun, 03 February 2008	25	7469	Mon, 04 February 2008 04:53 By: varu123
patch 4589082 By: dirish on Mon, 04 February 2008	4	3736	Mon, 04 February 2008 03:08 By: Michel Cadot
Questions about measuring job execution time By: kingming on Sun, 03 February 2008	1	1664	Sun, 03 February 2008 20:13 By: kingming
if RULE BASE exists in 11G By: lioracle on Fri, 01 February 2008	3	2394	Fri, 01 February 2008 04:54 By: Michel Cadot
Newbie, help with ADDM finding By: hristo on Mon, 14 January 2008	7	15424	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	1586	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	2942	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	2106	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	3364	Tue, 29 January 2008 08:37 By: Michel Cadot
about update perform By: zxx2403 on Mon, 28 January 2008	3	2241	Mon, 28 January 2008 19:56 By: rleishman
Measurements By: durgadas.menon on Thu, 24 January 2008	3	2224	Sun, 27 January 2008 22:37 By: durgadas.menon
Help- slow running sql By: orasaket on Wed, 23 January 2008	3	2283	Sun, 27 January 2008 08:05 By: KrishnaBoppana
Rollback and trace/tkprof By: psynaps3 on Sun, 20 January 2008	4	2788	Sat, 26 January 2008 09:05 By: psynaps3
Insert using DB Link (merged) By: Leonard Martin on Wed, 23 January 2008	9	11287	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	2597	Thu, 24 January 2008 00:40 By: Michel Cadot
Reproduce performance problem in test Oracle 9i By: toshidas2000 on Wed, 23 January 2008	2	2263	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	2956	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	2459	Wed, 23 January 2008 02:31 By: amit_nanote
Sparodic database slowness By: oraclestew on Tue, 22 January 2008	2	1927	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	1821	Tue, 22 January 2008 10:15 By: Michel Cadot
Performance issue By: ruchika.wadhwa on Mon, 21 January 2008	8	3595	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	31826	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	1846	Tue, 22 January 2008 00:26 By: Michel Cadot
DBMS_STATS.gather_table_stats By: a_developer on Sat, 01 April 2006	12	230245	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	7435	Sat, 19 January 2008 04:01 By: rleishman
Delete data and transaction log problem By: juicyapple on Thu, 17 January 2008	10	2790	Fri, 18 January 2008 02:00 By: Michel Cadot
Query wih bind variables By: gkrishn on Wed, 16 January 2008	6	3189	Thu, 17 January 2008 05:00 By: Michel Cadot
SQL statement takes too long to run By: sachinp36 on Mon, 14 January 2008	7	4098	Wed, 16 January 2008 21:06 By: rleishman
last queries oracle 9i windows 2000 server sp4 By: agemaia on Wed, 16 January 2008	1	1556	Wed, 16 January 2008 20:56 By: rleishman
index monitoring Oracle 9i windows 2000 server sp4 By: agemaia on Wed, 16 January 2008	2	1882	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	3199	Wed, 16 January 2008 12:51 By: Kevin Meade
Performance tuning of SQL query oracle 9i By: mrosireddy on Wed, 16 January 2008	1	1944	Wed, 16 January 2008 09:22 By: S.Rajaram
Help oracle 9.2.0 , solaris 8 By: sushilkumarmohanty on Tue, 15 January 2008	1	1727	Tue, 15 January 2008 21:45 By: BlackSwan
Query slow Oracle 9i By: gkrishn on Tue, 15 January 2008	5	1669	Tue, 15 January 2008 16:47 By: gkrishn
Newbie: Query uses index and runs slow By: hristo on Mon, 14 January 2008	4	1933	Mon, 14 January 2008 20:29 By: rleishman
How get full data from table By: bornlooser on Thu, 10 January 2008	6	2667	Mon, 14 January 2008 05:05 By: rleishman