oracle Êý¾Ý×ÖµäÊÓͼ֮ DICT / DICTIONARY
1.µ±ÄãÃÍÈ»¼äÍü¼Çͨ¹ýʲôÊÓͼ¿ÉÒԲ鿴procedureÄÚÈÝʱ£¬ÒþÔ¼¼ÇµÃËùÐèµÄÊÓͼ°üº¬“SOUR”×ֶΣ¬´Ëʱ²éѯdict/dictionaryÊÓͼÊÇ×îºÃµÄÑ¡Ôñ
sys@ora10g> col COMMENTS for a78
sys@ora10g>select * from dict where TABLE_NAME like '%SOUR%';
TABLE_NAME COMMENTS
------------------------------ -----------------------------------------------------------
USER_RESOURCE_LIMITS Display resource limit of the user
ALL_SOURCE_TABLES Source tables available for Change Data Capture
DBA_SOURCE_TABLES Source tables available for Change Data Capture
USER_SOURCE_TABLES Source tables available for Change Data Capture
USER_SOURCE Source of stored objects accessible to the user
ALL_SOURCE Current source on stored objects that user is allowed to create
DBA_SOURCE Source of all stored objects in the database
DBA_TSM_SOURCE Transparent session migration source session statistics
DBA_HIST_RESOURCE_LIMIT Resource Limit Historical Statistics Information
DBA_RESOURCE_INCARNATIONS Resource incarnations that are running or eligible for HA status notification
RESOURCE_C
Ïà¹ØÎĵµ£º
ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
Ê×ÏÈ£¬Ô ......
¸Õ²ÅÔÚEYGLEµÄ²©¿ÍÖп´µ½Ò»ÆªÌû×Ó£¬½²µÄÊÇDELETEµÄ²Ù×÷Á÷³Ì£¬ºÜ¼ò¶Ì£¬Í¬Ê±Ò²¾«±Ù¡£
===================================================================================
OracleÖУ¬Ò»¸öDelete²Ù×÷µÄÁ÷³Ì
ɾ³ý(DELETE)
1.Oracle¶ÁBlockµ½Buffer Cache(Èç¹û¸ÃBlockÔÚBufferÖв»´æÔÚ)
2.ÔÚredo log bufferÖмǼdelet ......
oracleÊý¾Ý¿âÊÇÖØÁ¿¼¶µÄ£¬Æä¹ÜÀí·Ç³£¸´ÔÓ£¬½«ÆäÔÚlinuxƽ̨ÉÏµÄÆô¶¯ºÍ¹Ø±Õ²½ÖèÕûÀíһϡ£
°²×°Íê±ÏoracleÒÔºó£¬ÐèÒª´´½¨oracleϵͳÓû§£¬
²¢ÔÚ/home/oracleÏÂÃæµÄ.bash_profileÌí¼Ó¼¸¸ö»·¾³±äÁ¿£º
ORACLE_SID,ORACLE_BASE,ORACLE_HOME¡£
±ÈÈ磺
export ORACLE_SID=test export ORACLE_BASE=oracle_install_di ......
ÔÚoracleÊý¾Ý¿âÖвåÈëÊý¾Ýʱ£¬ÔËÐвåÈëÓï¾ä£¬ÏÈÊǰÑÊý¾Ý·ÅÈëµ½»º´æÖУ¬ÕâʱÊý¾Ý²¢Ã»ÓÐÕæÕýµÄ½øÈëÊý¾Ý¿â£¬ÕâÊÇoracleÊý¾Ý¿â¸úÆäËüÊý¾Ý¿âÖеIJ»Í¬µã£¬ÕâÊÇÒªÔËÐÐcommitÕâ¸öÊÂÎñÌá½»£¬²ÅÄÜÕæÕýµÄ°ÑÊý¾Ý·Åµ½Êý¾Ý¿âÖС£ ......
EXPºÍIMPÊÇOracleÌṩµÄÒ»ÖÖÂß¼±¸·Ý¹¤¾ß¡£Âß¼±¸·Ý´´½¨Êý¾Ý¿â¶ÔÏóµÄÂß¼¿½±´²¢´æÈëÒ»
¸ö¶þ½øÖÆ×ª´¢Îļþ¡£ÕâÖÖÂß¼±¸·ÝÐèÒªÔÚÊý¾Ý¿âÆô¶¯µÄÇé¿öÏÂʹÓÃ,
Æäµ¼³öʵÖʾÍÊǶÁȡһ¸öÊý¾Ý¿â¼Ç¼¼¯£¨ÉõÖÁ¿ÉÒÔ°üÀ¨Êý¾Ý×ֵ䣩²¢½«Õâ¸ö¼Ç¼¼¯Ð´ÈëÒ»¸öÎļþ,ÕâЩ¼Ç¼µÄµ¼³öÓëÆäÎïÀíλÖÃÎ޹أ¬µ¼ÈëʵÖʾÍÊǶÁȡת´¢Îļþ²¢
Ö´Ð ......