tailieunhanh - Oracle Built−in Packages- P112

Oracle Built−in Packages- P112: 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 A final note about the procedure name xon I wanted to use the procedure name on but ran afoul of the PL SQL compiler since ON is a reserved word in SQL and PL SQL. PREVIOUS DBMS_SESSION Managing Session Information HOME BOOK INDEX NEXT 12. Managing Server Resources . Orode PL SQL Orode PL SQL orT Programming. I Programming Mw Second Edition Guide to Orade8i Features Packages Oracle Advanced PL SQL Orode Wefc Applications Orode PL SQL Orode PL SQL I Buít-in I Programmng I PL SQL Developer s I Laigvoge I Budt-ins Packages wrtki Packages Introduction Pocket Reference Pocket Reference Copyright c 2000 O Reilly Associates. All rights reserved. DBMS_SYSTEM Interface 546 Oracle Built-in Packages SEARCH PREVIOUS Chapter 12 NEXT 547 12. Managing Server Resources Contents DBMS_SPACE Obtaining Space Information DBMS_SHARED_POOL Pinning Objects Through built-in packages Oracle is now exposing more information about database internals information that is not directly visible in the catalog. This chapter describes two packages that expose useful information. DBMSSPACE Gives DBAs an analysis of the amount of space both used and free within a table index or cluster segment. It also provides information about segment free list sizes information of special interest to Oracle Parallel Server administrators. DBMSSHAREDPOOL On the memory side gives DBAs some measure of control over the Oracle System Global Area s SGA s shared pool. By pinning large packages into the shared pool expensive runtime memory management and even errors can be avoided. DBMS_SPACE Obtaining Space Information The DBMS_SPACE package provides procedures for obtaining space utilization information about table index and cluster segments. This information is not directly available through the Oracle data dictionary views. It can be used to report on and track segment space consumption in an Oracle database more accurately than by monitoring extent allocation .