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.

Advertisements

2 Responses to “Phat on RAC ?”

  1. orawiss Says:

    Hello,
    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:

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

    Don’t forget:

    * Commit after creating a job
    * You should also make a clean job, or your PERFSTAT schema wil grow infinitely. Try: http://www.pythian.com/blogs/wp-content/uploads/statspack_cleanup_script.txt


Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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: