Oracle 视图 HS_CLASS_CAPS 官方解释,作用,如何使用详细说明

本站中文解释

Oracle视图HS_CLASS_CAPS用于检索类资源容量信息,它是用于查看硬件以及云实例适用的存储资源和类池资源的信息,它可以按类别访问该信息,并可跟踪每一个类的容量,使您可以预估存储的使用情况。

使用方法:

1. 使用表列出类池和类资源的容量:
SELECT class_allocation, resource_name, storage_size FROM hs_class_caps;

2. 根据类池查找类资源的容量:
SELECT class_allocation, resource_name, storage_size FROM hs_class_caps WHERE class_allocation = ‘POOL_NAME’;

官方英文解释

HS_CLASS_CAPS contains information about the class-specific (driver) capabilities belonging to the non-Oracle (FDS) data store.

Column Datatype NULL Description

CAP_NUMBER

NUMBER

NOT NULL

Capability number

CAP_DESCRIPTION

VARCHAR2(255)

Capability description

CONTEXT

NUMBER

Flag indicating the context in which the capability is enabled

TRANSLATION

VARCHAR2(255)

Valid for functions; contains translation to FDS dialect

ADDITIONAL_INFO

NUMBER

Additional flags for internal use

FDS_CLASS_NAME

VARCHAR2(30)

NOT NULL

Name of the FDS Class

FDS_CLASS_ID

NUMBER

NOT NULL

Sequence: a counter that is incremented for every row inserted (used internally)


数据运维技术 » Oracle 视图 HS_CLASS_CAPS 官方解释,作用,如何使用详细说明