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
