oracleʱ¼ä´ÁÈçºÎʹÓà - Oracle / ¸ß¼¶¼¼Êõ
ÎÒÏëÔÚÒ»¸ö±íÀïÔö¼ÓÒ»¸öʱ¼ä´Á£¬È»ºóÊý¾ÝÓб仯µÄʱºòÏàÓ¦µÄʱ¼ä´ÁÒ²¸Ä±ä¡£ 1 ²»ÖªµÀÈçºÎ»ñµÃÄÇô¸ß¾«¶ÈµÄʱ¼ä 2 ʱ¼ä´ÁÊÇ·ñ»áÖظ´ 3 ʱ¼ä´Á»¹ÓÐʲô±ðµÄÓ÷¨Â𣿠ÓеãÃÔ㣬Çë´ó¼ÒÏê½â£¡
SYSDATE ?? select systimestamp from dual; ʱ¼ä´Á²»»áÖظ´ÒýÓà select systimestamp from dual; ʱ¼ä´Á²»»áÖظ´ Èç¹û²¢·¢·ÃÎÊÁ¿´óµÄ»°£¬»á´æÔÚÖظ´µÄ¿ÉÄÜÂð£¿ÒýÓà ÒýÓà 2 Â¥ ngx20080110 µÄ»Ø¸´: select systimestamp from dual; ʱ¼ä´Á²»»áÖظ´ Èç¹û²¢·¢·ÃÎÊÁ¿´óµÄ»°£¬»á´æÔÚÖظ´µÄ¿ÉÄÜÂ𣿠²»»áÓÐÎÊÌâ¡£ËüµÄ¾«¶ÈºÜ´ó¡£ systimestamp ¾«È·µ½ºÁÃë ²»»áÓÐÖظ´µÄ SQL> select systimestamp from dual; SYSTIMESTAMP --------------------------------------- 27-5Ô -10 01.25.01.359000 ÏÂÎç +08:00 ÎÒÊÔ¹ýÁË systimestamp ÏÔʾµÄ¾«¶ÈΪÃëºó6λ¡£ ´óÊý¾ÝÁ¿²åÈë ÔÚÎÒµÄpcÉÏ Ã¿100-200ÌõÊý¾Ý¶¼»áÖظ´
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£ ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£ ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£ ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
¸÷λ´ó¸ç£¬°ï¸öæ¡£ ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ 10GºÍ11GµÄ http://www.oracle.com/technology/software/products/database/index.html ------------------------------------------- ......
ÎÒÔÚ¿ª·¢µÄÕâ¸öÓ¦Óò¢·¢ÐԱȽϸߣ¬oracle¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡ oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾºÜ³ÉÊìÁË ÒýÓà oracle ......
ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó #topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬ Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7 Êý¾ÝÎļþ¹ÒÔصĽڵ㣺/oradata/pcs/ Âß¼¾íºÅlv04 #lslv -l lv04
......
OracleÖÐÓû§ÃûÊÇʲô£¿ ÃèÊöÇå³þÒ»µã£¡ ORACLEÊý¾Ý¿âÖÐÓкܶàÄÚÖõÄÓû§Ãû£¬sys¾Í²»ËµÁË£¬»¹ÓÐscottÃÜÂëÊÇtiger.³ýÁËsys,ÆäËûÓû§¶¼ÊÇËù¶¨µÄ£¬½â³ýËø¶¨ºó²ÅÄÜʹÓá£ÔÚ±¾»úµÇ½Êý¾Ý¿âʱ£¬sysµÄÃÜÂë¿ÉÒÔËæÒâÊäÈë¡£
......