Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 ......

110¸öOracle º¯Êý

 1. ASCII
·µ»ØÓëÖ¸¶¨µÄ×Ö·û¶ÔÓ¦µÄÊ®½øÖÆÊý;
SQL> select ascii(A) A,ascii(a) a,ascii(0) zero,ascii( ) space from dual;
A A ZERO SPACE
--------- --------- --------- ---------
65 97 48 32
2. CHR
¸ø³öÕûÊý,·µ»Ø¶ÔÓ¦µÄ×Ö·û;
SQL> select chr(54740) zhao,chr(65) chr65 from dual;
ZH ......

oracleÊ÷½á¹¹²éѯ

 
connect by Êǽṹ»¯²éѯÖÐÓõ½µÄ£¬Æä»ù±¾Óï·¨ÊÇ£º
select ... from tablename start with Ìõ¼þ1
connect by Ìõ¼þ2
where Ìõ¼þ3;
Àý£º
select * from table
start with org_id = 'HBHqfWGWPy'
connect by prior org_id = parent_id;
 
¼òµ¥ËµÀ´Êǽ«Ò»¸öÊ÷×´½á¹¹´æ´¢ÔÚÒ»ÕűíÀ±ÈÈçÒ»¸ö±í ......

ѧϰoracle sql loader µÄʹÓÃ

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