v$asm 相關的view
v$asm 相關的view[@more@]
v$asm_alias contains one row for every alias present in every disk group mounted by the oracle asm instance
----------------------------------------------------------------------------------------------------------------
v$asm_attribute display one row for each attribute defined,in addition to attribute specified by create diskgroup and alter diskgroup statements,the view may show other attribute that are created automatically . attribute are only display for disk groups where compatible,asm is set to 11.1 or high
----------------------------------------------------------------------------------------------------------------
v$asm_client in an oracle asm instance,identifies database using disk groups managed by the oracle asm instance in an oracle database instance,contains information about the oracle asm instance if the database has open oracle asm files
----------------------------------------------------------------------------------------------------------------
v$asm_disk contains one row for every disk discovered by the oracle asm instance,including disks that are not part of any disk group
----------------------------------------------------------------------------------------------------------------
v$asm_disk_iostat diskplay information about disk i/o statistics for each oracle asm client,
in an oracle database instance,only the rows for that instance are shown
----------------------------------------------------------------------------------------------------------------
v$asm_disk_stat contains the same columns as v$asm_disk,but to reduce overhead,does not perform a discovery when it is queried.it only returns information about any disks that are part of mounted
disk groups in the storage system.to see all disks,use v$asm_disk instead
----------------------------------------------------------------------------------------------------------------
v$asm_diskgroup describes a disk group(number,name,size related info,state and redundancy type)
----------------------------------------------------------------------------------------------------------------
v$asm_diskgroup_stat contains the same columns as v$asm_diskgroup,but to reduce overhead,does not perform a discovery when it is queried.it does not return information about any disks that are part of mounted disk group in the storage system,to see all disks,use v$asm_diskgroup instead.
----------------------------------------------------------------------------------------------------------------
v$asm_file contains one row for every oracle asm file in every disk group mount by the oracle asm instance
----------------------------------------------------------------------------------------------------------------
v$asm_operation in an oracle asm instance,contains one row for every active oracle asm long runing operation executing in the oracle asm instance. in an oracle database instance,contains no rows.
----------------------------------------------------------------------------------------------------------------
v$asm_template contains one row for every template present in every disk group mounted by the oracle asm instance
----------------------------------------------------------------------------------------------------------------
v$asm_user contains the effective operating system user names of connected database instances and names of file owners.
----------------------------------------------------------------------------------------------------------------
v$asm_usergroup contains the creator for each oracle asm file access control group
----------------------------------------------------------------------------------------------------------------
v$asm_usergroup_member contains the members for each oracle asm file access control group
acfs包含的一些view:
v$asm_acfs_encryption_info contains encryption information for each oracle acfs file system
v$asm_acfs_security_info contains security realm information for each oracle acfs file system
v$asm_acfssnapshots contains snapshot information for every mounted oracle acfs file system
v$asm_acfsvolumnes contains information about mounted oracle acfs volumnes,correlated with
v$asm_filesystem contains columns that display information for every mounted oracle acfs file system
v$asm_volume contains information about each oracle advm volume that is a member of an
oracle asm instance
v$asm_volumne_stat contains information about statistics for each oracle advm volume
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/24237320/viewspace-1060187/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ASM之ASM相關概念ASM
- Oracle ASM 相關的 檢視(V$) 和 資料字典(X$)OracleASM
- Dataguard (Standby) 相關的檢視(View)View
- ASM相關概念(筆記)ASM筆記
- Oracle 10g SGA 相關的VIEWOracle 10gView
- 10g ASM OEM 相關ASM
- View工作流程-相關學習View
- asm 文件中相關連結地址ASM
- 面試系列之View相關知識點面試View
- asm的相關操作,給自己看的,三思的ASM
- 自定義View相關學習(一) (SlantedTextView ,canvas)TextViewCanvas
- v$session_wait 相關SessionAI
- solaris 10_oracle asm_diskgroup_failgroup_相關OracleASMAI
- Android View滑動相關的基礎知識點AndroidView
- asm例項查詢asm相關檢視hang住解決方法ASM
- Flutter中的自定義View的基本流程和相關知識FlutterView
- v$session/v$process檢視涉及的相關會話資訊的查詢Session會話
- v_user_viewView
- ORACLE使用 DBCA 重建ASM磁碟組的相關問題總結OracleASM
- ORACLE建庫過程中自動生成的跟鎖相關的VIEWOracleView
- oracle rename table 相關index view constraint synonym等的變化OracleIndexViewAI
- 【oracle 12c asm專題】flex diskgroup相關概念OracleASMFlex
- Votingdisk, OCR, ASM 相關資訊及備份與恢復ASM
- solaris10_oracle10g asm_相關基本概念OracleASM
- 查詢等待事件(wait event)相關的SQL - v$session_wait, v$rowcache,v$sqltext事件AISQLSession
- android自定義view-繪製順序及相關原理AndroidView
- 在updata物料主資料時,對相關VIEW的許可權check方法.View
- solaris 10_oracle10g asm_create_alter_diskgroup相關命令OracleASM
- 【DOC】VIEW: "V$LOCK" Reference NoteView
- Oracle 11g Database和ASM預設的審計策略和相關操作OracleDatabaseASM
- 檢查asm磁碟組狀態的檢視v$asm_diskgroupASM
- 在centos5.4安裝oracle10g asm相關問題CentOSOracleASM
- 【ASM學習】關於 ASM 的隱含引數ASM
- 面試官問你 - 自定義View跟繪製流程相關知識點??面試View
- oracle10g_asm_v$asm_disk之total_mb_free_mb_required_mirror_free_mb相互關係OracleASMUI
- 新版 分銷 a8 v3 安裝後 的密碼相關的密碼
- 有關ASM和ASMM的理解ASM
- 使用CREATE DISKGROUP語句建立ASM磁碟組,提示找不到相應的ASM磁碟ASM