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

²éѯoracleµ±Ç°Á¬½ÓÊý

   ÎÒÃǼÙÉèÊÇÊý¾Ý¿â¹ÜÀíÔ±£¬ÎªÁËÊý¾Ý¿âµÄ°²È«£¬ÎÒÃÇÐèÒªÖªµÀµ±Ç°ÓжàÉÙÁ¬½ÓÊý£¬×î´óÖ§³Ö¶àÉÙÁ¬½ÓÊý£¬¿ÉÒÔÓÃÒÔÏÂÓï¾ä²éѯ
      select username,count(username),machine,status from v$session         
      where username is not null group by username,machine,status              -------²éѯµ±Ç°Á¬½ÓÊý
    show parameters processions          -------------×î´óÁ¬½ÓÊý


Ïà¹ØÎĵµ£º

¡¶Í¿Ä¨Oracle£­Èý˼±Ê¼ÇÖ®Ò»²½Ò»²½Ñ§Oracle¡·³ö¯ÊÖ¼Ç

¡öÀÖÖª
  “Ë­ÊÇË­µÄË­”£¬ÕâÊÇΨÃÀÖÐ͸×ÅÓÄÔ¹µÄÒ»Ê׸裬µ«È´»áĪÃûµØµçµ½ÐÄÖеÄÀÛ¡£Ñ§Ï°Ì«ÀÛ£¬¹¤×÷Ì«ÀÛ£¬Éú»îÌ«ÀÛ£¬Á¬¸èÃûÌý×Ŷ¼ÄÇôÀÛ¡£
²ß»®µÄµÚÒ»±¾Êé¡¶´óÏó——Thinking in UML¡·£¬´ÓÔË×÷£¬µ½ÉÏÊУ¬µ½³©Ïú£¬µ½¾­µä£¬µ½¹úÄÚUMLµÚÒ»Ê飬һÄêÖ®ÄÚʵÏÖÁËÒ»¸ö¸öûÓÐÃιýµÄÃÎÏë¡£ÕýÈçÕâÊ׸èÖеÄÒ ......

Oracle job ʹÓÃ

²½Ö裺
(1) ´´½¨×÷Òµ
(2) ´´½¨job
       dbms_job.submit();
       submit ( jobno¡¡OUT binary_ineger,
¡¡¡¡¡¡¡¡¡¡¡¡¡¡What¡¡¡¡¡¡IN¡¡varchar2,
¡¡¡¡¡¡¡¡¡¡¡¡¡¡next_date IN¡¡date,
¡¡¡¡¡¡¡¡¡¡¡¡¡¡interval¡¡IN¡¡varchar2,
¡¡¡¡¡¡¡¡¡¡¡¡  &nb ......

ʹÓÃCodeSmithÉú³ÉoracleÊý¾Ý¿â±íµÄʵÌå²ã(Model)

ʹÓÃCodeSmithÉú³ÉoracleÊý¾Ý¿â±íµÄʵÌå²ã(Model)
http://blog.csdn.net/dacong/archive/2009/01/27/3853663.aspx
×Ô¼ºÐ´µÄ£¬CodeSimthÖеÄÀý×Ó¶¼ÊÇmsSQL serverµÄ£¬ËùÒÔ×Ô¼ºÐ´Á˸öÖ§³ÖOracleÊý¾Ý¿â±íµÄ£¬²»Ò»¶¨ºÜÍêÉÆ£¬ÊÊÓþͺã¬Êý¾ÝÀàÐÍûÓÐÖÜÈ«¿¼ÂÇ£¬Ö»¿¼ÂÇÁ˳£ÓõÄһЩÀàÐÍ£¬Ôö¼ÓÁ˸ö±íÃû×ÖÊôÐÔ£¬²ÉÓõÄ.net2.0ÎÒ½á ......

ÔÚLinuxϰ²×°Oracle Database 9i

ÔÚLinuxϰ²×°Oracle Database 9i
2009Äê05ÔÂ11ÈÕ ÐÇÆÚÒ» 20:49
http://www0.ccidnet.com/tech/guide/2001/11/20/58_3761.html
Oracle9i 2000Äê10ÔÂÔÚOracle Open WorldÉÏ·¢²¼£¬Îª Oracle Êý¾Ý¿â¡¢Ó¦Ó÷þÎñÆ÷ºÍ¿ª·¢¹¤¾ßÒý½øÁËÐí¶àй¦ÄÜ¡£Oracle9iÊÇÒµ½çµÚÒ»¸öÍêÕû¡¢¼òµ¥µÄÓÃÓÚ»¥ÁªÍøµÄÐÂÒ»´úÖÇÄÜ»¯µÄ¡¢Ð­×÷¸÷ÖÖÓ¦ÓõÄÈí ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ