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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 【YashanDB知識庫】v$instance檢視中例項角色含義不明確
- v$parameter gv$parameter 檢視 DDL 與隱含引數
- 實驗二:檢視centos的版本號及版本號所代表的含義CentOS
- 自定義檢視指令
- 檢視V$DATAGUARD_STATS
- Laravel 自定義檢視元件Laravel元件
- 檢視錶的定義
- 帶你理解transform:rotate(含三維檢視)ORM
- [20240911]檢視超長檢視的定義2.txt
- bootstrap含義boot
- instanceof 含義
- iPhone 新漏洞,可檢視並傳送iPhone照片(含視訊)iPhone
- 關於DBA_USERS檢視中ACCOUNT_STATUS 列的各種取值的含義說明
- [20211019]V$DETACHED_SESSION檢視.txtSession
- [20211214]檢視檢視V$ACTIVE_SESSION_HISTORY遇到奇怪問題.txtSession
- 自定義 Command 檢視 Laravel 日誌Laravel
- V$ACTIVE_SESSION_HISTORY檢視的使用Session
- [20210528]V$INDEXED_FIXED_COLUMN檢視.txtIndex
- [20210418]查詢v$檢視問題.txt
- k8s中檢視預設排程器開啟的外掛以及權重的含義K8S
- 自定義檢視---圓角柱狀圖(一)
- CAP 定理的含義
- Linux版本號含義Linux
- 回表的含義
- LIST INCARNATION OF DATABASE含義Database
- 閉包的含義
- 時區 CST 含義
- Flutter日曆2.0,支援月檢視和周檢視,可以支援自定義風格Flutter
- 使用檢視格式化來自定義SharePoint
- Flutter - Drawer 抽屜檢視與自定義headerFlutterHeader
- SMART原則的定義和含義
- url中#(hash)的含義
- Spring中bean的含義SpringBean
- List Incarnation 語法含義
- 260/280、260/230 含義
- Promise含義及基本用法Promise
- EXPLAIN結果含義(轉)AI
- Makefile中:=, =, ?=和+=的含義
- Web含義是什麼Web