ANBOB™

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 – Production
With the Partitioning, OLAP and Data Mining options

sys@ORCL> select * from dict where table_name like ‘DBA_ROLLBACK%’;

TABLE_NAME
——————————
COMMENTS
——————————————————————————————————————————————————
DBA_ROLLBACK_SEGS
Description of rollback segments

sys@ORCL> DESC DBA_ROLLBACK_SEGS;
SP2-0749: Cannot resolve circular path of synonym “DBA_ROLLBACK_SEGS”
sys@ORCL> DESC DBA_USERS;
Name                                                                                Null?    Type
———————————————————————————– ——– ——————————————————–
USERNAME                                                                            NOT NULL VARCHAR2(30)
USER_ID                                                                             NOT NULL NUMBER
PASSWORD                                                                                     VARCHAR2(30)
ACCOUNT_STATUS                                                                      NOT NULL VARCHAR2(32)
LOCK_DATE                                                                                    DATE
EXPIRY_DATE                                                                                  DATE
DEFAULT_TABLESPACE                                                                  NOT NULL VARCHAR2(30)
TEMPORARY_TABLESPACE                                                                NOT NULL VARCHAR2(30)
CREATED                                                                             NOT NULL DATE
PROFILE                                                                             NOT NULL VARCHAR2(30)
INITIAL_RSRC_CONSUMER_GROUP                                                                  VARCHAR2(30)
EXTERNAL_NAME                                                                                VARCHAR2(4000)

sys@ORCL> show parameter undo

NAME                                 TYPE        VALUE
———————————— ———– ——————————
undo_management                      string      AUTO
undo_retention                       integer     900
undo_tablespace                      string      UNDOTBS2

dba_rollback_segs 内容

select un.name, decode(un.user#,1,’PUBLIC’,’SYS’),
ts.name, un.us#, f.file#, un.block#,
s.iniexts * ts.blocksize,
decode(bitand(ts.flags, 3), 1, to_number(NULL),
s.extsize * ts.blocksize),
s.minexts, s.maxexts,
decode(bitand(ts.flags, 3), 1, to_number(NULL),
s.extpct),
decode(un.status$, 2, ‘OFFLINE’, 3, ‘ONLINE’,
4, ‘UNDEFINED’, 5, ‘NEEDS RECOVERY’,
6, ‘PARTLY AVAILABLE’, ‘UNDEFINED’),
decode(un.inst#, 0, NULL, un.inst#), un.file#
from sys.undo$ un, sys.seg$ s, sys.ts$ ts, sys.file$ f
where un.status$ != 1
and un.ts# = s.ts#
and un.file# = s.file#
and un.block# = s.block#
and s.type# in (1, 10)
and s.ts# = ts.ts#
and un.ts# = f.ts#
and un.file# = f.relfile#

后来干脆跑下sys@ORCL> @?/rdbms/admin/catalog.sql

重建一下数据字典。再查可以了

sys@ORCL> DESC DBA_ROLLBACK_SEGS;
Name                                                                                Null?    Type
———————————————————————————– ——– ——————————————————–
SEGMENT_NAME                                                                        NOT NULL VARCHAR2(30)
OWNER                                                                                        VARCHAR2(6)
TABLESPACE_NAME                                                                     NOT NULL VARCHAR2(30)
SEGMENT_ID                                                                          NOT NULL NUMBER
FILE_ID                                                                             NOT NULL NUMBER
BLOCK_ID                                                                            NOT NULL NUMBER
INITIAL_EXTENT                                                                               NUMBER
NEXT_EXTENT                                                                                  NUMBER
MIN_EXTENTS                                                                         NOT NULL NUMBER
MAX_EXTENTS                                                                         NOT NULL NUMBER
PCT_INCREASE                                                                                 NUMBER
STATUS                                                                                       VARCHAR2(16)
INSTANCE_NUM                                                                                 VARCHAR2(40)
RELATIVE_FNO                                                                        NOT NULL NUMBER

打赏

微信扫一扫，打赏作者吧～