【记各类高级sql使用记录】

Oracle归档日志查看

SELECT
	A . NAME AS "日志存储位置",
	A .SPACE_LIMIT / 1024 / 1024 / 1024 AS "最大可存储空间(GB)",
	CAST (
		A .SPACE_USED / 1024 / 1024 AS DECIMAL (20, 2)
	) AS "已使用空间(MB)"
FROM
	(
		SELECT
			*
		FROM
			v$recovery_file_dest
	) A

Oracle查看正在运行的Sql

select sl.INST_ID,
       x.sid,
       x.USERNAME,
       x.SQL_ID,
       X.EVENT,
       x.session_time "会话小时",
       x.etime || 's' "etime",
       decode(TRUNC(sl.sofar / sl.totalwork * 100, 2),
              null,
              null,
              '****' || TRUNC(sl.sofar / sl.totalwork * 100