根据metalink脚本学习undo（二）

来源：互联网发布：充值系统源码php 编辑：程序博客网时间：2024/06/06 00:01

UndoDatafiles.sql

set lines 120set pages 999clear colset termout offset trimout onset trimspool onconnect / as sysdbaalter session set nls_date_format='dd-Mon-yyyy hh24:mi';spool undodatafiles.outpromptprompt  ############## RUNTIME ############## promptcol rdate head "Run Time"select sysdate rdate from dual;prompt prompt  ############## DATAFILES ############## prompt col retention head "Retention"col tablespace_name format a30 head "TBSP Name"col file_id format 999 head "File #"col a format 999,999,999,999,999 head "Bytes Alloc (MB)"col b format 999,999,999,999,999 head "Max Bytes Used (MB)"col autoextensible head "Auto|Ext"col extent_management head "Ext Mngmnt"col allocation_type head "Type"col segment_space_management head "SSM"select tablespace_name,           --undo表空间名称       file_id,                   --文件ID       sum(bytes)/1024/1024 a,    --当前undo表空间大小        sum(maxbytes)/1024/1024 b,  --最大大小       autoextensible             --是否开启自动扩展from dba_data_fileswhere tablespace_name in (select tablespace_name from dba_tablespaces   where retention like '%GUARANTEE' )group by file_id, tablespace_name, autoextensibleorder by tablespace_name//**/spool offset termout onset trimout offset trimspool offclear col

0 0