tailieunhanh - Oracle Built−in Packages- P122

Oracle Built−in Packages- P122: Ah, for the good old days of Version of PL /SQL! Life was so simple then. No stored procedures or functions and certainly no packages. You had your set of built−in functions, like SUBSTR and TO_DATE. You had the IF statement and various kinds of loops. With these tools at hand, you built your batch−processing scripts for execution in SQL*Plus, and you coded your triggers in SQL*Forms , and you went home at night content with a good day's work done. | Appendix A What s on the Companion Disk Requirements II SELECT on DBA_JOBS EXECUTE on DBMS_IJOB BEGIN FOR job_rec IN SELECT job FROM dba_jobs WHERE priv_user NVL owner_IN priv_user LOOP END LOOP END remove_all_jobs These two procedures may come in handy when manipulation of large numbers of jobs is necessary . when trying to quiesce an environment with many busy job queue processes . PREVIOUS Job Queue Architecture HOME BOOK IHDEX HEXT DBMS_JOB Examples . Orode PL SQL Orode PL SQL Orode Advanced PL SQL Oracle Web Applications Oracle PL SQL Oracle PL SQL H I Programming I Programming I Buit-in I Programming I PL SQL Developer s I Language I Budt-ins 01116 Second Edition Guide to Orade8r Features Packages with Packages Introduction Pocket Reference Pocket Reference Copyright c 2000 O Reilly Associates. All rights reserved. DBMS_IJOB Managing Other Users Jobs 596 Oracle Built-in Packages SEARCH Chapter 13 Job Scheduling in the Database NEXT DBMS_JOB Examples The DBMS_JOB package has all kinds of useful applications waiting to be discovered. DBAs can schedule jobs that look for problem conditions in the database or track and record resource utilization. Developers can schedule large batch operations at off hours without requiring operator intervention. Tracking Space in Tablespaces I decided to implement a very simple tracking system that can be used to track the growth of data in tablespaces. Such a system could be used for capacity planning or to trigger an alert of impending space problems. The system consists of a table called db_space a view called tbs_space and a procedure called space_logger. Here is the source code for the system Filename on companion disk CREATE TABLE db_space tablespace_name VARCHAR 30 NOT NULL calc_ date DATE NOT NULL total _bytes NUMBER NOT NULL free_ bytes NUMBER NOT NULL CREATE OR REPLACE VIEW tbs_space tablespace_name total_bytes free_bytes AS SELECT .