some rollback segments have a status of "unknown"
From: Jeffrey Beckstrom <JBECKSTROM_at_gcrta.org>
Date: Mon, 19 Dec 2011 11:38:31 -0500
Message-Id: <4EEF22370200000B004E12EA_at_groupwise.gcrta.org>
Ran the below query and it is showing 4 segments with a status of "unknown". What does this status mean?
13 -- t1.EXTENDS,
14 -- t1.WRAPS,
15 t1.STATUS
16 from v$rollstat t1, v$rollname t2
17 where t1.usn=t2.usn
18 -- and name != 'SYSTEM'
19* order by name
JBECKSTROM_at_or01>@rollback_anal ( mailto:JBECKSTROM_at_or01 )
Date: Mon, 19 Dec 2011 11:38:31 -0500
Message-Id: <4EEF22370200000B004E12EA_at_groupwise.gcrta.org>
Ran the below query and it is showing 4 segments with a status of "unknown". What does this status mean?
JBECKSTROM_at_or01>l ( mailto:JBECKSTROM_at_or01 )
1 select t2.NAME, t1.XACTS,
2 -- EXTENTS,
3 -- rs.initial_extent/1024/1024 m_init,
4 t1.RSSIZE/1024/1024 m_RSSIZE, 5 -- t1.OPTSIZE/1024/1024 m_OPTSIZE, 6 t1.HWMSIZE/1024/1024 m_HWMSIZE, 7 -- t1.AVESHRINK/1024/1024 m_avgshrink, 8 t1.AVEACTIVE/1024/1024 m_avgactive, 9 -- t1.GETS, 10 t1.WAITS, 11 -- abs(t1.WRITES) WRITES, 12 -- t1.SHRINKS,
13 -- t1.EXTENDS,
14 -- t1.WRAPS,
15 t1.STATUS
16 from v$rollstat t1, v$rollname t2
17 where t1.usn=t2.usn
18 -- and name != 'SYSTEM'
19* order by name
JBECKSTROM_at_or01>@rollback_anal ( mailto:JBECKSTROM_at_or01 )
m cur M M Avg NAME ACT size HWM active WAITS STATUS --------------------- ---- ------- ------- ------- ------ ---------- SYSTEM 0 2.0 2.0 .0 0 ONLINE
_SYSSMU36_1304178007$ 0 23.4 128.7 1.6 415 UNKNOWN
_SYSSMU37_1304178007$ 0 72.1 128.1 21.6 539 ONLINE
_SYSSMU38_1304178007$ 0 28.1 147.1 67.5 536 UNKNOWN
_SYSSMU39_1304178007$ 0 23.6 128.1 1.2 324 ONLINE
_SYSSMU40_1304178007$ 0 23.1 137.0 34.7 624 ONLINE
_SYSSMU41_1304178007$ 0 24.1 259.1 1.1 290 ONLINE
_SYSSMU42_1304178007$ 0 32.1 126.2 3.2 324 ONLINE
_SYSSMU43_1304178007$ 0 38.2 152.8 4.6 492 UNKNOWN
_SYSSMU44_1304178007$ 0 39.1 180.1 7.8 312 ONLINE
_SYSSMU45_1304178007$ 0 .1 666.3 2.8 316 ONLINE
_SYSSMU46_1304178007$ 1 80.1 129.9 9.4 476 ONLINE
_SYSSMU47_1304178007$ 1 23.1 136.2 10.5 356 ONLINE
_SYSSMU48_1304178007$ 0 51.1 188.1 3.6 264 ONLINE
_SYSSMU49_1304178007$ 0 72.1 124.6 14.4 376 ONLINE
_SYSSMU50_1304178007$ 0 24.1 127.9 27.8 252 ONLINE
_SYSSMU51_1304178007$ 0 19.1 101.7 1.2 523 ONLINE
_SYSSMU52_1304178007$ 0 31.9 155.1 1.7 372 ONLINE
_SYSSMU53_1304178007$ 0 38.2 176.1 2.8 525 ONLINE
_SYSSMU54_1304178007$ 0 32.1 186.1 12.0 686 ONLINE
_SYSSMU55_1304178007$ 0 120.2 242.1 19.6 256 ONLINE
_SYSSMU56_1304178007$ 0 104.1 188.1 18.8 584 ONLINE
_SYSSMU57_1304178007$ 0 80.1 116.6 9.3 548 ONLINE
_SYSSMU58_1304178007$ 0 24.1 204.9 36.7 188 UNKNOWN
_SYSSMU59_1304178007$ 0 23.1 85.0 1.1 0 ONLINE
_SYSSMU60_1304178007$ 1 29.1 150.4 48.0 25 ONLINE
_SYSSMU61_1304178007$ 0 23.6 29.0 1.4 0 ONLINE
_SYSSMU62_1304178007$ 1 72.4 191.7 11.1 59 ONLINE
28 rows selected.
JBECKSTROM_at_or01>
Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional Transit Authority
Information Systems
1240 W. 6th Street
Cleveland, Ohio 44113
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Dec 19 2011 - 10:38:31 CST