v$controlfile

oracleerp

于 2008-07-31 10:38:00 发布

阅读量808

点赞数

文章标签： file sql

本文链接：https://blog.youkuaiyun.com/oracleerp/article/details/2743917

版权

SQL> select * from v$controlfile;

STATUS   NAME                           IS_ BLOCK_SIZE FILE_SIZE_BLKS
-------- ------------------------------ --- ---------- --------------
         F:/ORACLE/PRODUCT/10.2.0/ORADA NO       16384            430
         TA/ORCL/CONTROL01.CTL

F:/ORACLE/PRODUCT/10.2.0/ORADA NO 16384 430
TA/ORCL/CONTROL02.CTL

F:/ORACLE/PRODUCT/10.2.0/ORADA NO 16384 430
TA/ORCL/CONTROL03.CTL

SQL> desc v$controlfile;
名称是否为空? 类型
----------------------------------------- -------- ---------------------------

STATUS                                             VARCHAR2(7)
NAME                                               VARCHAR2(513)
IS_RECOVERY_DEST_FILE                              VARCHAR2(3)
BLOCK_SIZE                                         NUMBER
FILE_SIZE_BLKS                                     NUMBER

SQL>