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
db job oracle 8.1.6.3,HP UNIX By: fortheppl on Tue, 05 February 2008	1	1225	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	3513	Mon, 04 February 2008 11:12 By: Kevin Meade
select query taking long time By: varu123 on Sun, 03 February 2008	25	6929	Mon, 04 February 2008 04:53 By: varu123
patch 4589082 By: dirish on Mon, 04 February 2008	4	3508	Mon, 04 February 2008 03:08 By: Michel Cadot
Questions about measuring job execution time By: kingming on Sun, 03 February 2008	1	1314	Sun, 03 February 2008 20:13 By: kingming
if RULE BASE exists in 11G By: lioracle on Fri, 01 February 2008	3	2146	Fri, 01 February 2008 04:54 By: Michel Cadot
Newbie, help with ADDM finding By: hristo on Mon, 14 January 2008	7	14990	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	1179	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	2015	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	1564	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	2038	Tue, 29 January 2008 08:37 By: Michel Cadot
about update perform By: zxx2403 on Mon, 28 January 2008	3	1931	Mon, 28 January 2008 19:56 By: rleishman
Measurements By: durgadas.menon on Thu, 24 January 2008	3	1376	Sun, 27 January 2008 22:37 By: durgadas.menon
Help- slow running sql By: orasaket on Wed, 23 January 2008	3	1691	Sun, 27 January 2008 08:05 By: KrishnaBoppana
Rollback and trace/tkprof By: psynaps3 on Sun, 20 January 2008	4	1897	Sat, 26 January 2008 09:05 By: psynaps3
Insert using DB Link (merged) By: Leonard Martin on Wed, 23 January 2008	9	9945	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	1966	Thu, 24 January 2008 00:40 By: Michel Cadot
Reproduce performance problem in test Oracle 9i By: toshidas2000 on Wed, 23 January 2008	2	1487	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	2246	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	1488	Wed, 23 January 2008 02:31 By: amit_nanote
Sparodic database slowness By: oraclestew on Tue, 22 January 2008	2	1217	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	1344	Tue, 22 January 2008 10:15 By: Michel Cadot
Performance issue By: ruchika.wadhwa on Mon, 21 January 2008	8	1961	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	31197	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	1312	Tue, 22 January 2008 00:26 By: Michel Cadot
DBMS_STATS.gather_table_stats By: a_developer on Sat, 01 April 2006	12	229584	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	6666	Sat, 19 January 2008 04:01 By: rleishman
Delete data and transaction log problem By: juicyapple on Thu, 17 January 2008	10	2234	Fri, 18 January 2008 02:00 By: Michel Cadot
Query wih bind variables By: gkrishn on Wed, 16 January 2008	6	1857	Thu, 17 January 2008 05:00 By: Michel Cadot
SQL statement takes too long to run By: sachinp36 on Mon, 14 January 2008	7	3743	Wed, 16 January 2008 21:06 By: rleishman
last queries oracle 9i windows 2000 server sp4 By: agemaia on Wed, 16 January 2008	1	1313	Wed, 16 January 2008 20:56 By: rleishman
index monitoring Oracle 9i windows 2000 server sp4 By: agemaia on Wed, 16 January 2008	2	1230	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	1838	Wed, 16 January 2008 12:51 By: Kevin Meade
Performance tuning of SQL query oracle 9i By: mrosireddy on Wed, 16 January 2008	1	1235	Wed, 16 January 2008 09:22 By: S.Rajaram
Help oracle 9.2.0 , solaris 8 By: sushilkumarmohanty on Tue, 15 January 2008	1	1193	Tue, 15 January 2008 21:45 By: BlackSwan
Query slow Oracle 9i By: gkrishn on Tue, 15 January 2008	5	1441	Tue, 15 January 2008 16:47 By: gkrishn
Newbie: Query uses index and runs slow By: hristo on Mon, 14 January 2008	4	1703	Mon, 14 January 2008 20:29 By: rleishman
How get full data from table By: bornlooser on Thu, 10 January 2008	6	2319	Mon, 14 January 2008 05:05 By: rleishman
sga_max_size: Oracle reserves all at ones? By: hristo on Mon, 14 January 2008	1	1813	Mon, 14 January 2008 03:41 By: Michel Cadot
Tuning with Oracle Collections Oracle 9i By: trowsdale on Sat, 12 January 2008	2	2294	Sun, 13 January 2008 23:20 By: trowsdale