Çë¸ßÊÖÊÖ½øÀ´¿´¿´¡£
µ«ÊDZ¾ÈË·ÖÊý²»¶à¡£Ö»ÄÜÌṩÕâô¶à·ÖÁË¡£
cpu¡¢ÄÚ´æ¡¢Êý¾Ý¿â¿Õ¼äʹÓÃÂÊ£¨±í¿Õ¼äµÄʹÓÃÂÊ£©
ǰÌáÊÇ Í¨¹ýweblogic·þÎñÆ÷ÖеÄEJB»ñµÃ ÒÔÉÏÖµ¡£
ΪʲôûÓÐÈËÀ´°¡£¿
¹Ø×¢¡£¡£¡£¡£
select * from v$process;ÄÚ´æÊ¹ÓÃÂÊ
col SERIAL# format 999999
col sid format 99999
col username format a10
col machine format a12
col program format a32
col sql_text format a81
set lines 1000
set pages 1000
set verify off
col sql_hash_value new_value hash_value head hash_value
select sid,serial#,username,program,sql_hash_value,
to_char(logon_time,'yyyy/mm/dd hh24:mi:ss') as login_time
from v\$session
where paddr in ( select addr from v\$process where spid=$1);
select sql_text
from v\$sqltext_with_newlines
where hash_value = &hash_value
order by piece;
exit;
EOF
HEAP DUMP heap name="pga heap" desc=067D1FE8---ºìÉ«¿ÉÒÔ¿´µ½ÎÒÃÇDUMPµÄÊÇÄĸöHEAP,ÕâÀïDUMPµÄPGA.
extent sz=0x213c alt=84 het=32767 rec=0 flg=2 opc=2
parent=00000000 owner=00000000 nex=00000000 xsz=0x25b8
EXTENT 0 addr=07BEB9A4---EXTENTºÅÒÔ¼°ËüµÄµØÖ·
Chunk 7beb9ac sz= 9648 freeable "kcrr kcrrpdi ar"
Chunk 7beb9ac---ChunkµØÖ·
ÔÚlomboz eclipseÖеÄwindow->show view->others->ÖеÄÔõÑù¼ÓÈëconnectivityÖеÄdata sourceÖÐÁ¬½ÓoracleʱֻÓÐ8,9,10ÕâÈý¸ö°æ±¾£¬ÔõÑù²ÅÄÜÁ¬½Óoracle11Õâ¸ö°æ±¾ÄØ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿
¸½Í¼Æ¬ ......