The commands you gave are for Unix and not Windows. There is no "vi" on
Windows unless they use MKTOOLS.

-----Original Message-----
From: xnf
[mailto:oracledba-ezmlmshield-x25968309.[Email address protected]
Sent: 04 September 2006 06:50
To: LazyDBA Discussion
Subject: Re: Statspack SNAP using DBMS_JOB

Hi,

you can try as the following:

cd $ORACLE_HOME/rdbms/admin
cp spauto.sql spauto.sql.old
vi spauto.sql

change:
dbms_job.submit(:jobno, 'statspack.snap;', trunc(sysdate+1/24,'HH'),
'trunc(SYSDATE+1/24,''HH'')'-----> to

dbms_job.submit(:jobno, 'statspack.snap;', trunc(sysdate+1/48,'HH'),
'trunc(SYSDATE+1/48,''HH'')'

then sqlplus perfstat/perfstat
sql>@spauto.sql

of cource,plase make sure job_queue_processes > 0
and aq_tm_processes > 0

Hope above info can help you .

regards!


--
xnf <[Email address protected]



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html







This e-mail (and any attachments) contains information, which is confidential and intended solely for the attention and use of the named addressee(s). If you are not the intended recipient you must not copy, distribute or use it for any purpose or disclose the contents to any person. If you have received this e-mail in error, please notify us immediately at [Email address protected] The information contained in this e-mail (and any attachments) is supplied in good faith, but the sender shall not be under any liability in damages or otherwise for any reliance that may be placed upon it by the recipient. Any comments or opinions expressed are those of the originator not of NTT Europe Ltd unless otherwise expressly stated.

Oracle LazyDBA home page