Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

×ß½üOracleÊý¾Ý×Öµä(¶þ)

 ÔÚÉÏÆªÎÄÕÂÀï“×ß½üOracleÊý¾Ý×Öµä--Êý¾Ý×Öµä±í”£¬ÎÒÃÇ̸µ½ÁËÊý¾Ý×Öµä¶ÔÓÚÎÒÃÇ×÷ΪDBA¶ÔÊý¾Ý¿âά»¤µÄÖØÒªÐÔ¡£Êý¾Ý¿âµÄ¶ÔÏóÐÅÏ¢£¬±ÈÈç±í£¬Óû§£¬´æ´¢¹ý³Ì£¬º¯Êý£¬ÊÓͼ£¬Ë÷ÒýµÈµÈ£¬ÕâЩ´æÔÚÔÚÊý¾Ý¿âÀïµÄ¶ÔÏóµÄÐÅÏ¢£¬¶¼ÊÇÔÚÊý¾Ý×Öµä±íÀï½øÐÐά»¤µÄ£¬ÎÒÃÇ¿ÉÒÔ½èÓÃһЩ±È½ÏºÃµÄOracle¿ª·¢¹¤¾ß±ÈÈçPLSQL dev»òÕßTOAD²é¿´ËûÃÇ£¬»òÕßÖ±½Óͨ¹ý¶ÔÊý¾Ý×Öµä±í½øÐÐsql²éѯ£¬´Ó¶ø»ñµÃ¶ÔÏóµÄÐÅÏ¢¡£ ²»¹ýÔÚÊý¾Ý¿âµÄmetaÐÅÏ¢À³ýÁËÕâЩ¶ÔÏó¾²Ì¬¶ÔÏóµÄÕâЩÐÅÏ¢ÒÔΪ£¬Êý¾Ý¿âÔËÐÐÊǵÄһЩÐÅÏ¢¶ÔÓÚÎÒÃÇÀ´ËµÒ²ÊǷdz£ÓаïÖúµÄ£¬Ò²¸üΪÓÐÒâÒå¡£ ±ÈÈ磬ÓжàÉÙ¸ösession£¬ÓÐʲôÑùµÄprocessÔÚʵÀýÀïÔËÐУ¬ÏµÍ³µÄ״̬ÏÖÔÚÊÇÈçºÎµÄ£¬ ¿ÉÒÔ¿´µ½ÕâЩÐÅÏ¢¶¼ÊÇʵÀýÔËÐÐʱµÄ¶¯Ì¬ÐÅÏ¢£¬²»Êǹ̶¨µÄÐÅÏ¢£¬²»Í¬µÄʱ¿Ì¿ÉÄÜÐÅÏ¢Ò²ÊDz»Ò»ÑùµÄ£¬ OracleΪÁ˽øÐÐά»¤µÄʱºòÄܹ»µÃÖªÕâЩʵÀýµÄÕâЩÀàËÆ×´Ì¬Ò»ÑùµÄ¶¯Ì¬µÄÐÅÏ¢£¬Ìṩ߷¶¯Ì¬ÐÔÄÜÊÓͼ£¬Í¨¹ýÕâ¸ö¶¯Ì¬ÐÔÄÜÊÓͼÎÒÃÇ¿ÉÒÔÁ˽⵽ʵÀýÄÚ²¿µÄһЩ¶¯Ì¬±ä»¯µÄ״̬ÐÅÏ¢¡£ 
¶¯Ì¬ÐÅÏ¢ÊÓͼҲÊÇÊý¾Ý×ÖµäµÄÒ»ÖÖ£¬ÌṩÐÅϢά»¤µÄ×÷Ó㬲»¹ýºÍÎÒÃÇÉÏÒ»¸öÎÄÕÂÌáµ½µÄ“Êý¾Ý×Öµä±í”Ò»ÑùÒ²¿ÉÒÔÔÚdictionaryÀïÕÒµ½£¬¿ªÍ·Îªv$µÄ¶¼ÊÇÎÒÃÇÕâÀïÌáµ½µÄ¶¯Ì¬ÐÔÄÜÊÓͼ¡£ Ò»Ñù£¬Õâ¸öÊÇÒ»¸öpublicµÄͬÒå´Ê£¬ÎÒÃÇÒÔv$sessionÕâ¸ö´ó¼Ò±È½ÏÊìϤµÄÊÓͼΪÀý£¬Ò»Æð×ß½øÈ¥¿´¿´¡£
SQL>  select OWNER,OBJECT_NAME, OBJECT_TYPE from all_objects where object_name = 'V$SESSION';
OWNER                          OBJECT_NAME                    OBJECT_TYPE
------------------------------ ------------------------------ -------------------
PUBLIC                         V$SESSION                      SYNONYM
SQL> select OWNER,SYNONYM_NAME,TABLE_OWNER,TABLE_NAME from dba_synonyms where synonym_name = 'V$SESSION';
OWNER                          SYNONYM_NAME                   TABLE_OWNER           &n


Ïà¹ØÎĵµ£º

ORACLE 9i ͳ¼Æ±í

 Õ⼸Ìì×öÏîÄ¿Óöµ½ÁËǧÍò¼¶±íµÄ´¦Àí£¬Ïà¹ØÓÅ»¯µÄÐĵÃÌØ¼Ç¼ÏÂÀ´£¬ÒÔǰÈÕºó²é¿´¡£
ÊÕ¼¯Í³¼Æ±íÐÅÏ¢ÓÐ2ÖÖ·½·¨£º
1: ANALYZE TABLE employees COMPUTE STATISTICS;
 
2: exec dbms_stats.gather_table_stats(ownname => 'owner_name',tabname => 'table_name' ,estimate_percent => null ,method_o ......

ORACLE OMF½éÉÜ

ÏÈ¿´Oracle ¹Ù·½½âÊÍ
Oracle managed file (OMF)
A file that is created automatically by the Oracle database server when it is needed and automatically deleted when it is no longer needed.
 
ÈçºÎÅжÏÄãµÄÊý¾Ý¿âÊÇ·ñΪ֧³ÖOMF
SQL> show parameter db_create_file_dest;
 
NAME  & ......

OracleÊý¾Ý¿âÖеÄ''ÓëNULLµÄ¹ØÏµ

ÔÚOracleÊý¾Ý¿âÖÐ''ÓëNULLÊǵȼ۵ġ£¾ù±íʾ¿ÕÖµ£¬¶ø²»ÊÇÀàËÆÆäËûÊý¾Ý¿âÉÏ''±íʾ¿Õ´®£¬NULL±íʾ¿ÕÖµ¡£
 
ORACLEÔÊÐíÈκÎÒ»ÖÖÊý¾ÝÀàÐ͵Ä×Ö¶ÎΪ¿Õ£¬³ýÁËÒÔÏÂÁ½ÖÖÇé¿ö£º
1¡¢Ö÷¼ü×ֶΣ¨primary key£©£¬
2¡¢¶¨ÒåʱÒѾ­¼ÓÁËNOT NULLÏÞÖÆÌõ¼þµÄ×Ö¶Î
 
˵Ã÷£º
1¡¢NULLµÈ¼ÛÓÚûÓÐÈκÎÖµ¡¢ÊÇδ֪Êý¡£
2¡¢NULLÓë ......

oracleÖÐin£¬not inºÍexists£¬not existsÖ®¼äµÄÇø±ð

 
 
         Ò»Ö±Ìýµ½µÄ¶¼ÊÇ˵¾¡Á¿ÓÃexists²»ÒªÓÃin£¬ÒòΪexistsÖ»ÅжϴæÔÚ¶øinÐèÒª¶Ô±ÈÖµ£¬ËùÒÔexists±È½Ï¿ì£¬µ«¿´ÁË¿´ÍøÉϵÄһЩ¶«Î÷²Å·¢ÏÖ¸ù±¾²»ÊÇÕâô»ØÊ¡£
ÏÂÃæÕâ¶ÎÊdz­µÄ
Select * from T1 where x in ( select y from T2 )
Ö´ÐеĹý³ÌÏ൱ÓÚ:
select * ......

ѧϰoracle sql loader µÄʹÓÃ

Ò»£ºsql loader µÄÌØµã
oracle×Ô¼º´øÁ˺ܶàµÄ¹¤¾ß¿ÉÒÔÓÃÀ´½øÐÐÊý¾ÝµÄÇ¨ÒÆ¡¢±¸·ÝºÍ»Ö¸´µÈ¹¤×÷¡£µ«ÊÇÿ¸ö¹¤¾ß¶¼ÓÐ×Ô¼ºµÄÌØµã¡£
 ±ÈÈç˵expºÍimp¿ÉÒÔ¶ÔÊý¾Ý¿âÖеÄÊý¾Ý½øÐе¼³öºÍµ¼³öµÄ¹¤×÷£¬ÊÇÒ»ÖֺܺõÄÊý¾Ý¿â±¸·ÝºÍ»Ö¸´µÄ¹¤¾ß£¬Òò´ËÖ÷ÒªÓÃÔÚÊý¾Ý¿âµÄÈȱ¸·ÝºÍ»Ö¸´·½Ãæ¡£ÓÐ×ÅËٶȿ죬ʹÓüòµ¥£¬¿ì½ÝµÄÓŵ㣻ͬʱҲÓÐһР......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ