db_profile.sql

来自「Oracle RMAN scripts, windows下Oracle RMAN」· SQL 代码 · 共 52 行

conn / as sysdba
	WHENEVER SQLERROR EXIT 1
	SET TAB OFF
	SET PAGESIZE 5000
	SET LINESIZE 500
	SET FEEDBACK OFF
	col file_name format a450
	
	prompt
	prompt
	prompt The data file Info
	prompt
	prompt
	SELECT file_id, tablespace_name ,
	       RPAD(file_name, 259) file_name    --the character complemented is space
	FROM sys.dba_data_files
	WHERE status = 'AVAILABLE'
	ORDER BY tablespace_name, file_id;

	prompt
	prompt
	prompt The temp file Info
	prompt
	prompt
	SELECT file_id, tablespace_name ,
	       RPAD(file_name, 259) file_name    --the character complemented is space
	FROM sys.dba_temp_files
	WHERE status = 'AVAILABLE'
	ORDER BY tablespace_name, file_id;

	prompt
	prompt
	prompt The users Info
	prompt
	prompt
	SELECT username , default_tablespace , temporary_tablespace ,
		TO_CHAR(created,'yyyy.mm.dd hh24:mi:ss') Created_date
	FROM sys.dba_users
	ORDER BY created;

	prompt
	prompt
	prompt The log file Info
	prompt
	prompt
	col logfile_name format a100
	SELECT a.group#, a.thread#, a.bytes, a.members, a.status, a.sequence#, b.member logfile_name
	FROM sys.v_log a , sys.v_logfile b
	WHERE a.group# = b.group#
	ORDER BY a.group#,a.members;

	EXIT 0