ORACLE»ØÊÕÕ¾
ÔÚÖ´ÐÐÒ»¸ö´æ´¢¹ý³Ì½¨±íʱ£¬³öÏÖÁËÕâ¸öORA-38301:ÎÞ·¨¶Ô»ØÊÕÕ¾ÖеĶÔÏóÖ´ÐÐDDL/DML´íÎó¡£·¢ÏÖÔÀ´ÕâÊÇ10GµÄÒ»¸öÐÂÌØÐÔ£¬»ØÊÕÕ¾¡£¶ÔÓÚdropµÄ±í²¢²»ÊÇÖ±½Óɾ³ýµôµÄ¡£¶øÊÇ·ÅÔÚ»ØÊÕÕ¾ÖÐÁË¡£RecycleBin¡£
¿ÉÊÇÔÚ»ØÊÕÕ¾ÖÐûÓв鵽Õâ¸ö±í¡£
select * from recyclebin;
ºÜÆæ¹Ö¡£
½øÐÐɾ³ý²Ù×÷¡£
½øÐÐɾ³ýºó£¬»¹ÊDz»ÄܶԸñíÖؽ¨£¬±¨´í¸Ã¶ÔÏóÒѾ´æÔÚ¡£
´Ó»ØÊÕÕ¾Öвéѯ¸Ã±í£¬±¨³ö¸ö
ORA-00600: ÄÚ²¿´íÎó´úÂë, ²ÎÊý: [ktsircinfo_num1
¹ÖÁË¡£ÍøÉϺܶàÈË˵ÊÇoracleÄÚ²¿×Ô¼ºµÄÎÊÌ⡣û°ì·¨£¬ÖØÆôÊý¾Ý¿âÊÔÒ»°ÑÁË¡£½á¹ûÖØÆôºó£¬ÄǸö±íÒѾ²»ÔÚÊý¾Ý¿âÖдæÔÚÁË¡£ÎÊÌâ½â¾öÁË¡£
¼Ç¼Ï»ù±¾µÄ»ØÊÕÕ¾²Ù×÷£º
ÒѾ·Åµ½»ØÊÕÕ¾ÀïµÄ±íÊDz»ÄÜÓÃdropÃüÁîɾ³ýµÄ(×¢Òâ¶ÔÏóÃû×ÖÉϵÄË«ÒýºÅ)
Èç¹ûÒªÇåµô¸Ã¶ÔÏó,ʹÓÃpurgeÃüÁ
SQL> PURGE table "BIN$V3f/oYUITrCEF2cotS5JaA==$0" ;
Èç¹ûÖ±½ÓÇå¿ÕËùÓеÄRecycle BinÖеĶÔÏó£º
Ïà¹ØÎĵµ£º
shutdown immediate
Ç¿Áв»½¨ÒéתΪ·Ç¹éµµÄ£Ê½
startup mount
alter database noarchivelog
alter database open
·Ç¹éµµ×ª¹éµµ
startup mount
alter database archivelog
alter database open
Ôڹ鵵ÈÕ־ģʽÏ£¬ÓпÉÄÜ»áÓöµ½¹éµµÈÕÖ¾´óС³¬¹ý×î´óÖµ¶ø³öÏÖÌÖÑáµÄORA-00257´íÎó£¬Ç°Ãæ˵ÁËÈçºÎ°Ñ¹éµµÈÕÖ¾¿Õ¼ä±ä´ó¡£¶ ......
ORACLEÀïËøÓÐÒÔϼ¸ÖÖģʽ:
0£ºnone
1£ºnull ¿Õ
e.g. 1¼¶ËøÓУºSelect£¬ÓÐʱ»áÔÚv$locked_object³öÏÖ¡£
2£ºRow-S Ðй²Ïí(RS)£º¹²Ïí±íËø£¬sub share
e.g. 2¼¶ËøÓУºSelect for update,Lock For Update,Lock Row Share
  ......
Ò»¡¢ÉèÖóõʼ»¯²ÎÊý job_queue_processes
¡¡¡¡sql> alter system set job_queue_processes=n;£¨n>0£©
¡¡¡¡job_queue_processes×î´óֵΪ1000
¡¡¡¡
¡¡¡¡²é¿´job queue ºǫ́½ø³Ì
¡¡¡¡sql>select name,description from v$bgprocess;
¡¡¡¡
¡¡¡¡¶þ£¬dbms_job package Ó÷¨½éÉÜ
¡¡¡¡°üº¬ÒÔÏÂ×Ó¹ý³Ì£º
¡¡¡¡
¡¡ ......