由 macro 发布于: 2001-03-03 07:47

set pages 50000
col PCT_USED format 990.09

-- Controlfile creation parameters:
-- Type DATAFILE is for MAXDATAFILES
-- Type REDO LOG is for MAXLOGFILES
-- Type LOG HISTORY is for MAXLOGHISTORY
-- Type REDO THREAD is for MAXINSTANCES
-- No entry for MAXLOGMEMBERS (?)

select type, records_used, records_total,
records_used/records_total*100 "PCT_USED"
from sys.v_$controlfile_record_section
/

TYPE              RECORDS_USED RECORDS_TOTAL PCT_USED

----------------- ------------ ------------- --------

DATABASE                     1             1   100.00

CKPT PROGRESS                0             8     0.00

REDO THREAD                  1             8    12.50

REDO LOG                     2            32     6.25

DATAFILE                    28           254    11.02

FILENAME                    30           319     9.40

TABLESPACE                  28           254    11.02

RESERVED1                    0           254     0.00

RESERVED2                    0             1     0.00

LOG HISTORY                867           907    95.59

OFFLINE RANGE                0           291     0.00

ARCHIVED LOG                 0           811     0.00

BACKUP SET                   0           408     0.00

BACKUP PIECE                 0           510     0.00

BACKUP DATAFILE              0           563     0.00

BACKUP REDOLOG               0           107     0.00

DATAFILE COPY                0           519     0.00

BACKUP CORRUPTION            0           371     0.00

COPY CORRUPTION              0           408     0.00

DELETED OBJECT               0           816     0.00

PROXY COPY                   0           575     0.00

RESERVED4                    0          8168     0.00



已选择22行。