mysql默认回滚段是多少_默认口令和回滚段信息查询脚本

1.1.检查9i默认用户使用默认口令的脚本

select username "User(s) with Default Password!", account_status "Status"

from dba_users

where password in ('E066D214D5421CCC', -- dbsnmp

'24ABAB8B06281B4C', -- ctxsys

'72979A94BAD2AF80', -- mdsys

'9AAEB2214DCC9A31', -- mdsys

'C252E8FA117AF049', -- odm

'A7A32CD03D3CE8D5', -- odm_mtr

'88A2B2C183431F00', -- ordplugins

'7EFA02EC7EA6B86F', -- ordsys

'9B616F5489F90AD7', -- ordcommon

'4A3BA55E08595C81', -- outln

'F894844C34402B67', -- scott

'3F9FBD883D787341', -- wk_proxy

'79DF7A1BD138CF11', -- wk_sys

'7C9BA362F8314299', -- wmsys

'88D8364765FCE6AF', -- xdb

'F9DA8977092B7B81', -- tracesvr

'9300C0977D7DC75E', -- oas_public

'A97282CE3D94E29E', -- websys

'AC9700FD3F1410EB', -- lbacsys

'E7B5D92911C831E1', -- rman

'AC98877DE1297365', -- perfstat

'66F4EF5650C20355', -- exfsys

'84B8CBCA4D477FA3', -- si_informtn_schema

'D4C5016086B2DC6A', -- sys

'5638228DAF52805F', -- sys

'D4DF7931AB130E37'); -- system

输出结果

User(s) with Default Password! Status

------------------------------ --------------------------------

DBSNMPOPEN

SCOTTOPEN

OUTLNEXPIRED & LOCKED

WMSYSEXPIRED & LOCKED

ORDSYSEXPIRED & LOCKED

ORDPLUGINSEXPIRED & LOCKED

MDSYSEXPIRED & LOCKED

XDBEXPIRED & LOCKED

ODMEXPIRED & LOCKED

ODM_MTREXPIRED & LOCKED

10 rows selected.

1.2.查看9i回滚段信息

set feed off

set pause off

col nm format a7 heading 'Name' trunc

col ex format 999 headin 'NrEx'

col rs format a7 heading 'Size'

col init format 999,999 heading 'Init'

col next format 999,999 heading 'Next'

col mi format 999 heading 'MinE'

col ma format 999999 heading 'MaxE'

col op format 99,999,999 heading 'Opt size'

col pct format 990 heading 'PctI'

col st format a4 heading 'Stat'

col sn format a15 heading 'Segm Name'

col ts format a12 heading 'In TabSpace'

col fn format a45 heading 'File containing header of rbs'

col ow format a4heading 'Ownr'

prompt All Rollback Segments

select segment_name sn, decode(owner,'PUBLIC','Publ','Priv') ow,

tablespace_name ts, name fn

from sys.dba_rollback_segs d, v$datafile f

where d.file_id = f.file#;

prompt

prompt Online Rollback Segments:

select d.segment_name nm,

s.extents ex,

(s.rssize/1024)||'K' rs,

d.initial_extent init,

d.next_extent next,

d.pct_increase pct,

d.min_extents mi,

d.max_extents ma,

optsize op,

decode(d.status,'ONLINE','OnL','OFFLINE','OffL') st

from v$rollname n, v$rollstat s, sys.dba_rollback_segs d

where n.usn = s.usn

andd.segment_name = n.name(+);

set feed on

/* End of eval_rbs.sql */

输出结果All Rollback Segments

Segm NameOwnr In TabSpaceFile containing header of rbs

--------------- ---- ------------ ---------------------------------

SYSTEMPriv SYSTEM/dev/vg_sys/rsystem

_SYSSMU2$Publ UNDOTBS1/dev/vg_undo/rundo1

_SYSSMU3$Publ UNDOTBS1/dev/vg_undo/rundo1

_SYSSMU4$Publ UNDOTBS1/dev/vg_undo/rundo1

_SYSSMU5$Publ UNDOTBS1/dev/vg_undo/rundo1

_SYSSMU6$Publ UNDOTBS1/dev/vg_undo/rundo1

_SYSSMU8$Publ UNDOTBS1/dev/vg_undo/rundo1

_SYSSMU10$Publ UNDOTBS1/dev/vg_undo/rundo1

_SYSSMU11$Publ UNDOTBS1/dev/vg_undo/rundo1

…………………

_SYSSMU371$Publ UNDOTBS1/dev/vg_undo/rundo4

Online Rollback Segments:

NameNrEx SizeInitNext PctI MinEMaxEOpt size Stat

------- ---- ------- -------- -------- ---- ---- ------- ----------- ----

SYSTEM7 440K114,688132765OnL

_SYSSMU100 211064K131,072232765OnL

_SYSSMU89 181368K131,072232765OnL

_SYSSMU88 169080K131,072232765OnL

_SYSSMU72 159864K131,072232765OnL

_SYSSMU84 150648K131,072232765OnL

_SYSSMU67 136312K131,072232765OnL

_SYSSMU77 146552K131,072232765OnL

_SYSSMU76 149624K131,072232765OnL

_SYSSMU61 232568K131,072232765OnL

_SYSSMU78 149624K131,072232765OnL

_SYSSMU79 175224K131,072232765OnL

_SYSSMU85 152696K131,072232765OnL

_SYSSMU52 174200K131,072232765OnL

……………………