oracle Ó¦ÓóÌÐòÐÔÄÜ·ÖÎö
²é¿´sessionµÈ´ýʼþ£º
select sid,event from v$session_wait where event not like 'rdbms%' and event not like 'SQL*Net message%';
°´pid²é¿´ÕýÔÚÖ´ÐеijÌÐò£º
select sid,program from v$session b where paddr in (select addr from v$process where spid=&pid);
°´pid²é¿´ÕýÔÚÖ´ÐеÄsqlÓï¾ä
select sql_text from v$sqltext where hash_value in (select sql_hash_value from v$session where
PADDR in (select addr from v"$process where spid=$pid)) order by piece;
Ïà¹ØÎĵµ£º
Oracle Êý¾Ý¿â 11gÃæÏò DBA ºÍ¿ª·¢ÈËÔ±µÄÖØÒªÐÂÌØÐÔ:SecureFiles£º
1¡¢SecureFiles£ºÐ LOB
Á˽âÈçºÎʹÓÃÐÂÒ»´ú LOB£ºSeureFiles¡£SecureFiles ¼¯ÍⲿÎļþºÍÊý¾Ý¿â LOB ·½·¨µÄÓŵãÓÚÒ»Éí£¬¿ÉÒÔ´æ´¢·Ç½á¹¹»¯Êý¾Ý£¬ÔÊÐí¼ÓÃÜ¡¢Ñ¹Ëõ¡¢Öظ´Ïû³ýµÈµÈ¡£
Êý¾Ý¿âפÁô BLOBS »ò OS Îļþ
ÄúÔÚ Oracle Êý¾Ý¿âÖÐ ......
Oracle ×Ö¶ÎÀàÐÍ
×Ö¶ÎÀàÐÍ
ÃèÊö
×ֶγ¤¶È¼°Æäȱʡֵ
CHAR (size )
ÓÃÓÚ±£´æ¶¨³¤(size)×Ö½ÚµÄ×Ö·û´®Êý¾Ý¡£
ÿÐж¨³¤£¨²»×㲿·Ö²¹Îª¿Õ¸ñ£©£»×î´ó³¤¶ÈΪÿÐÐ2000×Ö½Ú£¬È±Ê¡ÖµÎªÃ¿ÐÐ1×Ö½Ú¡£ÉèÖó¤¶È(size)ǰÐ迼ÂÇ×Ö·û¼¯Îªµ¥×Ö½Ú»ò¶à×Ö½Ú¡£
VARCHAR2 (size )
ÓÃÓÚ±£´æ±ä³¤µÄ×Ö·û´®Êý¾Ý¡£ÆäÖÐ×î´ó×Ö½Ú³¤ ......
SQLProgressÊÇÒ»¸öСÇɵIJÙ×÷Êý¾Ý¿âµÄ¹¤¾ß£¬ËùÓеİ汾¶¼²»³¬¹ý3M£¬°üÀ¨ÏÖÔÚ×îеÄ34°æ±¾¡£33ÒÔ¼°ÒÔǰµÄ°æ±¾ÐèÒª°²×°BDE²ÅÄÜÔËÐУ¬´Ó34¿ªÊ¼£¬Ö»Ö§³ÖOracleÊý¾Ý¿â£¬²ÉÓÃODAC×÷ΪÊý¾Ý¿â·ÃÎʵĽӿڣ¬Ö»ÐèÒªÒ»¸ö²»µ½3MµÄ¿ÉÖ´ÐÐÎļþ¾Í¿ÉÒÔ¶ÔÊý¾Ý¿â½øÐвÙ×÷£¬ÆäËûʲô¶¼Óð²×°¡£¸Ã°æ±¾ÊÇÔÚSQLProgress1.01.33»ù´¡ÉÏÐ޸ĵģ¬33ÊÇBD ......
ºÃ¾Ã¾ÍÏë¿´oracleÁË£¬ÓÉÓÚ×Ô¼ºÌ«ÀÁ£¬×î½ü²Å¿ªÊ¼¡£Ï£ÍûÒÔºóÄÜÑø³ÉºÃϰ¹ß¡£
Ò»¡¢oracle 10g ·þÎñÆ÷
1.Ò»¸öoracle 10g·þÎñÆ÷°üº¬Ò»¸öoracleÊý¾Ý¿âºÍÒ»¸öoracle·þÎñÆ÷ʵÀý¡£
2.ÿµ±Êý¾Ý¿âÆô¶¯Ê±ºò£¬ÏµÍ³È«¾ÖÇø£¨SGA£©±»·ÖÅ䣬²¢Æô¶¯ÁËoracleºǫ́½ø³Ì¡£SGAÊÇÓÃÓÚÊý¾Ý¿âÓû§¹²ÏíÊý¾Ý¿âÐÅÏ¢µÄÄÚ´æÇøÓ ......
-----------------------------------------------------------------------------------
DOS:
1. sqlplus
2.
Óû§Ãû:sqlplus ¡¢conn
ÃÜÂë:as sysdba ¡¢as sysdba
½âËø£º
3. ALTER USER DBSNMP ACCOUNT UNLOCK£»
½âËø£ºsystem
4. alter user system identified by manage ......