V$ASM_DISK 檢視含義
V$ASM_DISK
In an Automatic Storage Management instance, V$ASM_DISK displays one row for every disk discovered by the Automatic Storage Management instance, including disks which are not part of any disk group. In a database instance, V$ASM_DISK only displays rows for disks in disk groups in use by the database instance.
Column | Datatype | Description |
---|---|---|
GROUP_NUMBER | NUMBER | Number of the disk group containing the disk (foreign key to the V$ASM_DISKGROUP view) |
DISK_NUMBER | NUMBER | Number assigned to the disk within its disk group |
COMPOUND_INDEX | NUMBER | A 32-bit number consisting of a disk group number in the high-order 8 bits and a disk number in the low-order 24 bits (for efficient access to the view) |
INCARNATION | NUMBER | Incarnation number for the disk |
MOUNT_STATUS | VARCHAR2(7) | Per-instance status of the disk relative to group mounts:
|
HEADER_STATUS | VARCHAR2(12) | Per-instance status of the disk as seen by discovery:
|
MODE_STATUS | VARCHAR2(7) | Global status about which kinds of I/O requests are allowed to the disk:
|
STATE | VARCHAR2(8) | Global state of the disk with respect to the disk group:
|
REDUNDANCY | VARCHAR2(7) | External redundancy of the disk:
|
LIBRARY | VARCHAR2(64) | Name of the library that discovered the disk |
TOTAL_MB | NUMBER | Total capacity of the disk (in megabytes) |
FREE_MB | NUMBER | Unused capacity of the disk (in megabytes) |
NAME | VARCHAR2(30) | Name of the disk |
FAILGROUP | VARCHAR2(30) | Name of the failure group containing the disk |
LABEL | VARCHAR2(31) | Disk label portion of the name returned by discovery |
PATH | VARCHAR2(256) | Operating system pathname portion of the name returned by discovery |
UDID | VARCHAR2(64) | Universal Device ID portion of the name returned by discovery |
PRODUCT | VARCHAR2(32) | The name of the manufacturer and the name of the product. All disks with the same product id will have the same performance and reliability characteristics. |
CREATE_DATE | DATE | Date and time when the disk was added to the disk group |
MOUNT_DATE | DATE | Date and time when the disk was mounted by the first instance |
REPAIR_TIMER | NUMBER | Seconds remaining until the disk is automatically dropped (0 if not failed) |
READS | NUMBER | Total number of I/O read requests for the disk |
WRITES | NUMBER | Total number of I/O write requests for the disk |
READ_ERRS | NUMBER | Total number of failed I/O read requests for the disk |
WRITE_ERRS | NUMBER | Total number of failed I/O write requests for the disk |
READ_TIME | NUMBER | Total I/O time (in hundredths of a second) for read requests for the disk if the TIMED_STATISTICS initialization parameter is set to true (0 if set to false) |
WRITE_TIME | NUMBER | Total I/O time (in hundredths of a second) for write requests for the disk if the TIMED_STATISTICS initialization parameter is set to true (0 if set to false) |
BYTES_READ | NUMBER | Total number of bytes read from the disk |
BYTES_WRITTEN | NUMBER | Total number of bytes written to the disk |
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/7199859/viewspace-694341/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle 11g中v$session檢視server列的含義OracleSessionServer
- ORACLE V$lock檢視TYPE,ID1,ID2取值的含義Oracle
- [20171102]檢視v$session中process欄位含義Session
- 【YashanDB知識庫】v$instance檢視中例項角色含義不明確
- v$動態效能檢視和隱含引數
- v$session command 的含義Session
- [20120307]檢視v$session檢視的定義.txtSession
- v$session.PROCESS/V$process.SPID含義Session
- v$sql檢視和v$sqlarea檢視的構建SQL
- v$session 檢視Session
- v$session的blocking_session含義SessionBloC
- 資料庫例項$ASM_DISK檢視的FREE_MB值不正確資料庫ASM
- MySQL資料庫檢視:檢視定義、建立檢視、修改檢視MySql資料庫
- 實驗二:檢視centos的版本號及版本號所代表的含義CentOS
- 自定義檢視指令
- 幾個檢視 v$mystat v$systata v$sessionSession
- v$session中command欄位的含義解析Session
- oracle 檢視隱含引數指令碼Oracle指令碼
- [zt] 如何檢視Oracle 隱含引數Oracle
- 【會話】V$SESSION檢視會話Session
- oracle v$sysstat效能檢視Oracle
- Oracle常用的V$檢視Oracle
- Oracle 等待事件V$檢視Oracle事件
- v$resource_limit檢視MIT
- v檢視的授權
- [筆記]解析v$log/v$logfile中status列值的含義筆記
- Laravel 自定義檢視元件Laravel元件
- 自定義例外 + 建立檢視
- v$sesstat,v$mystat,v$statname和v$sysstat檢視簡介
- 帶你理解transform:rotate(含三維檢視)ORM
- oracle隱含引數的檢視與修改Oracle
- 【parameter】oracle的隱含引數的檢視Oracle
- 【Oracle九大效能檢視】之6.v$process檢視Oracle
- 使用V$SQL_PLAN檢視SQL
- V$SQLAREA 檢視TOP_SQLSQL
- Oracle中效能檢視V$SYSSTATOracle
- v$sql_plan 檢視解析SQL
- v$active_session_history檢視Session