Oracle 8.1.6 Help....
1 отговора
126 прегледа
в отговор на Aйeз Ceдaй
#2
Re: Oracle 8.1.6 Help....
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
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