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

ORACLEÌåϵ½á¹¹


Ò»¡¢             ÄÚ´æ½á¹¹
¹²Ïí³Ø£º·ÖΪ¿â¸ßËÙ»º´æºÍ×Öµä¸ßËÙ»º³åÇø
¿â¸ßËÙ»º´æ£¬ÓÃÓÚ´æ´¢¾­¹ýÓï·¨·ÖÎö²¢ÇÒÕýÈ·µÄSQLÓï¾ä£¬²¢ËæÊ±×¼±¸Ö´ÐС£
×Öµä¸ßËÙ»º³åÇø£¬´æ´¢µÇ½µ½ORACLEµÄÓû§Ãû£¬¼°ÕâЩÓû§ÓÐÄÄЩÊý¾Ý¿â¶ÔÏóÒÔ¼°ÕâЩÊý¾Ý¿â¶ÔÏóµÄλÖá£
Êý¾Ý»º³åÇø£ºÊý¾Ý¸ßËÙ»º³åÇø°üº¬Èý¸öÀàÐ͵ÄÇøÓò
keep»º³å³Ø¡¢recycle»º³å³Ø¡¢ default»º³å³Ø
                     ´æ·ÅORACLEϵͳ×î½üʹÓùýµÄÊý¾Ý¿é
       ÈÕÖ¾»º³åÇø£º
ÈκÎÊÂÎñÔڼǼµ½ÖØ×öÈÕ־֮ǰ¶¼±ØÐëÊ×Ïȷŵ½ÖØ×öÈÕÖ¾»º³åÇøÖУ¬È»ºóÓÉÈÕ־дÈë½ø³Ì¶¨ÆÚ½«´Ë»º³åÇøµÄÄÚÈÝдÈëÖØ×öÈÕÖ¾ÖÐ
¶þ¡¢             ºǫ́½ø³Ì
PMON£º
              ¼à¿ØÓû§½ø³Ì£¬ÓÃÓÚÖÕÖ¹ÄÇЩʧ°ÜµÄÓû§ÒÔ¼°ÊÍ·ÅÓû§ËùÕ¼ÓõÄ×ÊÔ´µÈ
SMON£º
              ¼à¿ØORACLE ϵͳ±¾Éí£¬ÔÚÊý¾Ý¿âÆô¶¯Ê±Ö´Ðлָ´¹¤×÷µÄÇ¿ÖÆÐÔ½ø³Ì£¨Ç°¹ö£©
DBWR£º
              ¶ÁдÊý¾Ý½ø³Ì£¬½«Ð޸ĺóµÄÊý¾Ý¿éд»ØÊý¾Ý¿âÎļþÖÐ
LGWR£º
              ¶ÁдÈÕÖ¾½ø³Ì£¬ÓÃÓÚ½«SGAÇøÖеÄÈÕÖ¾ÐÅϢдÈëÈÕÖ¾ÎļþµÄ½ø³Ì
CKPT£º
¿ÉÑ¡½ø³Ì£¬ÔÚϵͳÔËÐÐÖгöÏÖ²éÕÒÊý¾ÝÇëÇóʱ£¬ÏµÍ³ÕÒ³öÊý¾Ý´æÈëÄÚ´æÇø£¬Óû§¿ÉÒÔ¶ÔÄÚ´æÖеÄÊý¾Ý½øÐÐÐ޸쬵±ÐèÒª¶ÔÐ޸ĺóµÄÊý¾Ýд»ØÊý¾ÝÎļþʱ¾Í²úÉúÖØ×öÈÕÖ¾ÎļþµÄ½»ÌæÐ´£¬ÕâÊǾͳöÏÖ¼ìÑéµã
 
 
Èý¡¢             Êý¾Ý¿âÎļþ
²ÎÊýÎļþ£º
¼´initsid.ora ÊÇÅäÖòÎÊýºÍÊýÖµµÄ¼¯ºÏ£¬Ã¿¸ö²ÎÊýÖµ¶¼¿ØÖÆ»òÐÞ¸ÄÊý¾Ý¿âºÍʵÀýµÄij¸ö·½Ãæ
Êý¾ÝÎļþ£º
              ´æ·ÅËùÓÐÊý¾Ý¿âµÄÒµÎñÊý¾Ý
¿ØÖÆÎļþ£º
              ÔÚÊý¾Ý¿âʵÀýÆô¶¯Ê±ÔËÐÐ
ÈÕÖ¾Î


Ïà¹ØÎĵµ£º

OracleÌåϵ½á¹¹Ö®£­Êý¾Ý¿â¡¢±í¿Õ¼ä¡¢ÊµÀý¼ò½é

Ò»¡¢Êý¾Ý¿â
Êý¾Ý¿â¹ËÃû˼ÒåÊÇÊý¾ÝµÄ¼¯ºÏ£¬¶øOracleÔòÊǹÜÀíÕâЩÊý¾Ý¼¯ºÏµÄÈí¼þϵͳ£¬ËüÊÇÒ»¸ö¶ÔÏó¹ØÏµÐ͵ÄÊý¾Ý¿â¹ÜÀíϵͳ¡£    
¶þ¡¢±í¿Õ¼ä
±í¿Õ¼äÊÇOracle¶ÔÎïÀíÊý¾Ý¿âÉÏÏà¹ØÊý¾ÝµÄÂß¼­Ó³Éä¡£Ò»¸öÊý¾Ý¿âÔÚÂß¼­Éϱ»»®·Ö³ÉÒ»µ½Èô¸É¸ö±í¿Õ¼ä£¬Ã¿¸ö±í¿Õ¼ä°üº¬ÁËÔÚÂß¼­ÉÏÏà¹ØÁªµÄÒ»×é½á¹¹¡£Ã¿¸öÊý¾Ý¿âÖ ......

OracleȡǰNλSQL

      Ò²Ðí¶ÔSQL ServerÀ´Ëµ,ȡǰNλµÄÊý¾ÝÊǺܼòµ¥µÄÊÂÇé,Ò»ÌõTOPÓï¾ä¾Í¸ã¶¨ÁË.
      ÔÚOracleÖÐÎÒÃÇÍùÍù»á¸Ð¾õµ½Í·ÌÛ,ƽÈÕÀïÒ²³£»áÓõ½,Ö÷ÒªÊÇʹÓÃpartition by.
Óï·¨ÈçÏÂ:
select emp_card_no,work_date,read_card_date,count(rownum) as cnt
from hra_read_car ......

OracleÊý¾Ýµ¼Èëµ¼³öimp/exp

¹¦ÄÜ£ºOracleÊý¾Ýµ¼Èëµ¼³öimp/exp¾ÍÏ൱ÓëoracleÊý¾Ý»¹Ô­Ó뱸·Ý¡£´ó¶àÇé¿ö¶¼¿ÉÒÔÓÃOracleÊý¾Ýµ¼Èëµ¼³öÍê³ÉÊý¾ÝµÄ±¸·ÝºÍ»¹Ô­£¨²»»áÔì³ÉÊý¾ÝµÄ¶ªÊ§£©¡£
¡¡¡¡OracleÓиöºÃ´¦£¬ËäÈ»ÄãµÄµçÄÔ²»ÊÇ·þÎñÆ÷£¬µ«ÊÇÄã×°ÁËoracle¿Í»§¶Ë£¬²¢½¨Á¢ÁËÁ¬½Ó £¨Í¨¹ýnet8 assistantÖб¾µØ——>·þÎñÃüÃû Ìí¼ÓÕýÈ·µÄ·þÎñÃüÃû
¡¡¡¡Æ ......

Oracle JDeveloper 10g Release Download

Oracle JDeveloper 10g Release Download
Oracle JDeveloper 10g (version 9.0.5.1, build 1605) for Windows NT/2000/X, Linux, Solaris, and HP-UX.
http://download.oracle.com/otn/java/jdeveloper/905/jdev9051.zip
http://download-east.oracle.com/otn/java/jdeveloper/905/jdev9051.zip
http://download-west ......

ORACLEÖÐLikeÓëInstrÐÔÄÜ´ó±ÈÆ´

t±íÖн«½üÓÐ1100ÍòÊý¾Ý£¬ºÜ¶àʱºò£¬ÎÒÃÇÒª½øÐÐ×Ö·û´®Æ¥Å䣬ÔÚSQLÓï¾äÖУ¬ÎÒÃÇͨ³£Ê¹ÓÃlikeÀ´´ïµ½ÎÒÃÇËÑË÷µÄÄ¿±ê¡£µ«¾­¹ýʵ¼Ê²âÊÔ·¢ÏÖ£¬likeµÄЧÂÊÓëinstrº¯Êý²î±ðÏ൱´ó¡£ÏÂÃæÊÇһЩ²âÊÔ½á¹û£º
SQL> set timing on
SQL> select count(*) from t where instr(title,’ÊÖ²á’)>0;
COUNT(*)
—&md ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ