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]


Oracle LazyDBA home page