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
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
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来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/26477398/viewspace-1431440/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/26477398/viewspace-1431440/