>Database istatistik toplama

>procedure;

CREATE OR REPLACE PROCEDURE SYS.gds IS

BEGIN

dbms_stats.gather_database_stats();

END gds;
/
———————————-
job;

BEGIN
SYS.DBMS_JOB.REMOVE(6);
COMMIT;
END;
/

DECLARE
X NUMBER;
BEGIN
SYS.DBMS_JOB.SUBMIT
( job => X
,what => ‘SYS.GDS;’
,next_date => to_date(‘23.12.2009 15:00:00′,’dd/mm/yyyy hh24:mi:ss’)
,interval => ‘TRUNC(SYSDATE+7)’
,no_parse => FALSE
);
SYS.DBMS_OUTPUT.PUT_LINE(‘Job Number is: ‘ || to_char(x));
COMMIT;
END;
/

This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s