Oracle ¿Í»§¶ËÅäÖüàÌý(TNSNames.oraÉèÖÃ)
¢Ù Ö»ÐèÔÚÎļþ TNSNames.ora ÖмÓÈëÒÔϽڵ㣬¼´¿É³É¹¦ÅäÖüàÌý
ORCL190 = //ºìÉ«²¿ÃÅΪÁ¬½Ó¼àÌýÃû×Ö
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.190)(PORT = 1521)) //ºìÉ«²¿ÃÅΪ·þÎñÆ÷ËùÔÚIPµØÖ· 1521Ϊ¶Ë¿ÚºÅ
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl) //ºìÉ«²¿ÃÅΪÊý¾Ý¿âÃû
)
)
¢Ú ÓÃDOS Á¬½ÓOracleÊý¾Ý¿â,¿´¿´ÊÇ·ñÄÜÁ¬ÉÏÊý¾Ý¿â
>CMD
>sqlplus Óû§Ãû/ÃÜÂë@½Ó¼àÌýÃû×Ö
Ïà¹ØÎĵµ£º
Oracle µÄÉú²ú¿â¶¼ÊÇÆô¶¯Ôڹ鵵ģʽÏ£¬RACϹ鵵·Ç¹éµµµÄÇл»ºÍµ¥ÊµÀýÒ²ÊÇÒ»ÑùµÄ£¬¶¼ÊÇÔÚMOUNTģʽÏÂÖ´ÐÐALTER DATABASE ARCHIVELOG/NOARCHIVELOG;ÃüÁî¡£ ²»Í¬µÄÊÇ£ºRAC»·¾³ÏÂËùÓÐʵÀý¶¼±ØÐë´¦ÓÚ·ÇOPEN״̬£¬È»ºóÔÚÈÎÒâÒ»¸ö´¦ÓÚMOUNT״̬µÄʵÀýÖ´ÐÐALTER DATABASEÃüÁ²Ù×÷³É¹¦ºó£¬ÔÙÕý³£Æô¶¯ ......
½ñÌì²Î¼ÓÁËOracle & SUNºÏ²¢ºóµÚÒ»´ÎÓëºÏ×÷»ï°é¼°¿Í»§µÄͨÆø»á¡£Õû¸ö»áÒé¸øÎҵĸоõÊÇ£ºOracleÐÛÐIJª²ª£¬SUNÒâÆø·ç·¢£¬¶øÎÒ×Ô¼º£¬ÐÄ»³ã·ã·¡£ OracleÓÐÁËSUN£¬ÄÇô´ÓÓ²¼þµ½Èí¼þOracleµÄ²úÆ·Ïß¾ÍÊ®·ÖÆ뱸ÁË¡£Oracle°ëÄêÇ°ÍƳö11gR2 for linux£¬½Ó×Åfor solar ......
select count(*) from t1;
Õâ¾ä»°±È½Ï¼òµ¥£¬µ«ºÜÓÐÐþ»ú£¡¶ÔÕâ¾ä»°ÔËÐеÄÀí½â£¬·´Ó³ÁËÄã¶ÔÊý¾Ý¿âµÄÀí½âÉî¶È£¡
½¨Á¢ÊµÑéµÄ´ó±íËût1
SQL> conn scott/tiger
ÒÑÁ¬½Ó¡£
SQL> drop table t1 purge;
±íÒÑɾ³ý¡£
SQL> create table t1 as select * from emp where 0=9;
±íÒÑ´´½¨¡£
SQL> insert into t1 sele ......
¡¡Ëæ×ÅÏÖ´úÊý¾Ý¿â¿ÉÓÃÌØÕ÷¼¯µÄѸËÙÔö¼Ó£¬ºÜÄÑÇø·ÖÊëºÃÊ뻵¡£ÀýÈçOracleÀï¾ÍÓÐÐí¶àÄã¿ÉÄÜ´ÓÀ´¶¼²»ÐèÒªµÄ¸ß¼¶Êý¾Ý²Ö¿âÌØÕ÷¡£´ËÍâÒ²¿ÉÄÜÓÐһЩÆäËü²»¿É»òȱµÄÌØÕ÷±ÈÈçACIDÊÂÎñÌØÐÔ¡£ÎÒÃÇÀ´¿´Ò»¿´Ö÷ÒªµÄһЩÌØÕ÷£¬±ÈÈç´æ´¢¹ý³Ì£¬ÊÓͼ£¬¿ìÕÕ£¬±íÊý¾ÝÀàÐͺÍÊÂÎñµÈµÈ¡£Í¬Ê±ÎÒÃÇ·ÖÎöÒ»ÏÂPostgresql£¬MySQLºÍOracleÕ⼸¸öÊý¾Ý¿â£¬È»º ......
²é¿´OracleÖ´Ðмƻ®µÄ¼¸ÖÖ·½·¨
Ò»¡¢Í¨¹ýPL/SQL Dev¹¤¾ß
1¡¢Ö±½ÓFile->New->Explain Plan Window£¬ÔÚ´°¿ÚÖÐÖ´ÐÐsql¿ÉÒԲ鿴¼Æ»®½á¹û¡£ÆäÖУ¬Cost±íʾcpuµÄÏûºÄ£¬µ¥Î»Îªn%£¬Cardinality±íʾִÐеÄÐÐÊý£¬µÈ¼ÛRows¡£
2¡¢ÏÈÖ´ÐÐ EXPLAIN PLAN FOR select * from tab ......