Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ÈçºÎ´ÓOracleÊý¾Ý¿â·þÎñÆ÷ÖлñµÃÒÔÏÂÖµ¡£¼±¡£Çó¾È

Çë¸ßÊÖÊÖ½øÀ´¿´¿´¡£
  µ«Ê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µØÖ·


Ïà¹ØÎÊ´ð£º

oracle sql developer ²éѯÏÔʾÖÐÎÄÂÒÂë

»·¾³£º1.win2003server+oracle9i
2.oracle9i×Ö·û¼¯ÎªAMERICAN_AMERICA.WE8ISO8859P1
3.oracle sql developer°æ±¾ 1.5.5
ÏÖÏóÃèÊö: 1.ÔÚsql developer ÖвéѯoracleÖеÄij¸ö±í£¬ÖÐÎÄÈ«²¿ÏÔʾΪÂÒÂë¡£ ......

¹òÇó lomboz eclipse ÖмÓÈëoracleµÄÎÊÌâ

ÔÚlomboz eclipseÖеÄwindow->show view->others->ÖеÄÔõÑù¼ÓÈëconnectivityÖеÄdata sourceÖÐÁ¬½ÓoracleʱֻÓÐ8,9,10ÕâÈý¸ö°æ±¾£¬ÔõÑù²ÅÄÜÁ¬½Óoracle11Õâ¸ö°æ±¾ÄØ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿
¸½Í¼Æ¬ ......

oracle ·¢Óʼþ´íÎó

ÏÂÃæ´æ´¢¹ý³ÌÖ´ÐкóÓдíÎó£¬
create or replace procedure test_mail(msg_subject in varchar2,
                            mes_co ......

oracle·þÎñ״̬ÏÔʾ ¡°Í£Ö¹¡±

ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£

ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......

¸ß·ÖÇë½Ì oracle Òì³£µÄ²¶»ñÎÊÌâ

ÎÒÏÈ˵Ã÷Ò»ÏÂÇé¿ö£ºÓÐÒ»¸örec1.batµÃÅú´¦ÀíÎļþÀï±ß´úÂëÈçÏ£º
SET ORACLE_SID=TosmecDB
sqlPLUS /nolog  "@c:\tosmec\sys\syscom\TosmecHotSub1.sql"

TosmecHotSub1.sqlµÄÎļþÄÚÈÝÈçÏ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ