ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 视图学习之--V$ASM_CLIENT

视图学习之--V$ASM_CLIENT

原创 Linux操作系统 作者:leng138322 时间:2010-11-24 11:27:03 0 删除 编辑

In an Automatic Storage Management instance, V$ASM_CLIENT displays one row for every database instance using a disk group managed by the Automatic Storage Management instance. In a database instance, V$ASM_CLIENT displays one row for the Automatic Storage Management instance if the database has open Automatic Storage Management files.

Column Datatype Description
GROUP_NUMBER NUMBER Number of the disk group being used by the client database instance (foreign key to the V$ASM_DISKGROUP view)
INSTANCE_NAME VARCHAR2(64) Identifier for the database instance client
DB_NAME VARCHAR2(8) Unique database name of the database client instance
STATUS VARCHAR2(12) Status of the client connection:
  • CONNECTED - Database instance client has an active connection to the Automatic Storage Management instance

  • DISCONNECTED - Database instance client normally ended its connection to the Automatic Storage Management instance

  • BROKEN - Connection with the database instance client terminated abnormally

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/15881763/viewspace-680100/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2010-07-08

  • 博文量
    35
  • 访问量
    97744