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

[×ªÔØ]oracle DBA technologies

֮ǰ¿´µ½Ò»ÆªÎÄÕÂ, ¾õµÃ²»´í! ¿´Á˺ó,·¢¾õ×Ô¼º»¹ÓÐºÜ¶àµØ·½ÐèÒª²¹×ã, »¹ÐèҪŬÁ¦°¡£¡ÈÎÖØ¶øµÀÔ¶£¡
DBAÐèÒªµÄ¼¼ÄÜ
dbaÕÆÎյļ¼Êõ
    1.      os : linux,solaris»òÆäËûunixÆðÂëÒªÒ»ÖÖ
    2.      bash (²»¾«Í¨Ò²ÒªÊì)  LINUXÓëUNIX SHELL±à³ÌÖ¸ÄÏ.pdf      
    3.      perl °üÀ¨:
             Perl_CD_BookShelf.chm
             learning perl
             perl pragramming¡¡
    4.      java£¨ÕÆÎÕ£©°üÀ¨jdbc thin,ociµÈ4À಻ͬµÄÁ¬½Ó·½Ê½£¬ÐÔÄÜÉèÖã¬Ò»Ð©Öмä¼þµÄ֪ʶ
            Á˽âһЩ¾Í¹»ÁË
    5.      oracle performance tuning£¨·¶Î§ºÜ¹ã£©
             ocp performance book     
             ÏÂtomµÄÊé¡¶Wrox - Expert one-on-one Oracle¡·£¬  
             http://www.ebookcn.net/Soft/Soft_12042.htm
             http://zuse.esnig.cifom.ch/database/doc_oracle/Oracle920_Linux/
             server.920/a96533/toc.htm[/url]
             oracle sql hign performance tuning 2nd editon by guy  harrison        
       6.    pl/sql
              OReilly_oracle_Bookshelf¡¡°üÀ¨£º
    &nb


Ïà¹ØÎĵµ£º

oracle¸´Ï°£¨Ò»£© Ö®OracleÌåϵ½á¹¹

      ѧϰOracle DBAÒ²°ë¸ö¶àѧÆÚÁË£¬½ñÌìÃÍÈ»²Å·¢ÏÖ£¬Ô­À´ÎÒµÄÊ黹ÊǺÜеģ¬ÉϿβÙ×÷ʱºòÒ²Ö»ÊÇÖªµÀ´ó¸ÅÔõô×ö£¬µ«ÊÇÒªÕæµÄÈ«²¿×Ô¼º×ö£¬¶ø²»È¥·­Ê黹ÊÇÓÐÒ»¶¨µÄÄѶȵģ¬ËùÒÔÄØ£¬½ñÌ쿪ʼ½«DBA´ÓÍ·¸´Ï°Ò»±é£¬Í¬Ê±ÔÙ²Ù×÷Ò»±é¡£
      µÚÒ»Õ£¬Ñ§µÄÊÇOracleµÄÌåϵ½á¹¹£ ......

ѧϰ¡¶Oracle 9i10g±à³ÌÒÕÊõ¡·µÄ±Ê¼Ç (Ê®Èý) Ë÷Òý

1.¸ÅÊö
Ë÷ÒýÊÇÓ¦ÓÃÉè¼ÆºÍ¿ª·¢µÄÒ»¸öÖØÒª·½Ãæ¡£Èç¹ûÓÐÌ«¶àµÄË÷Òý£¬DML µÄÐÔÄܾͻáÊܵ½Ó°Ïì¡£Èç¹ûË÷ÒýÌ«
ÉÙ£¬ÓÖ»áÓ°Ïì²éѯ£¨°üÀ¨²åÈë¡¢¸üкÍɾ³ý£©µÄÐÔÄÜ¡£ÒªÕÒµ½Ò»¸öºÏÊÊµÄÆ½ºâµã£¬Õâ¶ÔÓÚÓ¦ÓõÄÐÔÄÜÖÁ¹Ø
ÖØÒª¡£
ÎÒ³£³£·¢ÏÖ£¬ÈËÃÇÔÚÓ¦Óÿª·¢ÖÐ×ÜÊÇʺó²ÅÏëÆðË÷Òý¡£ÎÒ¼á³ÖÈÏΪÕâÊÇÒ»ÖÖ´íÎóµÄ×ö·¨¡£Èç¹ûÄãÖª
µÀÊý¾Ý½«ÈçºÎ ......

OracleÊý¾Ý¿â»¹Õæ²»ºÃÕû

´ÓÔÚLinuxÉϰ²×°Oracleµ½Í¶ÈëʹÓòż¸Ì죬Åöµ½µÄÎÊÌâ¾Í³É°ÙÉÏǧµÄ¡£ÔÚʹÓÿͻ§¶ËÁ¬½ÓÔ¶³ÌOracleÊý¾Ý¿â·þÎñÆ÷ʱ£¬³öÏÖÁËlistener refused the connection with the following error ora-12519 Listener refused the connection with the following error:ORA-12519, TNS:no appropriate service handler foundThe Connection ......

hibernate¸ù¾Ýʱ¼äÈÕÆÚÀ´²éѯoracleÊý¾Ý¿â

ʹÓÃÄ£ºý²éѯ£º
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-mm-dd"); 
Date startdate = sdf.parse(start_date);
Date enddate = sdf.parse(end_date);
List list = sess.createCriteria(MyTabel.class)
               .add( ......

oracle ÕÒ³öÁ½±íÖ®¼ä·ÇÖØ¸´Êý¾Ý

select r.rollid as rollid from zh1_rool r where r.date_p >=to_date('2009-11-26 23:59:59','yyyy-mm-dd hh24:mi:ss') and rollid not in
(select t.lot_number as rollid
from inv.mtl_onhand_quantities_detail t
left join mtl_system_items_b mi
on t.inventory_item_id = mi.inventory_ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ