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

³ÉΪ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£©Æô¶¯ºÍÍ£Ö¹¼àÌý¡¡


Ïà¹ØÎĵµ£º

oracleË÷ÒýËéƬ

author£ºskate
time£º2010-05-31
Ë÷ÒýÒ³¿éËéƬ£¨Index Leaf Block Fragmentation£©
ÕâƪÎÄÕ½«»á»Ø´ðÈçÏÂÎÊÌ⣺
ʲôÊÇË÷ÒýÒ³¿éËéƬ£¿Ê²Ã´Ê±ºò±»ÖØÓã¿
ʲôÊÇ°ë¿ÕË÷ÒýËéƬ£¿Ê²Ã´Ê±ºò±»ÖØÓã¿
oracleµÄ±ê×¼Ë÷Òý½á¹¹ÊÇB×tree½á¹¹£¬Ò»¸öB×tree½á¹¹ÓÉÈýÖÖblock×é³É
¸ù¿é(root block):ÔÚB×treeÀïÓÐÇÒÖ ......

oracleËéƬС½á

author£ºskate
time£º2010-05-31
ÎÒÃÇÔÚʹÓÃwindowsµÄʱºò£¬¶¼ÖªµÀÒª¶¨ÆÚÕûÀí´ÅÅÌËéƬ£¬ÒòΪ´ÅÅÌËéƬ»áÓ°ÏìÐÔÄÜ£¬¸ø¹ÜÀíÉÏ´øÀ´¶îÍâµÄ
¸ºµ£¡£ÄÇoracle¸üÊÇÈç´Ë£¬µ±Ëæ×ÅÊý¾ÝÔö¼Ó£¬oracle´¦Àíº£Á¿Êý¾Ý±¾Éí¾ÍÒѾ­ºÜ·ÑÁ¦ÁË°¡£¬Èç¹ûÔÙÓдóÁ¿
µÄËéƬ£¬ÄǾÍÊÇÑ©ÉϼÓ˪°¡¡£ËùÒÔËéƬҪÒýÆðdbaµÄ¸ß¶ÈÖØÊÓ£¬¾¡Ôç·¢ÏÖ¾¡Ôç´¦Àí¡£
莮 ......

OracleÖÐʵÏÖ·ÖÒ³µÄ·½·¨

---------------------------------------------------------------------------
---- ±¾ÎÄΪandkylee¸öÈËÔ­´´£¬ÇëÔÚ×ðÖØ×÷ÕßÀͶ¯³É¹ûµÄÇ°ÌáϽøÐÐתÔØ£»
---- תÔØÎñ±Ø×¢Ã÷ԭʼ³ö´¦
:
http://blog.csdn.net/andkylee
--- 2010-05-31 22:56:43
---- ¹Ø¼ü×Ö£º oracle ·ÖÒ³ rownum
--------------------------------- ......

oracleÓësqlserver²åÈëÊý¾Ý¶¯Ì¬×Ö¶ÎÖµ

¼Ç¼һÏÂÒÔ±¸Ï´οìËÙÕÒµ½¡£¡£¡£
       Íùtb_wf_privgrant±íÖвåÈëÒ»Ìõ¼Ç¼£¬workflow_id×Ö¶ÎÖµ´Ótb_wf_workflow ±íÖлñÈ¡workflow_name='֪ʶÉóºË'µÄËùÓмǼÖÐworkflow_id×î´óÖµ¡£
--oracle
declare   a NUMBER(10);
   begin
   select  max(wo ......

OracleÖÐTO_DATE¸ñʽ ÀÁèÐÇ¿Õ

TO_DATE¸ñʽ(ÒÔʱ¼ä:2007-11-02   13:45:25ΪÀý)
Year:     
yy two digits Á½Î»Äê                ÏÔʾֵ:07
yyy three digits ÈýλÄê           ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ