1 SQL> desc v$logfile; 2 名称 是否为空? 类型 3 ----------------------------------------- -------- ------------------ 4 5 GROUP# NUMBER 6 STATUS VARCHAR2(7) 7 TYPE VARCHAR2(7) 8 MEMBER VARCHAR2(513) 9 IS_RECOVERY_DEST_FILE VARCHAR2(3) 10 11 12 SQL> desc V$log; 13 名称 是否为空? 类型 14 ----------------------------------------- -------- ---------------------- 15 16 GROUP# NUMBER 17 THREAD# NUMBER 18 SEQUENCE# NUMBER 19 BYTES NUMBER 20 MEMBERS NUMBER 21 ARCHIVED VARCHAR2(3) 22 STATUS VARCHAR2(16) 23 FIRST_CHANGE# NUMBER 24 FIRST_TIME DATE 25 26 27 28 SQL> desc V$datafile; 29 名称 是否为空? 类型 30 ----------------------------------------- -------- ---------------------- 31 32 FILE# NUMBER 33 CREATION_CHANGE# NUMBER 34 CREATION_TIME DATE 35 TS# NUMBER 36 RFILE# NUMBER 37 STATUS VARCHAR2(7) 38 ENABLED VARCHAR2(10) 39 CHECKPOINT_CHANGE# NUMBER 40 CHECKPOINT_TIME DATE 41 UNRECOVERABLE_CHANGE# NUMBER 42 UNRECOVERABLE_TIME DATE 43 LAST_CHANGE# NUMBER 44 LAST_TIME DATE 45 OFFLINE_CHANGE# NUMBER 46 ONLINE_CHANGE# NUMBER 47 ONLINE_TIME DATE 48 BYTES NUMBER 49 BLOCKS NUMBER 50 CREATE_BYTES NUMBER 51 BLOCK_SIZE NUMBER 52 NAME VARCHAR2(513) 53 PLUGGED_IN NUMBER 54 BLOCK1_OFFSET NUMBER 55 AUX_NAME VARCHAR2(513) 56 FIRST_NONLOGGED_SCN NUMBER 57 58 59 SQL> desc V$controlfile; 60 名称 是否为空? 类型 61 ----------------------------------------- -------- ---------------------- 62 63 STATUS VARCHAR2(7) 64 NAME VARCHAR2(513) 65 IS_RECOVERY_DEST_FILE VARCHAR2(3) 66 BLOCK_SIZE NUMBER 67 FILE_SIZE_BLKS NUMBER 68 69 70 71 SQL> DESC V$PARAMETER; 72 名称 是否为空? 类型 73 ----------------------------------------- -------- ------------------------ 74 75 NUM NUMBER 76 NAME VARCHAR2(80) 77 TYPE NUMBER 78 VALUE VARCHAR2(512) 79 DISPLAY_VALUE VARCHAR2(512) 80 ISDEFAULT VARCHAR2(9) 81 ISSES_MODIFIABLE VARCHAR2(5) 82 ISSYS_MODIFIABLE VARCHAR2(9) 83 ISINSTANCE_MODIFIABLE VARCHAR2(5) 84 ISMODIFIED VARCHAR2(10) 85 ISADJUSTED VARCHAR2(5) 86 ISDEPRECATED VARCHAR2(5) 87 DESCRIPTION VARCHAR2(255) 88 UPDATE_COMMENT VARCHAR2(255) 89 HASH NUMBER 90 91 SQL> desc V$instance; 92 名称 是否为空? 类型 93 ----------------------------------------- -------- ---------------------- 94 95 INSTANCE_NUMBER NUMBER 96 INSTANCE_NAME VARCHAR2(16) 97 HOST_NAME VARCHAR2(64) 98 VERSION VARCHAR2(17) 99 STARTUP_TIME DATE 100 STATUS VARCHAR2(12) 101 PARALLEL VARCHAR2(3) 102 THREAD# NUMBER 103 ARCHIVER VARCHAR2(7) 104 LOG_SWITCH_WAIT VARCHAR2(15) 105 LOGINS VARCHAR2(10) 106 SHUTDOWN_PENDING VARCHAR2(3) 107 DATABASE_STATUS VARCHAR2(17) 108 INSTANCE_ROLE VARCHAR2(18) 109 ACTIVE_STATE VARCHAR2(9) 110 BLOCKED VARCHAR2(3) 111 112 113 SQL> DESC DBA_OBJECTS; 114 名称 是否为空? 类型 115 ----------------------------------------- -------- ----------------------- 116 117 OWNER VARCHAR2(30) 118 OBJECT_NAME VARCHAR2(128) 119 SUBOBJECT_NAME VARCHAR2(30) 120 OBJECT_ID NUMBER 121 DATA_OBJECT_ID NUMBER 122 OBJECT_TYPE VARCHAR2(19) 123 CREATED DATE 124 LAST_DDL_TIME DATE 125 TIMESTAMP VARCHAR2(19) 126 STATUS VARCHAR2(7) 127 TEMPORARY VARCHAR2(1) 128 GENERATED VARCHAR2(1) 129 SECONDARY VARCHAR2(1) 130 131 132 SQL> DESC ALL_OBJECTS; 133 名称 是否为空? 类型 134 ----------------------------------------- -------- ----------------------- 135 136 OWNER NOT NULL VARCHAR2(30) 137 OBJECT_NAME NOT NULL VARCHAR2(30) 138 SUBOBJECT_NAME VARCHAR2(30) 139 OBJECT_ID NOT NULL NUMBER 140 DATA_OBJECT_ID NUMBER 141 OBJECT_TYPE VARCHAR2(19) 142 CREATED NOT NULL DATE 143 LAST_DDL_TIME NOT NULL DATE 144 TIMESTAMP VARCHAR2(19) 145 STATUS VARCHAR2(7) 146 TEMPORARY VARCHAR2(1) 147 GENERATED VARCHAR2(1) 148 SECONDARY VARCHAR2(1) 149 150 SQL> DESC USER_OBJECTS; 151 名称 是否为空? 类型 152 ----------------------------------------- -------- ---------------------- 153 154 OBJECT_NAME VARCHAR2(128) 155 SUBOBJECT_NAME VARCHAR2(30) 156 OBJECT_ID NUMBER 157 DATA_OBJECT_ID NUMBER 158 OBJECT_TYPE VARCHAR2(19) 159 CREATED DATE 160 LAST_DDL_TIME DATE 161 TIMESTAMP VARCHAR2(19) 162 STATUS VARCHAR2(7) 163 TEMPORARY VARCHAR2(1) 164 GENERATED VARCHAR2(1) 165 SECONDARY VARCHAR2(1)