檢視資料庫系統instance與database、service以及resource的字典資訊

這裡專門羅列了一些資料庫系統instance與database、service以及resource的字典，來了解
資料庫的重要資訊。

---檢視資料庫系統所有引數的字典：

Select * from v$system_parameter;

sys@PROD>desc v$system_parameter;

 Name                                      Null?    Type

 ----------------------------------------- -------- ----------------------------

 NUM                                                NUMBER

 NAME                                               VARCHAR2(80)

 TYPE                                               NUMBER

 VALUE                                              VARCHAR2(4000)

 DISPLAY_VALUE                                      VARCHAR2(4000)

 ISDEFAULT                                          VARCHAR2(9)

 ISSES_MODIFIABLE                                   VARCHAR2(5)

 ISSYS_MODIFIABLE                                   VARCHAR2(9)

 ISINSTANCE_MODIFIABLE                              VARCHAR2(5)

 ISMODIFIED                                         VARCHAR2(8)

 ISADJUSTED                                         VARCHAR2(5)

 ISDEPRECATED                                       VARCHAR2(5)

 ISBASIC                                            VARCHAR2(5)

 DESCRIPTION                                        VARCHAR2(255)

 UPDATE_COMMENT                                     VARCHAR2(255)

 HASH                                               NUMBER

---檢視例項：

SELECT * from v$instance;   --檢視單例項的例項資訊

SELECT * from gv$instance;  --檢視叢集中的例項資訊

 

---檢視資料庫：

select * from v$database;   --檢視單例項的資料庫資訊

select * from gv$database;  --檢視叢集中的資料庫資訊

 

---檢視伺服器相關資訊：

SELECT * FROM V$SERVICES;

SELECT * FROM GV$SERVICES;

#檢視服務名。

--與資料庫服務相關的資訊檢視：

SELECT * FROM V$SERVICE_EVENT;

SELECT * FROM GV$SERVICE_EVENT;

 --資料庫服務的相關統計資訊：

SELECT * FROM V$SERVICE_STATS;

SELECT * FROM GV$SERVICE_STATS;

 --資料庫服務等待事件相關資訊：

SELECT * FROM V$SERVICE_WAIT_CLASS;

SELECT * FROM GV$SERVICE_WAIT_CLASS;

---檢視處理器程式資訊：

Select * from v$process;

SQL> desc v$process;

 Name                                      Null?    Type

 ----------------------------------------- -------- ----------------------------

 ADDR                                               RAW(8)

 PID                                                NUMBER

 SPID                                               VARCHAR2(24)

 PNAME                                              VARCHAR2(5)

 USERNAME                                           VARCHAR2(15)

 SERIAL#                                            NUMBER

 TERMINAL                                           VARCHAR2(30)

 PROGRAM                                            VARCHAR2(48)

... ...

 

---檢視資源資訊：

Select * from v$resource;

SQL> desc v$resource;

 Name                                      Null?    Type

 ----------------------------------------- -------- ----------------------------

 ADDR                                               RAW(8)

 TYPE                                               VARCHAR2(2)

 ID1                                                NUMBER

 ID2                                                NUMBER