Chinaunix首页 | 论坛 | 博客
  • 博客访问: 1207176
  • 博文数量: 398
  • 博客积分: 10110
  • 博客等级: 上将
  • 技术积分: 4055
  • 用 户 组: 普通用户
  • 注册时间: 2007-12-23 20:01
个人简介

新博客http://www.cnblogs.com/zhjh256 欢迎访问

文章分类

全部博文(398)

文章存档

2012年(1)

2011年(41)

2010年(16)

2009年(98)

2008年(142)

2007年(100)

我的朋友

分类: Oracle

2007-12-30 21:55:15

SQL> select type, records_used, records_total,
  2         records_used/records_total*100 "PCT_USED"
  3  from   sys.v_$controlfile_record_section
  4  /
TYPE                         RECORDS_USED RECORDS_TOTAL   PCT_USED
---------------------------- ------------ ------------- ----------
DATABASE                                1             1        100
CKPT PROGRESS                           0            11          0
REDO THREAD                             1             8       12.5
REDO LOG                                3            16      18.75
DATAFILE                                8           100          8
FILENAME                               12           149 8.05369127
TABLESPACE                              8           100          8
TEMPORARY FILENAME                      1           100          1
RMAN CONFIGURATION                      0            50          0
LOG HISTORY                           121           454 26.6519823
OFFLINE RANGE                           0           292          0
ARCHIVED LOG                          117           224 52.2321428
BACKUP SET                              0           409          0
BACKUP PIECE                            0           200          0
BACKUP DATAFILE                         0           282          0
BACKUP REDOLOG                          0           215          0
DATAFILE COPY                           0           223          0
BACKUP CORRUPTION                       0           371          0
COPY CORRUPTION                         0           409          0
DELETED OBJECT                          0           818          0
TYPE                         RECORDS_USED RECORDS_TOTAL   PCT_USED
---------------------------- ------------ ------------- ----------
PROXY COPY                              0           249          0
BACKUP SPFILE                           0           454          0
DATABASE INCARNATION                    2           292 0.68493150
FLASHBACK LOG                           0          2048          0
RECOVERY DESTINATION                    1             1        100
INSTANCE SPACE RESERVATION              1            63 1.58730158
REMOVABLE RECOVERY FILES                0          1000          0
RMAN STATUS                             0           141          0
THREAD INSTANCE NAME MAPPING            8             8        100
MTTR                                    1             8       12.5
DATAFILE HISTORY                        0            57          0
阅读(1191) | 评论(0) | 转发(0) |
0

上一篇:切换到其他用户

下一篇:一些不错的书籍

给主人留下些什么吧!~~