OracleÆô¶¯¹ý³ÌÏê½â ½éÉܼ°ÃüÁ»¹ÓйرÕ
OracleÆô¶¯¹ý³Ì½éÉܼ°ÃüÁ»¹Óйرա£
дÔÚÇ°Ãæ£ºÆô¶¯Êý¾Ý¿âǰ£¬ÇëÏÈÆô¶¯¼à³ÌÐò¡£
lsnrctl start
Æô¶¯µÄÈý¸ö²½Ö裬ÒÀ´ÎΪ1.´´½¨²¢Æô¶¯ÊµÀý¡¢2.×°ÔØÊý¾Ý¿â¡¢3.´ò¿ªÊý¾Ý¿â¡£
¿ÉÒÔͨ¹ýÃüÁîstartupÀ´ÊµÏÖ¡£
startup ÃüÁî¸ñʽ
startup [ nomount | mount | open | force ] [ restrict ] [ pfile=filename ];
·½·¨1 -- startup nomount ; alter database mount ;alter database open
·½·¨2 -- startup mount ; alter database open
·½·¨3 -- startup »ò startup open
ÔÚ½øÈëijÖÖģʽºó£¬¿ÉÒÔͨ¹ýalter databaseÀ´ÌáÉýµ½¸ü¸ßµÄģʽ¡£µ«ÊÇÎÞ·¨½µµÍÖÁÇ°ÃæµÄģʽ¡£
ÊéÉÏдµÄտĥߴ£¬¾ÍÊÇ˵ÄãÔÚstep2ÕâÀÄã¿ÉÒÔͨ¹ýalter databaseµ½step3,µ«ÊÇÄã²»Äܵ½step 1.
startup force
Ç¿ÖÆÆô¶¯£¬¿ÉÓÃÓÚ¸÷ÖÖģʽ¡£Õý³£µÄÆð²»À´£¬¾ÍÊÔÊÔÕâ¸ö¡£
startup restrict
restrictģʽ»á½«Êý¾Ý¿âÖÃÓÚopenģʽ£¬´ËʱֻÓÐrestricted sessionȨÏÞµÄÓû§²ÅÄÜ·ÃÎÊÊý¾Ý¿â¡£
ÓÃÓÚά»¤¶¯×÷¡£Î¬»¤Íê³Éºó£¬Çë½ûÓÃrestricted sessionȨÏÞ£¬ÒÔ±ãÆÕͨÓû§µÄÁ¬½Ó¡£ÈçÏ£º
alter system disable restricted session
1:´´½¨²¢Æô¶¯ÊµÀý stratup nomount
´ËģʽÏÂÖ´ÐÐά»¤¶¯×÷£º
a:ÔËÐÐÒ»¸ö´´½¨ÐÂÊý¾Ý¿âµÄ½Å±¾
b:ÖØ½¨¿ØÖÆÎļþ
2:×°ÔØÊý¾Ý¿â startup mount
´ËģʽÏÂÖ´ÐÐά»¤¶¯×÷£º
a:ÖØÃüÃûÊý¾ÝÎļþ
b:Ìí¼Ó¡¢É¾³ý¡¢ÖØÃüÃûÖØ×öÈÕÖ¾Îļþ
c:Ö´ÐÐÊý¾Ý¿âÍêÈ«»Ö¸´²Ù×÷
d:¸Ä±äÊý¾Ý¿âµÄ¹éµµÄ£Ê½¡£
3:´ò¿ªÊý¾Ý¿â stratup µÈͬÓÚ startup open
´Ëģʽ״̬Ï¡£ÈκξßÓÐcreate sessionȨÏÞµÄÓû§¶¼¿ÉÒÔÁ¬½Óµ½Êý¾Ý¿â¡£½øÐг£¹æÊý¾Ý¿â²Ù×÷¡£
¹Ø±ÕÊý¾Ý¿â,ͨ¹ýshutdownÃüÁî
shutdown ÃüÁî¸ñʽ
shutdown [ normal | transactional | immediate | abort ];
normal:
a:×èÖ¹ÈκÎÓû§½¨Á¢ÐµÄÁ¬½Ó
b:µÈ´ýÁ¬½ÓµÄÓû§Ö÷¶¯¶Ï¿ª£¬ÕýÔÚÁ¬½ÓµÄÓû§¿ÉÒÔ¼ÌÐø¹¤×÷£¬ÉõÖÁÌύеÄʵÎñ¡£
c:Ò»µ©ËùÓеÄÓû§¶Ï¿ªÁ¬½Ó£¬²Å½øÐйرգ¬Ð¶ÔØÊý¾Ý¿â£¬²¢ÖÕֹʵÀý¡£
Ó°Ï죺µÈºÜ¾Ã¡£
transactional:
a:×èÖ¹ÈκÎÓû§½¨Á¢ÐµÄÁ¬½Ó,ͬʱ×èÖ¹²úÉúеÄÊÂÎñ¡£
b:µÈ´ýδÌá½»µÄʵÎñ£¬Ìá½»Íê±Ïºó£¬ÇжÏÓû§µÄÁ¬½Ó¡£
c:Ò»µ©ËùÓеÄÓû§¶Ï¿ªÁ¬½Ó£¬²Å½øÐйرգ¬Ð¶ÔØÊý¾Ý¿â£¬²¢ÖÕֹʵÀý¡£
Ó°Ï죺×îºÃµÄ¹Ø±ÕÊý¾Ý¿âµÄ·½Ê½¡£
immediate:
a:×èÖ¹ÈκÎÓû§½¨Á¢ÐµÄÁ¬½Ó,ͬʱ×èÖ¹²úÉúеÄÊÂÎñ¡£
b:ÈκÎδÌá½»µÄʵÎñ¶¼»á±»»Ø¹ö¡£
c:Oracle²»ÔٵȴýÓû§Ö÷¶¯¶Ï¿ªÁ¬½Ó£¬¶øÊÇÖ±½Ó¹Ø±Õ¡¢Ð¶ÔØÊý¾Ý¿â£¬²¢ÖÕֹʵÀý¡£
Ó°Ï죺ÓÐЩ
Ïà¹ØÎĵµ£º
ÐèÒª´óÁ¿oracle²âÊÔÊý¾Ýʱ£¬¿ÉÒÔʹÓÃÒÔÏ·½·¨¡£
DECLARE
i INT;
BEGIN
i := 0;
WHILE(i < 100000)
LOOP
i := i + 1;
INSERT INTO TEST_TABLE(ID, XM) VALUES(i, 'ÐÕÃû' || i);
END LOOP;
COMMIT;
END; ......
ÏÖÔÚÔÚWEB Ó¦ÓÃÖÐʹÓ÷ÖÒ³¼¼ÊõÔ½À´Ô½ÆÕ±éÁË£¬ÆäÖÐÀûÓÃÊý¾Ý¿â²éѯ·ÖÒ³ÊÇÒ»ÖÖЧÂʱȽϸߵķ½·¨£¬
ÏÂÃæÁгöÁËOracle, DB2 ¼° MySQL ·ÖÒ³²éѯд·¨¡£
Ò»£ºOracle
select * from (select rownum,name from table where rownum <=endIndex )
where rownum > startIndex
¶þ£ºDB2
DB2·ÖÒ³²éѯ
SELECT * ......
DECODEº¯ÊýÊÇORACLE PL/SQLÊǹ¦ÄÜÇ¿´óµÄº¯ÊýÖ®Ò»£¬Ä¿Ç°»¹Ö»ÓÐORACLE¹«Ë¾µÄSQLÌṩÁ˴˺¯Êý£¬ÆäËûÊý¾Ý¿â³§É̵ÄSQLʵÏÖ»¹Ã»Óд˹¦ÄÜ¡£DECODEÓÐʲôÓÃ; ÄØ£¿ Ïȹ¹ÔìÒ»¸öÀý×Ó£¬¼ÙÉèÎÒÃÇÏë¸øÖÇÐÇÖ°Ô±¼Ó¹¤×Ê£¬Æä±ê×¼ÊÇ£º¹¤×ÊÔÚ8000ÔªÒÔϵĽ«¼Ó20£¥£»¹¤×ÊÔÚ8000ÔªÒÔÉϵļÓ15£¥£¬Í¨³£µÄ×ö·¨ÊÇ£¬ÏÈÑ¡³ö¼Ç¼ ÖеŤ×Ê×Ö¶ÎÖµ? select ......
=================================================================================
Oracle RAC ²úÆ·¸ÅÊö
Oracle Real Application Server£¬ÕæÕýÓ¦Óü¯Èº£¬¼ò³ÆOracle RAC £¬ÊÇOracleµÄ²¢Ðм¯Èº£¬Î»ÓÚ²»Í¬·þÎñÆ÷ϵͳµÄOracleʵÀýͬʱ·ÃÎÊͬһ¸öOracleÊý¾Ý¿â£¬½ÚµãÖ®¼äͨ¹ý˽ÓÐÍøÂç½øÐÐͨÐÅ£¬ËùÓеĿØÖÆÎļþ¡¢Áª»úÈÕÖ ......
pl/sql ±í
ÔÚpl/sql¿éÖÐÁÙʱʹÓá¢ÏñÊý×éÒ»ÑùµÄ¶ÔÏó
°üº¬Ò»ÁкÍÒ»¸öÖ÷¼ü
²»ÄܶÔÁкÍÖ÷¼ü½øÐÐÃüÃû
ÁпÉÒÔÊÇÈκαêÁ¿Êý¾ÝÀàÐÍ
Ö÷¼ü±ØÐëÊÇbinary_integerÀàÐÍ
´óСûÓÐÏÞÖÆ
ÉùÃ÷pl/sql±í
¶¨Òå±íµÄÀàÐÍ
type ÀàÐÍÃû is table of ÁÐÀàÐÍ|±äÁ¿Êý¾ÝÀàÐÍ ......