TA的每日心情 | 开心 2023-8-9 11:05 |
---|
|
- SET ECHO OFF
- SET FEEDBACK ON
- SET HEADING ON
- SET LINESIZE 180
- SET PAGESIZE 2000
- SET TIMING OFF
- SET TRIMSPOOL ON
- SET VERIFY OFF
- CLEAR COLUMNS BREAKS COMPUTES
- BREAK ON instance_name ON thread#
- COLUMN instance_name FORMAT a20 HEADING 'Instance Name'
- COLUMN thread# FORMAT 999 HEADING 'Thread#'
- COLUMN group# FORMAT 999 HEADING 'Group#'
- COLUMN member FORMAT a60 HEADING 'Member'
- COLUMN type FORMAT a10 HEADING 'Type'
- COLUMN status FORMAT a15 HEADING 'Status'
- COLUMN bytes FORMAT 999,999 HEADING 'LogSize MB'
- COLUMN archived FORMAT a20 HEADING 'Archived'
- SELECT
- i.instance_name
- , i.thread#
- , f.group#
- , f.member
- , f.type
- , l.status
- , l.bytes/1024/1024 bytes
- , l.archived
- FROM
- gv$logfile f
- , gv$log l
- , gv$instance i
- WHERE
- f.group# = l.group#
- AND l.thread# = i.thread#
- AND i.inst_id = f.inst_id
- AND f.inst_id = l.inst_id
- ORDER BY
- i.instance_name
- , f.group#
- , f.member
- /
复制代码
|
|