wait event 'process startup'

From: rjamya <rjamya_at_gmail.com>
Date: Mon, 27 Dec 2004 20:48:25 -0500
Message-ID: <9177895d041227174866fc11f3@mail.gmail.com>

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';
--
http://www.freelists.org/webpage/oracle-l

Received on Mon Dec 27 2004 - 19:45:07 CST