oracleµ÷ÓÅÖ® ¹²Ïí³ØÊ¹ÓÃÎÊÌ⣨ժ×ÔÎÄÆ½Ê飩
SGA ÖеÄÁíÍâÒ»¸öÖØÒª½á¹¹Êǹ²Ïí³Ø¡£¹²Ïí³Ø´æ´¢ÁËÓ¦ÓÃÖ´ÐÐÐèÒªµÄPL/SQL¿é½á¹¹£¬SQLÓï¾äµÄÎı¾¡¢SQL±àÒëºóµÄ¿É
Ö´ÐдúÂ롢ϵͳÊý¾Ý×ÖµäµÈ¡£
Ç¡µ±µÄ¹²Ïí³Ø³ß´çÉèÖý«¼õÉÙϵͳ¸÷ÖÖ×ÊÔ´µÄʹÓá£Ê×ÏÈ£¬¶ÔÓÚSQL¡¢PL/SQL À´Ëµ£¬¹²Ïí³ØÌṩÁËÔËÐÐ״̬ϵÄÁÙʱ
´æ´¢µã£¬ºóÐøÖ´ÐеÄSQLºÍPL/SQL½«Ê¹ÓÃÒѱ»»º´æµÄ±àÒë½á¹û¼°Ö´Ðмƻ®£¬ÓÐЧ¼õÉÙϵͳCPUµÄʹÓ㬼õÉÙÓû§µ÷ÓÃʼþ¡£
µÚ¶þ£¬Ë¨¡¢Ëø×ÊÔ´µÄÕùÓñ»»·½Ú¡£µÚÈý£¬Êý¾Ý×ÖµäÐÅÏ¢½«±»»º´æÔÚ¹²Ïí³ØÖУ¬Òò´Ë£¬ÓйØÏµÍ³µÄÐÅÏ¢²»±ØÔÙÈ¥Ö´Ðвéѯ£¬
Õâ¾Í½µµÍÁË×ÊÔ´µÄʹÓá£
Ôڿ⻺´æÖÐÇøÓòÖУ¬´æ´¢×ÅSQL¡¢PL/SQL¡¢JavaÀàµÄÔ´Âë¡¢Ö´Ðмƻ®¡¢Î±±àÒëºó¿ÉÖ´ÐдúÂëµÈ¡£µ±Ó¦ÓóÌÐòÔËÐÐʱ£¬ÕâЩ´úÂë»á±»µ÷Óá£Èç¹ûÕâЩ´úÂëÔÚÇ°Ãæ²»¾ÃµÄÓ¦ÓÃÔËÐÐÖÐÒѾ±»µ÷ÓÃÖ´Ðйý£¬Ôò¿ÉÄܱ»ºóÐøÖ´ÐеÄÓ¦ÓóÌÐò¹²Ïí¡£Ä¬Èϵأ¬Oracle½«ÊÔÍ¼ÖØ¸´Ê¹ÓÃÏÖÓеĴúÂ룬ʵÏÖÖØÓá£Ò²¾ÍÊÇ˵£¬ºóÐøÓ¦ÓõÄÖ´ÐÐÄܹ»ÒýÓÃǰÆÚÓ¦ÓÃÖ´ÐÐÖбàÒë¹ýµÄ´úÂ룬Õâ³ÆÎª¿â»º´æµÄ“ÃüÖД¡£Ò»´ÎÃüÖÐÒâζ×ÅÒ»´Î
ÈçÈí½âÎö£¬SQL¡¢PL/SQLµÄÓ²½âÎö¼°±àÒë¹ý³ÌµÄ×ÊÔ´¿ªÏú½«±»±ÜÃâ¡£
¼ÙÉèºóÐøÓ¦ÓÃÔÚÖ´ÐÐÖв»ÄÜͨ¹ý¿â»º´æÊµÏÖ“Èí½âÎö”£¬Oracle ²»µÃ²»ÎªSQL¡¢PL/SQL ½øÐÐÓï·¨½âÎö¡¢Ö´Ðмƻ®·ÖÎöºÍ±àÒ룬ÒÔ¼°
Ó¦ÓôúÂë¿ÉÖ´Ðа汾µÄ´´½¨¡£Õâ¸ö¹ý³Ì³ÆÎª“Ó²½âÎö”£¬Ó²½âÎöÐèÒªÕû¸öϵͳ¸¶³ö¶îÍâµÄCPUʱ¼äƬ¡¢¿â»º´æË¨×ÊÔ´µÈ¡£
´ÓÐÔÄÜÉÏ¿´£¬ÎÒÃǵ±È»Ï£ÍûÄܾ¡¿ÉÄܵØÊµÏÖÈí½âÎö£¬¼õÉÙÓ²½âÎö¡£×öµ½ÕâÒ»µãÐèÒª½øÐÐÁ½·½ÃæµÄ×¼±¸¹¤×÷£ºÄܹ»ÖØÓõÄSQLºÍ
PL/SQL¡¢×ã¹»³ß´çµÄ¹²Ïí³Ø¡£
SQLÓëPL/SQLÖØÓÃ
µ±Óû§ÏëOracle ·¢³öSQL¡¢PL/SQLÇëÇóʱ£¬Oracle½«Ê×ÏÈÈ·¶¨ÕâЩSQLÓï¾ä¡¢PL/SQL¿éÊÇ·ñ¿ÉÒÔÔÚ¹²Ïí³ØÖÐÕÒµ½ÏàͬµÄ
Óï¾ä£¬¹ý³ÌÈçÏÂ:
1>¸ù¾ÝÒªÖ´ÐеÄÓï¾äÎı¾£¬ºÍ¹²Ïí³ØÖÐÏÖÓÐÓï¾äÎı¾½øÐбȽÏ
2>Èç¹û¹²Ïí³ØÖÐûÓÐÕÒµ½ÏàͬµÄÓï¾ä£¬ËµÃ÷SQLÓï¾äÔÚ¹²Ïí³ØÖв»´æÔÚ£¬¿ªÊ¼Ö´ÐÐÓ²½âÎö²Ù×÷¡£
3>Èç¹ûÕÒµ½Æ¥ÅäµÄÓï¾ä£¬Oracle ¼ÌÐø°ÑÆ¥ÅäÓï¾äµÄÕýÎĺͻº´æ³ØÖеÄSQLÕýÎĽøÐÐÑϸñ±È½Ï£¬°üÀ¨¿Õ¸ñ¡¢´óСд¡¢×¢Ê͵ȡ£
ÀýÈçÏÂÃæÁ½ÌõÓï¾ä¾ÍÊDz»Í¬µÄ£¬ËäȻֻÊǶàÁËÒ»¸ö¿Õ¸ñ¡¢´óСдÓÐЩ²»Ò»Ö¡£
SELECT name from Mytable;
SELECT name from mytable;
OracleÔڱȽÏÓï¾äʱ£¬³
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
Êý¾Ý±íday_energyµ±Ç°ÎªÔ·ÖÇø±í£¬·ÖÇøÐÅÏ¢ÈçÏ£ºDE_200912,DE_201001,DE_201002.....,Ô·ÖÇø±í³öÏÖËٶȲéѯÂý£¬Òò´Ëͨ¹ý½¨Á¢ÈÕ·ÖÇø±í½øÐиÄÉÆ¡£
²ð·ÖÔ·ÖÇø±íµÄÓï¾äΪ£º
alter table day_energy split partition de_201001 at('20100102') into (partition de_20100101,partition de_20100102)
·ÖÎö£º
alter table ±íà ......
---------Êýѧº¯Êý
1.¾ø¶ÔÖµ
S:select abs(-1) value
O:select abs(-1) value from dual
2.È¡Õû(´ó)
S:select ceiling(-1.001) value
O:select ceil(-1.001) value from dual
3.È¡Õû£¨Ð¡£©
S:select floor(-1.001) value
O:select floor(-1.001) value from dual
4.È¡Õû£¨½ØÈ¡£©
S:select cast(-1.002 as int) v ......
·½·¨Ò»£º×î¼òµ¥µÄ·½·¨£¨Ð轨¿â£©
±¸·Ý£º
Ö±½Ó¿½±´oracleĿ¼ÏµÄadmin¡¢oradataÁ½¸öÎļþ¼Ð£¬ora92Ŀ¼ÏÂdatabase£¬µ½ÆäËû´æ´¢ÊµÏÖ±¸·Ý¡£
»Ö¸´£º
1.´´½¨Ò»¸öºÍÔÀ´Ò»ÑùµÄÊý¾Ý¿â¡£(°²×°Â·¾¶ºÍÊý¾Ý¿âÃû±ØÐëºÍÔÀ´Ò»ÖÂ)
2.ÓùÜÀíÔ±Á¬ÈëÊý¾Ý¿âºóÍ£Ö¹Êý¾Ý¿â¡£
3.°Ñ°²×°Ä¿Â¼ÏµÄadminºÍoradata¸´ÖƹýÈ¥¸²¸Ç£¨Èç¹û´æÔÚ ......