SQL> SELECT name,password FROM user$ WHERE name='VISU_MD0000'; //檢視user,hash表裡的密碼
NAME PASSWORD
------------------------------ ------------------------------
VISU_MD0000 1979CBB6E32F9417

SQL> SELECT * FROM DBA_USERS_WITH_DEFPWD WHERE username='VISU_MD0000'; //檢視username是不是已經修改過，不是原始密碼
no rows selected

--是原始密碼的使用者會被顯示

set linesize 250
SELECT S.sid || ',' || S.serial# sid_serial, S.username, S.osuser, P.spid, S.module,
P.program, SUM (T.blocks) * TBS.block_size / 1024 / 1024 mb_used, T.tablespace,
COUNT(*) statements
FROM v$sort_usage T, v$session S, dba_tablespaces TBS, v$process P
WHERE T.session_addr = S.saddr
AND S.paddr = P.addr
AND T.tablespace = TBS.tablespace_name
GROUP BY S.sid, S.serial#, S.username, S.osuser, P.spid, S.module,
P.program, TBS.block_size, T.tablespace
ORDER BY mb_used;

SID_SERIAL USERNAME OSUSER SPID MODULE
--------------------------------------------------------------------------------- ------------------------------ ------------------------------ ------------------------ ----------------------------------------------------------------
PROGRAM MB_USED TABLESPACE STATEMENTS
------------------------------------------------ ---------- ------------------------------- ----------
25,24493 MD0000 oracle 4587752 oracle@rtdka1odb25.hosting.eu (TNS V1-V3)
oracle@infra2odb02.hosting.eu (P030) 588 TEMP 1

43,111 MD0000 ora10gdb 6619262 oracle@tladbxd5.dktetrix.net (TNS V1-V3)
oracle@infra2odb02.hosting.eu (P024) 763 TEMP 1

206,2519 MD0000 oracle 13238500 oracle@rtdka1odb25.hosting.eu (TNS V1-V3)
oracle@infra2odb02.hosting.eu (P029) 985 TEMP 1

228,38205 MD0000 ora10gdb 11141192 oracle@tladbxd5.dktetrix.net (TNS V1-V3)
oracle@infra2odb02.hosting.eu (P026) 1065 TEMP 1

163,32167 MD0000 ora10gdb 6815988 oracle@tladbxd5.dktetrix.net (TNS V1-V3)
oracle@infra2odb02.hosting.eu (P025) 1277 TEMP 1

JDBC詳解

http://my.oschina.net/hongdengyan/blog/182978

oracle script

JDBC詳解

相關文章