ITPUB¸öÈË¿Õ¼ä »
chenjun_18µÄ¸öÈ˿ռä
»¶Ó·ÃÎÊ chenjun_18 µÄ¸öÈ˿ռä
ÊÕ²ØÌû
-
2002-10-16 09:09:35 / Linux¼°ÆäÓ¦Óà ¡¾ÒÑÇ¨ÒÆµ½IXPUB¡¿
¸÷λ´óÏÀ£ºÇëÎÊÔÚSUNµÄ¹¤×÷Õ¾ÉÏ£¬ÈçºÎ½øÐÐÈçϲÙ×÷£¬1£º²é¿´²Ù×÷ϵͳ°æ±¾2£ºÐÞ¸ÄROOTÓû§µÄÃÜÂ룬3£º²é¿´CPUµÄÐͺš¢Ö÷Ƶ£¬ÄÚ´æµÄ´óСºÍÓ²Å̵ĴóСÎÒÊÇÒ»¸ö³õÊÖ£¬Ò»Ê±Ò²Ã»ÕÒµ½ Ïà¹ØµÄÊ飬Äܲ»ÄܽéÉÜsolaris ϵͳÖÐÎıȽϻù´¡µÄÊ飬Çë´óÏÀ°ïÊÖ£¬¶àл£¡£¡£¡£¡
²é¿´(360)
ÆÀÂÛ(1)
-
2002-10-11 13:56:02 / OracleÊý¾Ý¿â¹ÜÀí
ÇëÎʸ÷λ´óϺ£¬SELECT COUNT(*) FROM TABLEAÕâ¸öSQL×ö³ÉCURSOR ºóÔõôÓÃÒþʽÒýÓüÆËãµÄ×ֶΰ¡£¬¾ÍÊÇ˵²»ÖªµÀÕâ¸ö¼ÆËãÓòµÄÃû³Æ£¬ÔõôÓÃCURSOR.COLUMNNAMEÒýÓ𡣬лл
²é¿´(513)
ÆÀÂÛ(11)
-
2002-10-11 10:14:16 / OracleÊý¾Ý¿â¹ÜÀí
ÏÖÓеĻ·¾³ÊÇÕâÑù£ºIBM H50£¬AIX4.3£¬ORACLE8.1.7·þÎñÆ÷ÉÏÃæÔÀ´ÓиöÊý¾Ý¿âÏÖÔÚÎÒÏëÔÚ²»É¾³ýÔÓеÄÊý¾Ý¿âµÄÇé¿öÏÂн¨Ò»¸öÊý¾Ý¿â£¬²¢ÇÒÈÃÕâÁ½¸öÊý¾Ý¿âÄÜͬʱÔËÐУ¬²éÁËÂÛ̳ÀïµÄһЩÌû×Ó£¬¸Ð¾õ²»ÊǺÜÇå³þ£¬Óм¸¸öÎÊÌ⣺1£¬ÔÚwindowsÀïÃæ¿ÉÒÔÓÃdatabse configuration assistant ×Ô¶¯´´½¨Ò»¸öеÄÊý¾Ý¿â£¬²»ÖªµÀÔÚAIXÀïÃæÓÐûÓÐÕâÑùµÄ¹¤¾ß£¿Èç¹ûÓУ¬ÔõÑùÆô¶¯°¡£¿Èç¹ûûÓУ¬¾ÍÒªÊÖ¹¤´´½¨Êý¾Ý¿â£¬ÄÜ·ñ¸ø³ö¾ßÌå²½Ö裿2£¬Í¬Ê±Æô¶¯Á½¸öÊý¾Ý¿âÊÇ·ñÐèÒªÁ½¸ö²ÎÊýÎļþ£¿3£¬¿ª»úµÄʱºòÊÇ·ñÖ»ÄÜ×Ô¶¯ÆðÀ´Ò»¸öÊý¾Ý¿â£¬Æô¶¯µÚ¶þ¸öÊý¾Ý
²é¿´(486)
ÆÀÂÛ(10)
-
2002-10-10 15:58:06 / OracleÊý¾Ý¿â¹ÜÀí
¿ØÖÆÎļþ»µÁË£¬Ôõô°ì
²é¿´(507)
ÆÀÂÛ(8)
-
2002-10-09 12:45:43 / OracleÊý¾Ý¿â¹ÜÀí
ÓÐûÓа취ʹoracleµÄÓû§Ö»ÄÜÔÚij¼¸¸öIPµØÖ·µÄ¹¤×÷Õ¾Éϵǽµ½OracleÊý¾Ý¿âÖУ¿¼´¼ÙÉèÓû§system£¬³ýÁËÔÚ·þÎñÆ÷ÉÏÒÔÍ⣬ֻÓÐ192¡£168¡£1¡£28µÄIPµØÖ·µÄ¹¤×÷Õ¾Äܵǽµ½Oracle·þÎñÆ÷¡£
²é¿´(1655)
ÆÀÂÛ(29)
-
2002-10-09 09:40:19 / OracleÊý¾Ý¿â¹ÜÀí
ÏÖÔÚÒª½¨Ò»¸öÊý¾Ý¿âµÄ¸´Öƿ⡣ÔÊý¾Ý¿âÖÐijһ¸ö±íΪblobÊý¾Ý£¬¸Ã±í´æÔÚÓÚ¶ÀÁ¢µÄ±í¿Õ¼ä¡£ÔÚ¸´ÖƿⲻÐèÒª´ËÊý¾Ý£¬µ«ÆäËüÊý¾ÝÒª¶¨Ê±Í¬²½£¬ÇëÎʸÃÓÃʲô·½·¨.£¿ÉèÏë1£º ÀûÓÃÔÊý¾Ý¿âµÄÊý¾ÝÎļþ½øÐлָ´¡£µ«²»»Ö¸´blobËùÔÚµÄÊý¾ÝÎļþ¡£ÎÒÏëÖªµÀÕâÑù×öÔÚÀûÓÃÖØ×öarchive log½øÐÐͬ²½Ê±»á²»»áÓÐÎÊÌâ?ÉèÏë2£º export/import. µ«´æÔÚÊý¾ÝreferenceÎÊÌâ¡£µÚÒ»´Î×öÎïÀí»Ö¸´£¬Çë´ó¼Ò°ï³ö³öÖ÷Òâ¡£
²é¿´(1024)
ÆÀÂÛ(25)
-
2002-10-03 10:02:37 / OracleÊý¾Ý¿â¹ÜÀí
С½á£ºOracle Internals: DUALÉÏÖÜÌù³öÀ´µÄÿÖÜÒ»¶Á£¬Ïë°ÝÍÐÂÛ̳ÉϵÄÅóÓÑÓÃÖÐÎÄÕûÀíһϣ¬Ò»Ö±¶¼Ã»ÓÐÈ˳öÀ´×ö£¬°×ѩֻÄÜ×Ô¼ºÕûÀíÁË¡£Ï£ÍûÂÛ̳ÉϵÄÅóÓÑÄÜ»ý¼«²ÎÓ룬лл¡£1. dual ÊÇÓÉ sql.bsq ½¨Á¢µÄ¡£Ã¿¸ödatabase ÔÚ½¨Á¢µÄʱºò£¬ sql.bsq ¶¼ÐèÒªrun Ò»´ÎµÄ¡£ËùÒÔÿ¸ödatabase ¶¼»áÓÐdual table µÄ¡£2. DUAL µÄowner ÊÇË£¿-- SYS(select owner, table_name from dba_tables where table_name='DUAL';)3.ʲôʱºò¾³£Óõ½dual table?ÎÒ×Ô¼º×î³£ÓõÄÊÇ£¬ÔÚbatch script ×ö time stamps.connect intern
²é¿´(1115)
ÆÀÂÛ(7)
-
2002-09-29 14:04:49 / OracleÊý¾Ý¿â¹ÜÀí
ÒÔÏÂÊÇÎÒÔÚÒ»Ð©ÍøÕ¾ÉÏÒ»µãµã½ÚÑ¡³öÀ´µÄ£¡ÎÒ»¹»á¼ÌÐøÕûÀí£¡ÏÈÀ´Ò»²¿·Ö£¡´ó¼Ò¾õµÃºÃ£¬ÎÒ»áÔÚÌù£¡ÍøÕ¾Ì«¶àÁËÇëµ½www.orakle.com¸÷ÍøÕ¾µÄË÷Òý¶¼ÓУ¡Oracle DBA ³£Óà Script1.Description: This script will display the active userand the rollback segment being used in the database.Code:column rr heading 'RB Segment' format a18column us heading 'Username' format a15column os heading 'OS User' format a10column te heading 'Terminal' format a10SELECT r.name rr,nvl(s.username,'no transac
²é¿´(11448)
ÆÀÂÛ(67)
-
2002-09-21 05:19:20 / OracleÊý¾Ý¿â¹ÜÀí
ÎÒÖªµÀÐí¶àÈ˲»Ï²»¶¶ÁÓ¢ÎĵÄÎÄÕ£¬²»¹ýºÜ¶àºÃµÄ¼¼ÊõÎÄÕ£¬¶¼ÊÇÓ¢Îĵġ£Çë´ó¼ÒÃâΪÆäÄÑ¡£ÕâÆªÎÄÕ²»Ë㳤µÄ¡£:)All code examples are using Oracle9i.The credit for the solution belongs to Anjo Kolk, Gaja Krishna Vaidyanatha (via Rachel Carmichael) and Tim GormanX$ structures are table-ized references to memory structures and are not officially, nor well, documented. This solution must be tested and validated against each release of Oracle.What is DUAL?DUAL is a table that is cre
²é¿´(2263)
ÆÀÂÛ(22)
-
2002-09-19 10:25:42 / OracleÊý¾Ý¿â¹ÜÀí
¿ÉÒÔ¸ü¸ÄпâµÄ×Ö·û¼¯Âð£¿ÎÒ²»ÖªµÀ£¿Çë´ó¼Ò°ï棡
²é¿´(1042)
ÆÀÂÛ(12)