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

Oracle ʵÏÖÐÐÁÐת»»

SQL> DESC TEST  ²âÊÔ±í:        Name    Type            Nullable    Default Comments
       ----     ------------         --------      -------     --------
       A        NUMBER           Y                        
       B        VARCHAR2(20) Y          SQL> select * from test;                  A B
       ---------- --------------------
                 1 a
                 1 b
                 1 c
                 1 d
                 1 e
                 2 a
                 2 b
                 3 a
         


Ïà¹ØÎĵµ£º

ORACLE Êý¾Ý¿âÃû¡¢ÊµÀýÃû¡¢ORACLE_SIDµÄÇø±ð

Êý¾Ý¿âÃû(DB_NAME)¡¢ÊµÀýÃû(Instance_name)¡¢ÒÔ¼°²Ù×÷ϵͳ»·¾³±äÁ¿(ORACLE_SID)
ÔÚORACLE7¡¢8Êý¾Ý¿âÖÐÖ»ÓÐÊý¾Ý¿âÃû(db_name)ºÍÊý¾Ý¿âʵÀýÃû(instance_name)¡£ÔÚORACLE8i¡¢9iÖгöÏÖÁËеIJÎÊý£¬¼´Êý¾Ý¿âÓòÃû(db_domain)¡¢·þÎñÃû(service_name)¡¢ÒÔ¼°²Ù×÷ϵͳ»·¾³±äÁ¿(ORACLE_SID)¡£ÕâЩ¶¼´æÔÚÓÚͬһ¸öÊý¾Ý¿âÖеıêʶ£¬ÓÃÓÚÇ ......

Oracle¶¯Ì¬ÐÔÄÜÊÓͼѧϰ֮ V$ROLLSTAT

À´Ô´ÓÚhttp://hi.baidu.com/edeed/blog/item/33576327d1b73d00918f9dd4.html
±¾ÊÓͼ×ÔÆô¶¯¼´±£³Ö²¢¼Ç¼¸÷»Ø¹ö¶Îͳ¼ÆÏî¡£ÔÚѧϰ±¾ÊÓͼ֮ǰ£¬ÎÒÃÇÏÈÀ´Á˽âһϻعö¶Î(rollback segment)µÄÏà¹Ø¸ÅÄ
»Ø¹ö¶Î¸ÅÊö
»Ø¹ö¶ÎÓÃÓÚ´æ·ÅÊý¾ÝÐÞ¸Ä֮ǰµÄÖµ£¨°üÀ¨Êý¾ÝÐÞ¸Ä֮ǰµÄλÖúÍÖµ£©¡£»Ø¹ö¶ÎµÄÍ·²¿°üº¬ÕýÔÚʹÓõĸûعö¶ÎÊÂÎñµÄÐ ......

OracleÊý¾Ý¿âÖ÷»úÃûÖØ¹¹£¨For Windows£©

ÔÚNet Manager¹¤¾ßÖУ¬  
  ½«¼àÌý³ÌÐòµÄ¼àÌýλÖõÄÖ÷»úÃû¸ÄΪ  лúÃû  
  ½«·þÎñÃûÖжÔÓ¦Êý¾Ý¿âµÄÖ÷»úÃû¸ÄΪ  лúÃû  
   
  ¸ÄÁ˼àÌý³ÌÐòºó£¬ÔÚMS-DOSÖÐÔËÐР 
  lsnrctl   stop  
  lsnr ......

ÔÚ Linux x86 Éϰ²×° Oracle RAC 10g

DBA£ºLinux
ÔÚ Linux x86 Éϰ²×° Oracle RAC 10g
×÷ÕߣºJohn Smiley
Á˽âÔÚ Red Hat Enterprise Linux »ò Novell SUSE Enterprise Linux ÉÏ´ÓÍ·°²×° Oracle RAC 10g µÄ»ù´¡ÖªÊ¶£¨½öÓÃÓÚÆÀ¹À£©
Ŀ¼
¸ÅÊö
±³¾°
µÚ 1 ²¿·Ö£º °²×° Linux
µÚ 2 ²¿·Ö£º Ϊ Oracle ÅäÖà Linux
µÚ 3 ²¿·Ö£º ×¼±¸¹²Ïí´ÅÅÌ
µÚ 4 ²¿·Ö£º ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ