 |
|
ss
Oracle Tips by Burleson |
Chapter 6 Oracle Tablespace and File
Internals Scripts
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.
lib_rep.sql
COLUMN
owner FORMAT a8 HEADING 'Library|Owner'
COLUMN
library_name FORMAT a15 HEADING 'Library|Name'
COLUMN
file_spec FORMAT a30 HEADING 'File|Specification'
COLUMN
dynamic FORMAT a7 HEADING 'Dynamic'
COLUMN
stauts FORMAT a10 HEADING 'Status'
BREAK ON
owner
SET FEEDBACK
OFF VERIFY OFF LINES 78 PAGES 58
ttitle
'Database External Libraries Report'
SPOOL
lib_rep.lis
SELECT
owner,
library_name,
file_spec,
The Oracle script collection contains more than 600 working Oracle scripts. You can download them immediately at this link:
|
