oracle 8i系统检查

oracle  8i系统检查

set echo on
spool d:\bk\1.txt
select sysdate from dual;
--版本信息
select * from v$version;

--安装的产品
col PARAMETER for a50;
col value for a10;
select * from v$option order by 2;

--用户信息
set linesize 100
set pagesize 100
COL USERNAME FOR A18
COL PASSWORD FOR A18
COL DEFAULT_TABLESPACE FOR A18
COL PROFILE FOR A18
col account_status for a18
SELECT USERNAME,PASSWORD,DEFAULT_TABLESPACE,PROFILE,account_status
FROM DBA_USERS ORDER BY 5,3;

--日志文件
col MEMBERS for 9;
SELECT * FROM V$LOG;
SELECT * FROM V$LOGFILE;

--归档信息,目录，格式，归档进程
col DEST_NAME for a25 
col DESTINATION for a60
col value