|
Тема |
Re: Oracle 8.1.6 Help.... [re: Aйeз Ceдaй] |
|
Автор | Bruce Scott (Нерегистриран) | |
Публикувано | 14.02.06 12:46 |
|
|
As an example, let's submit a new job to the job queue. The job calls the procedure DBMS_DDL.ANALYZE_OBJECT to generate optimizer statistics for the table DQUON.ACCOUNTS. The statistics are based on a sample of half the rows of the ACCOUNTS table. The job is run every 24 hours.
VARIABLE jobno number;
BEGIN
DBMS_JOB.SUBMIT(:jobno,
'dbms_ddl.analyze_object(''TABLE'',
''DQUON'', ''ACCOUNTS'',
''ESTIMATE'', NULL, 50);',
SYSDATE, 'SYSDATE + 1');
COMMIT;
END;
/
Statement processed.
PRINT jobno
JOBNO
----------
14144
W twoia slucha shte e SYSDATE+5/24
Kato cialo wiz documentaciata za job-owe
|
| |
|
|
|