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

jdbcÁ¬½ÓOracle

     ËäÈ»×Ô¼ºÑ§Ï°JavaÒ²»¹Ò»¶Îʱ¼äÁË£¬Ò²Á¬¹ýһЩÊý¾Ý¿â£¬±ÈÈç˵mysql£¬ÄÇÒÑÊǺó¤Ö®Ç°µÄÊÂÁË£¬µ«ÊÇÄØ£¬OracleÎҾʹÓδÁ¬¹ý£¬¾¡¹ÜÎÒѧϰOracleÒ²ÓÐÒ»¶Îʱ¼äÁË£¬ºÙºÙ£¬½ñÌì¾Í³¢ÊÔÁËÒ»ÅÌ£¬ÕæµÄ¾õµÃ£¬ËùÓеĶ«Î÷£¬¶¼Òª×Ô¼º³¢ÊÔ²ÅÐа¡¡£
    Ê×ÏÈÊÇдºÃÁËÁ¬½Ó£º


Ïà¹ØÎĵµ£º

Oracle 10g StatisticÊý¾Ýͳ¼Æ

http://www.ej38.com/showinfo/Oracle-108709.html
 Oracle 10g statisticÊý¾Ýͳ¼Æ,Oracle»á¸ù¾ÝÕâЩͳ¼ÆÐÅÏ¢À´¾ö¶¨ÊÇ×ßRBO(Rule-BasedOptimization)£¬»¹ÊÇ×ßCBO(Cost-BasedOptimization)£¬»áȥѡÔñÄÄÖÖÖ´Ðмƻ®¸ü»®Ëã,Ó°ÏìÊÇ·ñ×ßÏà¹ØµÄË÷ÒýµÈ.Èç¹ûÊÇCBOµÄ»°£¬ËüÒÀ¿¿×¼È·µÄ£¨»òÕß˵±È½Ï׼ȷµÄ£©Í³¼ÆÐÅÏ¢À´²úÉúÓÅ»¯µÄÖ ......

¹ØÓÚORACLEʱÇøÎÊÌâ

 ÎÒÃǵijɹ¦×ÜÊÇÕ¾ÔÚ¾ÞÈ˵ļç°òÉÏÎÒ£¬ÏÈתÁ˱ðÈ˾­Ñ飬×îºóÔÙ×ܽá×Ô¼ºµÄʵÑé½á¹û£¬Ñ§Ï°²ÅÄÜÓнø²½£¡
OracleµÄʱÇøÎÊÌâ
Oracle 9i ¿ªÊ¼¶àÁË 3 ¸ö¹ØÓÚʱ¼äµÄÊý¾ÝÀàÐÍ£ºTIMESTAMP [(precision)] TIMESTAMP [(precision)] WITH TIME ZONE TIMESTAMP [(precision)] WITH LOCAL TIME ZONE£¬ÆäÖÐ TIMESTAMP [(precision)] ......

Oracle±í¿Õ¼äºÍÊý¾ÝÎļþµÄ³£ÓòÙ×÷

±í¿Õ¼ä×ÊÁϲéѯ
SELECT tablespace_name, block_size, extent_management, segment_space_management from dba_tablespaces;
ÅäºÍ
SELECT tablespace_name, initial_extent, next_extent, max_extents, pct_increase, min_extlen from dba_tablespaces;
ÅäºÏ
SEL ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ