Oracle±í¿Õ¼äºÍ±íµÄÇø±ð
ORACLEÎïÀíÉÏÊÇÓÉ´ÅÅÌÉϵÄÒÔϼ¸ÖÖÎļþ:Êý¾ÝÎļþºÍ¿ØÖÆÎļþºÍLOGFILE¹¹³ÉµÄ ±í¿Õ¼ä¾Í̸ֻÏà¹ØµÄÊý¾ÝÎļþ Ê×ÏÈÃ÷È·¸ÅÄî:±í¿Õ¼äÊÇORACLEÄÚ²¿¶¨ÒåµÄÒ»¸ö¸ÅÄî,ÊÇΪÁËͳһORACLEÎïÀíºÍÂß¼ ÉϵĽṹ¶øרÃŽ¨Á¢µÄ,´ÓÎïÀíÉÏÀ´Ëµ,Ò»¸ö±í¿Õ¼äÊÇÓɾßÌåµÄÒ»¸ö»ò¶à¸ö´ÅÅÌÉÏÊý ¾ÝÎļþ¹¹³ÉµÄ(ÖÁÉÙ1¶Ô1,¿ÉÒÔ1¶Ô¶à),´ÓÂß¼ÉÏÀ´ËµÒ»¸ö±í¿Õ¼äÊÇÓɾßÌåµÄÒ»¸ö»ò ¶à¸öÓû§Ä£Ê½Ïµıí,Ë÷ÒýµÈµÈÀïÃæµÄÊý¾ÝËù¹¹³ÉµÄ. Òò´Ë´ÓÓû§µÄ½Ç¶ÈÀ´¿´ÊDz»Ó¦¸Ã¿´µ½´ÅÅÌÉÏÎïÀíµÄÊý¾ÝÎļþµÄ,Æä´ÓСµ½´óµÄÊÓ½ÇÊÇ ÕâÑùµÄ¹Øϵ: ×Ö¶ÎÖµ --> ¼Ç¼ֵ --> ±íÊý¾Ý --> Óû§ --> ±í¿Õ¼ä --> ORACLE ¶ø´ÓÒ»¸öORACLE DBAµÄÊÓ½ÇÀ´¿´Ó¦ÊÇÕâÑùµÄ¹Øϵ: Êý¾ÝÎļþ --> ±í¿Õ¼ä --> ORACLE ×ÛºÏÒ»ÏÂ,Ò²¾ÍÊÇ˵ÔÚORACLEÖÐ±í²»¿ÉÄܵ¥¶À´æÔÚ,Ò»¶¨Á¥ÊôÓÚijһ¸öÓû§,¶øijһ Óû§µÄÊý¾Ý±Ø¶¨´æÔÚÓÚij¸ö±í¿Õ¼äÖС£
Ïà¹ØÎĵµ£º
·¢ÏÖһƪ¹ØÓÚÓαêµÄÎÄÕ£¬¸Ð¾õдµÄºÜ²»´í£¬ÏÈÊÕ²ØÁË£»µ«ÊÇÀïÃæÓÐһЩ´íÎó£¬=ÓÐʱ¼äÁËÔÙÕûÀíһϡ£
--------
ÎÒÃǽ«ÌÖÂÛ¸÷ÖÖÓÃÓÚ·ÃÎÊORACLEÊý¾Ý¿âµÄDDLºÍTCLÓï¾ä¡£
²éѯ
SELECTÓï¾äÓÃÓÚ´ÓÊý¾Ý¿âÖвéѯÊý¾Ý£¬µ±ÔÚPL/SQLÖÐʹÓÃSELECTÓï¾äʱ£¬ÒªÓëINTO×Ó¾äÒ»ÆðʹÓ㬲éѯµÄ·µ»ØÖµ±»¸³Ó ......
ÎÒдµÄ½Å±¾£¬ÓеãÂý£¬½«¾Í×ÅÓðÉ
--kill sessionÓï¾ä
alter system kill session'50,492';
--ÒÔϼ¸¸öΪÏà¹Ø±í
SELECT * from v$lock;
SELECT * from v$sqlarea;
SELECT * from v$session;
SELECT * from v$process ;
SELECT * from v$locked_object;
SELECT * from all_ ......
oracle
Îóɾ³ýÈÕÖ¾ÎļþºóµÄ´¦Àí·½·¨£¡
½â¾ö·½·¨±³¾°
1
ÕûÀíc
Å̵ÄÀ¬»øÎļþ£¬°Éoralce
µÄ¡£log
ÈÕÖ¾Îļþɾ³ý¡£
2
È»ºóoralce
Ò»Ö±²»ÄÜʹÓã¬Ìáʾtns
ÓÐÎÊÌ⣬
È»ºóÔÙÍùÉÏÕÒ×ÊÁÏ£¬Ò»Ö±Ã»Óнâ¾öµô£¬ºóÀ´¿´µ½Ò»±ßÎÄÕÂÈçÏ£¬ÎÊÌâ½â¾öµôÁË£¬Ìغʹó¼Ò·ÖÏí£¡
======================================== ......
ÔÚoracleÖУ¬ÓÐ4¸ö´ó¶ÔÏó£¨lobs£©ÀàÐÍ¿ÉÓ㬷ֱðÊÇblob,clob,bfile,nclob¡£
¡¡¡¡ÏÂÃæÊǶÔlobÊý¾ÝÀàÐ͵ļòµ¥½éÉÜ¡£
¡¡¡¡ blob:¶þ½øÖÆlob£¬Îª¶þ½øÖÆÊý¾Ý£¬×¿É´ï4GB£¬´æÖüÔÚÊý¾Ý¿âÖС£
¡¡¡¡ clob:×Ö·ûlob,×Ö·ûÊý¾Ý,×¿ÉÒÔ´ïµ½4GB,´æÖüÔÚÊý¾Ý¿âÖС£
¡¡¡¡ bfile:¶þ½øÖÆÎļþ;´æÖüÔÚÊý¾Ý¿âÖ®ÍâµÄÖ»¶ÁÐͶþ½øÖÆÊý¾Ý£¬×î´ó³¤ ......