oracleµÄ¶Áд±í²¢·¢²Ù×÷
k ˵(14:52):
ÎʸöÎÊÌâ ²éѯÊý¾Ý¿â±íµÄʱºò ¸Ã±í»¹ÄÜдÊý¾ÝÂð ÊÇ°´ÕÕÅŶӵÄ˳Ðò »¹ÊÇ°´ÕÕ²Ù×÷µÄʱ¼ä˳Ðò(²»ÖªµÀoracleÈçºÎ´¦ÀíÕâ¸öÎÊÌ⣩ ¼ÙÉèÒ»¸öÇé¿ö£ºÎÒÏÖÔÚÔÚ²éѯ¼Æ·Ñ±í£¨Õâ¸öʱ¼ä¿ÉÄÜÒª»¨10·ÖÖÓ£© 10·ÖÖÓÓкܶà¼Æ·ÑÊý¾ÝÒªÈë¼Æ·Ñ±í£¨ÄÇÕâ¸öдÊý¾ÝÊÇÒªµÈÎÒ²éѯÍêÁËÖ®ºó²ÅÄÜдÂ𣩠дÊý¾Ý¿â¿Ï¶¨ºÜ¿ì£¨0.1Ã루»¹ÊÇÀ´ÁËÊý¾Ý¾Íд£© ²éѯÒÀÈ»²éѯд֮ǰµÄÊý¾Ý
m˵(14:54):
ÄÜд
m1˵(14:54):
ÄãÓÃselect .... for update nowait ºÃÏñÊÇ ÎÒÍüÁ˾ßÌåÔõôдÁË£¬ÕâÑù¾Í¿ÉÒÔËø±íÁË£¬µÈÄã²éÍêÁËÌá½»ºó±ðÈ˲ÅÄܸüÐÂ
m˵(14:55):
¸úÊÂÎV±ðÓйØϵ
m˵(14:55):
²¢·¢¼¶±ðÉèÖÃ
m3 ˵(14:56):
²éѯʱºòǧÍò±ðËø±í
k ˵(14:59):
ÎÒÏÖÔÚÒ²¾õµÃÄÜд ÒòΪÎÒ²éѯ±¨±í¿â ¶©¹º±í Êý¾Ý³öÀ´µÄºÜ¿ì£¨597.797Ãë) ÏÖÔÚÎÒ²éÏÖÍø¿â »¨ÁË 1184.062Ãë ÕâÖÐ;¿Ï¶¨Ð´Êý¾ÝÈ¥ÁË
m ˵(14:59):
ÄÜд
m˵(14:59):
²éѯ£¬Ð´È붼ÊDz¢·¢µÄ
ÏÖÔÚÓÐеÄÎÊÌ⣬¼ÈÈ»²éѯÊý¾ÝµÄʱºòÒ²ÔÚдÊý¾Ý£¬ÄÇôÎҵIJéѯ³¡¾°Ó¦¸ÃÊÇд֮ǰµÄ³¡¾°£¬ÒòΪÈç¹ûдһ´ÎÊý¾Ý£¬ÎÒÓÖ´ÓÍ·¿ªÊ¼²éѯ£¬ÄÇÎҵIJéѯ¾ÍÍê³É²»ÁËÁË¡£ËùÒÔoracleÓ¦¸ÃÊÇÓÃÁË»º³åÊý¾ÝµÄ¹¦ÄÜ£¬²éѯµÄ¹ý³ÌÖУ¬ÏÈ°ÑдÈëµÄÊý¾Ý·Åµ½»º³åÇøÀµÈ²éѯÍê±ÏÁË£¬ÔÚдÈë±í¿Õ¼äÀï¡££¨²»ÖªµÀÊDz»ÊÇÕâÑù£¬¶ÔÊý¾Ý¿â²»ÊǺÜÁ˽⣬ÕâÊÇÎÒµÄÒ»¸öÏë·¨¶øÒÑ£¬×Ô¼º¾õµÃ»¹Óеã¶ùµÀÀí£©
Ïà¹ØÎĵµ£º
Ò»°ãÊý¾Ý¿âÖÐʱ¼äµÄ¸ñʽΪDATEÀàÐÍ£¬¶øÎÒÃÇ´ÓÒ³ÃæÖлñÈ¡µÄʱ¼äÍùÍùΪStringÀàÐÍ£¬Õâ¸ö¾ÍÐèÒªÀàÐ͵Äת»»¡£Ò»°ãÎÒÃÇ»áͨ¹ýµ÷Óà Java.text.SimpleDateFormat JAVAÀàÀ´¶ÔÆä½øÐÐת»»¡£Õâ¸öJAVAÀàÖÐÎÒÃǾ³£Óõ½µÄ·½·¨ÓÐÁ½¸ö£¬Ò»¸öÊÇformat(½«Ê±¼ä¸ñʽµÄÊý¾Ýת»»³ÉStringÀàÐÍ)£¬ÁíÒ»¸ö¾ÍÊÇ parse(½«StringÀàÐÍת»»³ÉDATEÀàÐÍ)¡£ÎÒ ......
OracleÉó¼Æ¹¦ÄÜ
Éó¼ÆÊǶÔÑ¡¶¨µÄÓû§¶¯×÷µÄ¼à¿ØºÍ¼Ç¼£¬Í¨³£ÓÃÓÚ£º
u Éó²é¿ÉÒɵĻ¡£ÀýÈ磺Êý¾Ý±»·ÇÊÚȨÓû§Ëùɾ³ý£¬´Ëʱ°²È«¹ÜÀíÔ±¿É¾ö¶¨¶Ô¸Ã Êý¾Ý¿âµÄËùÓÐÁ¬½Ó½øÐÐÉó¼Æ£¬ÒÔ¼°¶ÔÊý¾Ý¿âµÄËùÓбíµÄ³É¹¦µØ»ò²»³É¹¦µØɾ³ý½øÐÐÉó¼Æ¡£
u &n ......
http://inthirties.com:90/thread-1233-1-1.html
ºÃûÓÐÅöSolarisÁË£¬ÊÖÓÐЩÉúÁË£¬¿´À´ÕæҪװ¸ösolaris£¬Æ½Ê±¶àÍæÍæ¡£
ÔÚsolarisÉÏ×°Oracle 10gÏÈ¡£
1. ¼ì²é°²×°ÒÀÀµ°ü
¹Ù·½ÒªÇóµÄ°ü
SUNWarc
SUNWbtool
SUNWhea
SUNWlibm
SUNWlibms
SUNWsprot
SUNWtoo
SUNWi1of
SUNWi1cs
SUNWi15cs
SUNWxwfnt
Ö´ÐÐÃüÁî
# p ......
ÎÒÃÇÖªµÀ,ÔÚOracleÊý¾Ý¿âÖÐ,¿ÉÒÔͨ¹ýkill sessionµÄ·½Ê½À´ÖÕÖ¹Ò»¸ö½ø³Ì,Æä»ù±¾Óï·¨½á¹¹Îª:
alter system kill session 'sid,serial#' ;
±»killµôµÄsession,״̬»á±»±ê¼ÇΪkilled,Oracle»áÔÚ¸ÃÓû§ÏÂÒ»´ÎtouchʱÇå³ý¸Ã½ø³Ì.
ÎÒÃÇ·¢ÏÖµ±Ò»¸ösession±»killµôÒԺ󣬸ÃsessionµÄpaddr±»Ð޸ģ¬Èç¹ûÓжà¸ösession±»kill£¬ÄÇô¶ ......