Oracle 常用的V$ 视图脚本

select * from v$version;

select name,created,log_mode from v$database;

Select occupant_name,occupant_desc,space_usage_kbytes from v$sysaux_occupants where occupant_name like '%AWR%';

select dbms_stats.get_stats_history_availability from dual;

select dbms_stats.get_stats_history_retention from dual;

EXEC dbms_stats.alter_stats_history_retention(15);

select * from v$license;

select * from v$option;

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!