Oracle 视图 HS_INST_INIT 官方解释，作用，如何使用详细说明
本站中文解释
_PARAM
Oracle视图HS_INST_INIT_PARAM用于提供列出数据库实例内当前启动参数。它可以被用于在实例重新启动时保存 ame，值，类型和状态等信息，以及查看设置参数的情况。
HS_INST_INIT_PARAM视图的使用：
1.查询当前实例的启动参数：
SELECT * FROM HS_INST_INIT_PARAM;
2.查询“NUM_CPUS”启动参数：
SELECT * FROM HS_INST_INIT_PARAM WHERE name = ‘NUM_CPUS’;
3.查询对“NUM_CPUS”参数进行修改的 histor：
SELECT * FROM HS_INST_INIT_PARAM WHERE name = ‘NUM_CPUS’ AND status=’MODIFIED’;
官方英文解释
HS_INST_INIT contains information about the non-Oracle (FDS) instance-specific initialization parameters.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
|
Name of the initialization parameter |
|
|
|
|
Value of the initialization parameter |
|
|
|
|
Environment variable (T or F). T means this is an environment variable; F means do not set as an environment variable |
|
|
|
|
Name of the FDS class (for example: |
|
|
|
|
Name of the FDS instance |
|
|
|
|
Sequence: a counter that is incremented for every row inserted (used internally) |
|
|
|
|
Sequence: a counter that is incremented for every row inserted (used internally) |
|
|
|
|
Sequence: a counter that is incremented for every row inserted (used internally) |
