Phat on RAC ?

I always had the wish to do some investigation about Statspack and Phat on RAC. I have tried a few times to get RAC running on Vmware on my 2GB laptop, but I haven’t managed to get it working yet. But sometimes a interesting chance comes along. An important client is having some performance trouble on a RAC cluster, so this is a good moment to do some R&D, and be productive immediatly. I figured out how Statspack works on RAC, I have created 2 snapshot jobs, each with instance affinity. Now I’ll see if Phat can be of any use.


2 Responses to “Phat on RAC ?”

  1. orawiss Says:

    Can you share with us, how to you configured and run Statspack in your RAC system?
    thank you

  2. Bas Says:

    Just create a dbms_job for each instance:

    ( job => X
    ,what => ‘statspack.snap;’
    ,next_date => TRUNC(SYSDATE+1/24,’HH’)
    ,no_parse => TRUE
    ,FORCE => TRUE
    ,instance => &instance
    SYS.DBMS_OUTPUT.PUT_LINE(‘Job Number is: ‘ || TO_CHAR(x));

    Don’t forget:

    * Commit after creating a job
    * You should also make a clean job, or your PERFSTAT schema wil grow infinitely. Try:

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: