³ÉΪOracle DBA×î»ù±¾µÄÊ®²½
Ëæ×ÅOracle¼¼ÊõºÍÊг¡µÄ¿ìËÙ·¢Õ¹£¬Ä¿Ç°´ÓÊÂOracle DBA¹¤×÷µÄÈËȺԽÀ´Ô½ÅӴ󣬴ÓһЩÎÒ¾³£È¥µÄÂÛ̳ºÍÉçÇøÖдó¼Ò·¢µÄÌû×ÓÉÏ¿´µÄ³ö£¬ºÜ¶àÈ˶¼¿ÊÍûÔÚÏÖÔÚ»ò½«À´´ÓÊÂÕâÒ»ÁìÓòµÄ¹¤×÷£¬ÏÖÔÚµÄÊг¡ÐèÇóÒ²ºÜ´ó£¬µ«²»ÄÑ¿´³ö£¬¸÷¸ö¹«Ë¾¶ÔDBAÕâ¸ö¸ÚλµÄÒªÇóÒ²Ô½À´Ô½¸ß£¬µ±È»ÁË£¬¸ßн¡¢¸ßÌôÕ½ºÍ¿É³ÖÐø·¢Õ¹µÄְҵͨµÀÎüÒýÁË´óÁ¿µÄÄêÇáÈËÈ¥³¢ÊÔ½øÈëÕâÒ»ÁìÓò¹¤×÷.¡¡
¶ÔÒ»¸öÒÔǰûÔõô½Ó´¥¹ýOracle DatabaseµÄÐÂÊÖÀ´Ëµ,ÈçºÎ²ÅÄÜ¿ìËٵijÉΪһ¸öOracle DBA,ÊÇËûÃÇÄ¿Ç°ËùÆÈÇпÊÍûµÄ.ºÜ¶àÈËÒòΪѧϰµÄ·½·¨²»¶Ô,×ßÈëÁËÎóÇø,¸Ð¾õµ½Ô½Ñ§Ô½ÀÛ,ԽѧԽºýÍ¿,ԽѧԽ²»Ã÷°×...¡¡
¹ØÓÚѧϰ·½·¨Õâ¸öÎÊÌâ,¿ÉÒÔ˵ÊÇÈÊÕß¼ûÈÊ,ÖÇÕß¼ûÖÇ.ÿ¸öÈ˶¼ÓÐÒ»Ì××Ô¼ºÒѾϰ¹ßÁËѧϰģʽºÍ½ÓÊÕÐÂÊÂÎïµÄÏ°¹ß.Oracle ACE ¸Ç¹úÇ¿ÏÈÉúΪºóÀ´µÄѧµÜѧÃÃÃÇÌá³öÁ˺ܶ౦¹óµÄÒâ¼ûºÍ½¨Òé.¡¡
ÏÂÃæժ¼һЩ¸Ç¹úÇ¿ÏÈÉú¶ÔOracle°®ºÃÕß¹ØÓÚѧϰ·½·¨ºÍ˼··½ÃæÔø¾Ìá̸µ½µÄ¾µä½¨Òé
1)¿Ë·þÐÄÀí¿Ö¾åÕÏ°
2)ѧ»áÈÏÕæÔĶÁ,»ù´¡ÖØÓÚÒ»ÇÐ
3)Óɵ㼰Ãæ¡¢ÓÉdzÈëÉî
4)ͨ¹ýʵ¼ù¼ìÑéËùѧ֪ʶ
5)¼û΢֪Öø¡¡
ÐËȤ + ÇÚ·Ü + ¼á³Ö + ·½·¨≈³É¹¦
¾ß±¸ÁËÕâЩ»ù±¾µÄËØÖÊ,ÔÙ¼ÓÉÏÇ¿ÁÒµÄÐËȤºÍ°®ºÃ,³ÉΪһ¸öOracle DBAÒ²²»ÊÇÒ»¼þ¶àôÀ§ÄѵÄÊÂ,¾ÍÏóѧϰÆäËûµÄ¼¼ÄÜÒ»Ñù,ÈëÃŲ¢²»ÊǺÜÄÑ,µ«ÔÚÕâ¸öÐÐÒµÄܲ»ÄÜ×ߵĸüÔ¶×öµÄ¸üºÃ,Ò»·½Ãæ³ýÁË×Ô¼ºÇڷܵÄŬÁ¦Í⣬ÁíÒ»·½ÃæÒ²Òª¿´Ò»Ð©»úÔµ!¡¡
Èç¹ûÄã¾ö¶¨´òËã×öÒ»¸öOracle DBA,ÄÇôÇëÏÈÍê³ÉÈçϵÄÕâЩ»ù±¾¹¦Á·Ï°,µÈÔúºÃÁË»ù´¡,ÔÙÖð²½µÄÑÐò½¥½ø,ÓÉdzÈëÉî!¡¡
ÔÚÏÂÃæµÄÿ¸ö²½ÖèÀï,¶¼Ô̺ÁË´óÁ¿µÄ֪ʶ,ÎÒÖ»ÊǸø³öÁËÒ»¸öѧϰµÄ¸ÙÒª,ÄãÄܲ»Äܳ¬Ô½¾Í¿´×Ô¼ºµÄÔ컯ÁË!
µÚÒ»²½:ÏÈÈÏʶOracle
1£©ÈÏʶOracle Database
2£©Á˽âOracle DatabaseµÄÌåϵ½á¹¹ºÍ¹¤×÷ÔÀí
3£©Á˽â¹ÜÀíOracle DatabaseµÄ³£Óù¤¾ßÓÐÄÄЩ£¿
4£©Á˽âÒ»°ãDBAµÄÈÕ³£¹¤×÷ÄÚÈÝ
µÚ¶þ²½:°²×°ÄãµÄµÚÒ»Ì×Oracle
1£©Ñ¡Ôñ°²×°Æ½Ì¨ºÍÈí¼þ
2£©¿ìËÙÔĶÁInstallation Guide,Á˽ⰲװÐèÇó
3£©°²×°OracleÏà¹ØÈí¼þ
4£©ÀûÓÃDBCA´´½¨¡¢ÅäÖÃÄãµÄµÚÒ»¸öOracleÊý¾Ý¿â
5£©ÀûÓÃDBUAÉý¼¶ÄãµÄµÚÒ»¸öÊý¾Ý¿âµ½½Ï¸ß°æ±¾
µÚÈý²½:ÈÏʶEM
DBA 2.0ʱ´úµÄ±Ø±¸¹¤¾ß
1£©´´½¨¡¢ÅäÖÃÄãµÄµÚÒ»¸ödbcontrol
2£©Í¨¹ýEMÀ´¹ÜÀíÄãµÄµÚÒ»¸öOracle Database
µÚËIJ½:ÅäÖÃOracleÍøÂç·þÎñ
1£©Àí½âOracle networkÔÀí
2£©ÀûÓÃnetcaÅäÖÃÄãµÄµÚÒ»¸ö¼àÌýºÍ·þÎñ
3£©Æô¶¯ºÍÍ£Ö¹¼àÌý¡¡
Ïà¹ØÎĵµ£º
author£ºskate
time£º2010-05-31
Ë÷ÒýÒ³¿éËéƬ£¨Index Leaf Block Fragmentation£©
ÕâƪÎÄÕ½«»á»Ø´ðÈçÏÂÎÊÌ⣺
ʲôÊÇË÷ÒýÒ³¿éËéƬ£¿Ê²Ã´Ê±ºò±»ÖØÓã¿
ʲôÊÇ°ë¿ÕË÷ÒýËéƬ£¿Ê²Ã´Ê±ºò±»ÖØÓã¿
oracleµÄ±ê×¼Ë÷Òý½á¹¹ÊÇB×tree½á¹¹£¬Ò»¸öB×tree½á¹¹ÓÉÈýÖÖblock×é³É
¸ù¿é(root block):ÔÚB×treeÀïÓÐÇÒÖ ......
author£ºskate
time£º2010-05-31
ÎÒÃÇÔÚʹÓÃwindowsµÄʱºò£¬¶¼ÖªµÀÒª¶¨ÆÚÕûÀí´ÅÅÌËéƬ£¬ÒòΪ´ÅÅÌËéƬ»áÓ°ÏìÐÔÄÜ£¬¸ø¹ÜÀíÉÏ´øÀ´¶îÍâµÄ
¸ºµ£¡£ÄÇoracle¸üÊÇÈç´Ë£¬µ±Ëæ×ÅÊý¾ÝÔö¼Ó£¬oracle´¦Àíº£Á¿Êý¾Ý±¾Éí¾ÍÒѾºÜ·ÑÁ¦ÁË°¡£¬Èç¹ûÔÙÓдóÁ¿
µÄËéƬ£¬ÄǾÍÊÇÑ©ÉϼÓ˪°¡¡£ËùÒÔËéƬҪÒýÆðdbaµÄ¸ß¶ÈÖØÊÓ£¬¾¡Ôç·¢ÏÖ¾¡Ôç´¦Àí¡£
莮 ......
---------------------------------------------------------------------------
---- ±¾ÎÄΪandkylee¸öÈËÔ´´£¬ÇëÔÚ×ðÖØ×÷ÕßÀͶ¯³É¹ûµÄÇ°ÌáϽøÐÐתÔØ£»
---- תÔØÎñ±Ø×¢Ã÷Ôʼ³ö´¦
:
http://blog.csdn.net/andkylee
--- 2010-05-31 22:56:43
---- ¹Ø¼ü×Ö£º oracle ·ÖÒ³ rownum
--------------------------------- ......
¼Ç¼һÏÂÒÔ±¸Ï´οìËÙÕÒµ½¡£¡£¡£
Íùtb_wf_privgrant±íÖвåÈëÒ»Ìõ¼Ç¼£¬workflow_id×Ö¶ÎÖµ´Ótb_wf_workflow ±íÖлñÈ¡workflow_name='֪ʶÉóºË'µÄËùÓмǼÖÐworkflow_id×î´óÖµ¡£
--oracle
declare a NUMBER(10);
begin
select max(wo ......
TO_DATE¸ñʽ(ÒÔʱ¼ä:2007-11-02 13:45:25ΪÀý)
Year:
yy two digits Á½Î»Äê ÏÔʾֵ:07
yyy three digits ÈýλÄê ......