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

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