 |
|
ss
Oracle Tips by Burleson |
Chapter 6 Oracle Tablespace and File
Internals Scripts
dynamic,
status
FROM
dba_libraries
ORDER BY
owner;
SPOOL OFF
SET VERIFY ON FEEDBACK ON
TTITLE OFF
CLEAR COLUMNS
CLEAR BREAKS
Here is a sample listing:
Library
Library File
Owner
Name Specification Dynamic STATUS
--------
--------------- ------------------------------ ------- ---
CTXSYS
DR$LIB N VALID
DR$LIBX /var/oracle/OraHome2/ctx/lib/l Y VALID
ibctxx9.so
LBACSYS
LBAC$CACHE_LIBT N VALID
LBAC$COMPS_LIBT N VALID
LBAC$EVENT_LIBT N VALID
LBAC$LABEL_LIBT N VALID
Mike has
priced his collection of scripts at $49.95, less than a dime per
script. You can download them immediately at this link:
|
