oracle 12c 巡检脚本,oracle数据库巡检sql脚本

如何查询sga内各组件信息和pga大小

SQL> conn / as sysdba

SQL> show parameter sga_max –查看sga的大小

NAME TYPE V ALUE

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

sga_max_size big integer 1578706860

SQL> show parameter sga_target –查看sga_target大小(只限10g以上版本)

NAME TYPE V ALUE

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

sga_target big integer 584M

SQL> show parameter db_cache_size –-查看db_cache大小

NAME TYPE V ALUE

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

db_cache_size big integer 1048576000

SQL> show parameter shared_pool_size –查看share_pool大小

NAME TYPE V ALUE

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

shared_pool_size big integer 318767104

SQL> show parameter pga—查看pga_aggregate_target

NAME TYPE V ALUE

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

pga_aggregate_target big integer 314572800

查询数据库版本的sql

SQL> select VERSION from v$instance;

VERSION

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

9.2.0.1.0