Oracle Tips by Burleson
Chapter 6 Oracle Tablespace and File
The dba_libraries view contains five fields that
are monitored through the dba_libraries view. A monitor report is
shown below. The output from the library report script follows.
owner FORMAT a8 HEADING 'Library|Owner'
library_name FORMAT a15 HEADING 'Library|Name'
file_spec FORMAT a30 HEADING 'File|Specification'
dynamic FORMAT a7 HEADING 'Dynamic'
stauts FORMAT a10 HEADING 'Status'
OFF VERIFY OFF LINES 78 PAGES 58
'Database External Libraries Report'
The Oracle script collection contains more than 600 working Oracle scripts. You can download them immediately at this link: