Creating Statspack job

Here is sql code for creating statspack job
(before creating this job statspack must be installed)



DECLARE
jobno number;
BEGIN
DBMS_JOB.SUBMIT (
jobno,
'statspack.snap(i_snap_level=>7);',
(TRUNC(SYSDATE)+ 15/24) + 10/1440,
'TRUNC(SYSDATE,''MI'')+10/1440'
);
COMMIT;
END; /

jobno User Defined jobnumber
I_SNAP_LEVEL statspack level
(TRUNC(SYSDATE)+ 15/24) + 10/1440 is start time
'TRUNC(SYSDATE,''MI'')+10/1440' is next interval

Location of statspack reports generated is as follow
@(ORACLE_HOME)/rdbms/admin/spreport

Link to Next Post:Strange Google Crawler
Link to Previous post:WEB HOSTING & Classful IP Addressing
Link to this Blog:Random-View