Hi all, I have this issue notice in one of the databases ... process startup is larger than normal. Here is a snippett ... STATSPACK report for DB Name DB Id Instance Inst Num Release Cluster Host ------------ ----------- ------------ -------- ----------- ------- ------------ MIS 1893113387 MIS1 1 9.2.0.4.0 YES elara Snap Id Snap Time Sessions Curs/Sess Comment ------- ------------------ -------- --------- ------------------- Begin Snap: 2369 27-Dec-04 19:50:01 ####### 1.0 End Snap: 2383 27-Dec-04 20:20:10 ####### 1.0 Elapsed: 30.15 (mins) Cache Sizes (end) ~~~~~~~~~~~~~~~~~ Buffer Cache: 64M Std Block Size: 8K Shared Pool Size: 384M Log Buffer: 2,000K Load Profile ~~~~~~~~~~~~ Per Second Per Transaction --------------- --------------- Redo size: 2,553.73 7,777.27 Logical reads: 416.71 1,269.08 Block changes: 10.32 31.43 Physical reads: 1.11 3.39 Physical writes: 0.15 0.45 User calls: 14.26 43.42 Parses: 5.67 17.27 Hard parses: 1.01 3.07 Sorts: 2.24 6.82 Logons: 0.17 0.53 Executes: 7.09 21.60 Transactions: 0.33 % Blocks changed per Read: 2.48 Recursive Call %: 52.42 Rollback per transaction %: 2.36 Rows per Sort: 121.69 Instance Efficiency Percentages (Target 100%) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Buffer Nowait %: 100.00 Redo NoWait %: 100.00 Buffer Hit %: 99.73 In-memory Sort %: 100.00 Library Hit %: 93.10 Soft Parse %: 82.22 Execute to Parse %: 20.06 Latch Hit %: 100.00 Parse CPU to Parse Elapsd %: 84.29 % Non-Parse CPU: 83.90 Shared Pool Statistics Begin End ------ ------ Memory Usage %: 89.62 89.75 % SQL with executions>1: 55.50 41.33 % Memory for SQL w/exec>1: 51.11 38.01 Top 5 Timed Events ~~~~~~~~~~~~~~~~~~ % Total Event Waits Time (s) Ela Time -------------------------------------------- ------------ ----------- -------- process startup 1,120 1,080 94.71 CPU time 37 3.27 db file sequential read 478 3 .28 log file sync 534 3 .26 CGS wait for IPC msg 220,250 3 .26 ------------------------------------------------------------- Cluster Statistics for DB: MIS Instance: MIS1 Snaps: 2369 -2383 This is a fairly lightweight db, any ideas where to start looking at?? 9204/AIX 5.2ml2/RAC/2 nodes/24cpu/64gb TIA Raj -- ------------------------------ select standard_disclaimer from company_requirements where category = 'MANDATORY'; -- //www.freelists.org/webpage/oracle-l