TAILIEUCHUNG - 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 .

• Cơ sở dữ liệu
• cơ sở dữ liệu MySQL
• database SQL
• thiết kế CSDL quan hệ
• Kiến trúc hệ quản trị CSDL
• đặc tính cơ sở dữ liệu
• bảo mật cơ sở dữ liệu
• Cơ sở dữ liệu
• Hệ quản trị cơ sở dữ liệu MySQL
• Quản trị cơ sở dữ liệu
• Làm việc với MySQL
• Giới thiệu về MySQL
• Bài giảng Phần mềm nguồn mở
• Phần mềm nguồn mở
• Hệ quản trị cơ sở dữ liệu
• Lịch sử phát triển MySQL
• Kiến trúc MySQL
• MySQL Command Line
• MySQL Query Browser
• giáo trình cơ sở dữ liệu
• lý thuyết cơ sở dữ liệu
• bái giảng cơ sở dữ liệu
• tài liệu cơ sở dữ liệu
• Kết nối với MySQL
• Truy xuất cơ sở dữ liệu
• Quản lý dữ liệu
• Kết nối cơ sở dữ liệu
• Cập nhật dữ liệu
• Kích hoạt dữ liệu
• cơ sở dữ liệu sql server
• MySQL cơ bản