oracle manager database control invalid¡¡start
Æô¶¯“OracleDBConsole”ʱ£££³öÏÖ“Agent process exited abnormally during initialization.”
ÔÚÔËÐÐ"emctl start dbconsole "¡¡·¢ÏÖÊÇÕÒ²»µ½Ö¸¶¨Îļþ,ÔÚÍøÉÏÕÒÁËÒ»ÏÂÔÒò, ¸ü¸ÄµÄÖ¸¶¨Îļþ¼ÐµÄÃû³Æ£¬µ«»¹ÊDz»ÄÜÆô¶¯·þÎñ£¬½á¹ûÈÏÕæ¿´ÁËһϣ¬ÊÇCTRL+C,CTRL+V È»ºó²ÅÆô¶¯³É¹¦£¬ËùÒÔÌض¨Ð´ÏÂÀ´£¬¼Ç¼ÏÂÀ´ÕâЩÐÅÏ¢£»
D:\oracle\product\10.2.0\db_1\localhost_ORCL10G ---CTRL+C,CTRL+VÔÚͬһĿ¼£¬È»ºó¸ü¸ÄÎÄʧ¼ÐÃûΪ“¼ÆËã»úÃû_ORCL10G”
D:\oracle\product\10.2.0\db_1\oc4j\j2ee\OC4J_DBConsole_localhost_ORCL10G---CTRL+C,CTRL+VÔÚͬһĿ¼£¬È»ºó¸ü¸ÄÎļþ¼ÐÃû“OC4J_DBConsole_¼ÆËã»úÃû_ORCL10G”
£££
Ïà¹ØÎĵµ£º
²é¿´Ïà¹ØjobÐÅÏ¢
¡¡¡¡1¡¢Ïà¹ØÊÓͼ
¡¡¡¡dba_jobs
¡¡¡¡all_jobs
¡¡¡¡user_jobs
¡¡¡¡dba_jobs_running °üº¬ÕýÔÚÔËÐÐjobÏà¹ØÐÅÏ¢ ¡¡
²é¿´´æ´¢¹ý³Ì packageµÈÏà¹Ø¹ý³Ì
select * from user_source where text like '%Òª²éµÄÄÚÈÝ%' ......
ºÜ¶àÅóÓÑÔÚʹÓÃORACLE½øÐкǫ́Êý¾Ý´æ´¢Ê±¶¼¿ÉÄÜÓöµ½ÕâÑùµÄÎÊÌ⣬ÄľÍÊÇ£¬Éè¼ÆµÄÊý¾Ý¿âÖв»¿É±ÜÃâµÄÓÐÒ»Á½¸ö±È½Ï´óµÄÊý¾Ý±í£¬ÓÐʱ¿ÉÄܸü¶à£¬Èç¹û¶ÔÕâЩÊý¾Ý±íÖ»½øÐÐINSERT²Ù×÷£¬ÄÄ»¹±È½ÏºÃһЩ£¬¿ÉÊÇÈç¹ûÒª¾³£½øÐÐÊý¾Ý¸üУ¨UPDATE£©ºÍÊý¾ÝÑ¡È¡£¨SELECT£©£¬ÔÚÊý¾ÝÁ¿±È½ÏÉÙʱ£¬³ÌÐò»¹ÄܹýµÄÈ¥£¬Èç¹ûÊý¾ÝÁ¿Ò»´ó£¬ÉÏÁË°ÙÍòÊýÁ¿ ......
v$session + v$session_wait (ÔÚ10gÀ﹦Äܱ»ÕûºÏ,´ÕºÏËã1¸ö°É.)
v$process
v$sql
v$sqltext
v$bh (¸üÄþÔ¸ÊÇx$bh)
v$lock
v$latch_children
v$sysstat
v$system_event
°´×é·ÖµÄ¼¸×éÖØÒªµÄÐÔÄÜÊÓͼ
1¡£System µÄ over view
v$sysstat , v$system_event , v$parameter
2¡£Ä³¸ösession µÄµ±Ç°Çé¿ö
v$process , ......
ORACLEÄÚ²¿º¯Êýƪ
¡¡¡¡ 255. CHARTOROWID(CHAR)
¡¡¡¡ ½«°üº¬ÍⲿÓï·¨ROWIDµÄCHAR»òVARCHAR2Êýֵת»»ÎªÄÚ²¿µÄ¶þ½øÖÆÓï·¨,²ÎÊýCHAR±ØÐëÊÇ°üº¬ÍⲿÓï·¨µÄROWIDµÄ18×Ö·ûµÄ×Ö·û´®.
¡¡¡¡ SELECT NAME from BSEMPMS WHERE ROWID=CHARTOROWID('AAAAfZAABAAACp8AAO');
¡¡¡¡ NAME : LEIXUE
¡¡¡¡ 256. CONVERT(CHAR,DEST_CHA ......
9I¹ÜÀíµÄV$ÊÓͼ¡£
¡¡¡¡281. V$ACCESS
¡¡¡¡ÏÔʾµ±Ç°±»Ëø¶¨µÄÊý¾Ý¿âÖеĶÔÏó¼°ÕýÔÚ·ÃÎÊËûÃǵĻỰ.
¡¡¡¡282. V$ACTIVE_INSTANCES
¡¡¡¡Îªµ±Ç°°²×°µÄÊý¾Ý¿âÖгöÏÖµÄËùÓÐʵÀý½¨Á¢´ÓʵÀýÃûµ½ÊµÀýºÅµÄÓ³Ïñ.
¡¡¡¡283. V$ACTIVE_SESS_POOL_MTH
¡¡¡¡ËùÓлµÄ»á»°³Ø×ÊÔ´·ÖÅä·½·¨.
¡¡¡¡284. V$AQ
¡¡¡¡µ±Ç°Êý¾Ý¿âÖеĶÓÁеÄͳ¼ ......