查看数据库保留字
SELECT * FROM V$RESERVED_WORDS
查看数据库、实例、许可状态、数据库连接
SELECT * FROM V$DATABASE
SELECT * FROM V$INSTANCE
SELECT * FROM V$LICENSE
SELECT * FROM V$DBLINK
查看密码文件用户
SELECT * FROM V$PWFILE_USERS
查看资源限制
SELECT * FROM V$RESOURCE_LIMIT
查看数据库选项、对象参数
SELECT * FROM V$OPTION
SELECT * FROM SYS.ARGUMENT$
查看兼容性
SELECT * FROM V$COMPATIBILITY
查看数据库数据字典(表、视图、索引)
SELECT * FROM V$FIXED_TABLE
SELECT * FROM V$FIXED_VIEW_DEFINITION
SELECT * FROM V$INDEXED_FIXED_COLUMN
查看数据库NLS状态
SELECT * FROM SYS.PROPS$
查看表空间、控制、日志、数据文件及备份、读写状态
SELECT * FROM V$TABLESPACE
SELECT * FROM V$CONTORLFILE
SELECT * FROM V$LOGFILE
SELECT * FROM V$DATAFILE
SELECT * FROM V$BACKUP
SELECT * FROM V$FILESTAT
查看归档日志数、路径、进程
SELECT * FROM V$ARCHIVE_LOG
SELECT * FROM V$ARCHIVED_DEST
SELECT * FROM V$ARCHIVE_PROCESSES
查看回滚段名、状态
SELECT * FROM V$ROLLNAME
SELECT * FROM V$POLLSTAT
SELECT * FROM V$RESERVED_WORDS
查看数据库、实例、许可状态、数据库连接
SELECT * FROM V$DATABASE
SELECT * FROM V$INSTANCE
SELECT * FROM V$LICENSE
SELECT * FROM V$DBLINK
查看密码文件用户
SELECT * FROM V$PWFILE_USERS
查看资源限制
SELECT * FROM V$RESOURCE_LIMIT
查看数据库选项、对象参数
SELECT * FROM V$OPTION
SELECT * FROM SYS.ARGUMENT$
查看兼容性
SELECT * FROM V$COMPATIBILITY
查看数据库数据字典(表、视图、索引)
SELECT * FROM V$FIXED_TABLE
SELECT * FROM V$FIXED_VIEW_DEFINITION
SELECT * FROM V$INDEXED_FIXED_COLUMN
查看数据库NLS状态
SELECT * FROM SYS.PROPS$
查看表空间、控制、日志、数据文件及备份、读写状态
SELECT * FROM V$TABLESPACE
SELECT * FROM V$CONTORLFILE
SELECT * FROM V$LOGFILE
SELECT * FROM V$DATAFILE
SELECT * FROM V$BACKUP
SELECT * FROM V$FILESTAT
查看归档日志数、路径、进程
SELECT * FROM V$ARCHIVE_LOG
SELECT * FROM V$ARCHIVED_DEST
SELECT * FROM V$ARCHIVE_PROCESSES
查看回滚段名、状态
SELECT * FROM V$ROLLNAME
SELECT * FROM V$POLLSTAT
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/15745906/viewspace-462809/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/15745906/viewspace-462809/