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 |
---|---|---|---|
|
|
|
Capability number |
|
|
Capability description |
|
|
|
Flag indicating the context in which the capability is enabled |
|
|
|
Valid for functions; contains translation to FDS dialect |
|
|
|
Additional flags for internal use |
|
|
|
|
Name of the FDS Class |
|
|
|
Sequence: a counter that is incremented for every row inserted (used internally) |