Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Statspack setup for 2nd RAC instance ?...basic Qs

Re: Statspack setup for 2nd RAC instance ?...basic Qs

From: Barbara Baker <barb.baker_at_gmail.com>
Date: Tue, 6 Feb 2007 10:23:48 -0700
Message-ID: <47a6f72b0702060923x3c9e75e0hbf9cd619cb056583@mail.gmail.com>


Vivek:
When I set up statspack, here's my checklist. (This is VMS, i.e., a REAL cluster. YMMV)
run spcreate (once)
run spauto (on each node)
run Tim Gorman's purge scheduler sppurpkg

     (www.evdbt.com Tim has a bunch of statspack add-ons that are wonderful)
mod the job instance on each node for spauto to run regularly

  alter session set nls_date_format ='DD-MON-YYYY HH24:MI';

--
--  Schedule a snapshot to be run on this instance every hour at 5 till the
hour
---declare variable jobno number :=1;

variable instno number;
begin
  select instance_number into :instno from v$instance;
end;
/
begin
  dbms_job.change(&&job_nbr,
                  null,
                  null,
                  null,
                  :instno
                   );
  commit;
end;
/

add Tim's spparams to change threshhold stuff

Good luck!
Barb



On 2/6/07, VIVEK_SHARMA <VIVEK_SHARMA_at_infosys.com> wrote:

>
> Folks
>
>
>
> *What additional SETUP is needed to ADD the 2nd instance to STATSPACK?*
>
>
>
> NOTE SQL>?/rdbms/admin/spcreate has been Run from the 1st RAC instance.
>
>
>
> Running sprepins shows only 1 instance, below
>
>
>
-- http://www.freelists.org/webpage/oracle-l
Received on Tue Feb 06 2007 - 11:23:48 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US