?? rbs_extents.sql
字號:
--* File Name : RBS_Extents.sql
--* Author : DR Timothy S Hall
--* Description : Displays information about the rollback segment extents.
--* Requirements : Access to the DBA views.
--* Call Syntax : @RBS_Extents
--* Last Modified: 15/07/2000
SET LINESIZE 500
SET PAGESIZE 1000
SET VERIFY OFF
SELECT Substr(a.segment_name,1,30) "Segment Name",
b.status "Status",
Count(*) "Extents",
b.max_extents "Max Extents",
Trunc(b.initial_extent/1024) "Initial Extent (Kb)",
Trunc(b.next_extent/1024) "Next Extent (Kb)",
Trunc(c.bytes/1024) "Size (Kb)"
FROM dba_extents a,
dba_rollback_segs b,
dba_segments c
WHERE a.segment_type = 'ROLLBACK'
AND b.segment_name = a.segment_name
AND b.segment_name = c.segment_name
GROUP BY a.segment_name,
b.status,
b.max_extents,
b.initial_extent,
b.next_extent,
c.bytes
ORDER BY a.segment_name;
SET PAGESIZE 14
SET VERIFY ON
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -