jdbcÁ¬½ÓOracle
ËäÈ»×Ô¼ºÑ§Ï°JavaÒ²»¹Ò»¶Îʱ¼äÁË£¬Ò²Á¬¹ýһЩÊý¾Ý¿â£¬±ÈÈç˵mysql£¬ÄÇÒÑÊǺó¤Ö®Ç°µÄÊÂÁË£¬µ«ÊÇÄØ£¬OracleÎҾʹÓδÁ¬¹ý£¬¾¡¹ÜÎÒѧϰOracleÒ²ÓÐÒ»¶Îʱ¼äÁË£¬ºÙºÙ£¬½ñÌì¾Í³¢ÊÔÁËÒ»ÅÌ£¬ÕæµÄ¾õµÃ£¬ËùÓеĶ«Î÷£¬¶¼Òª×Ô¼º³¢ÊÔ²ÅÐа¡¡£
Ê×ÏÈÊÇдºÃÁËÁ¬½Ó£º
Ïà¹ØÎĵµ£º
http://www.ej38.com/showinfo/Oracle-108709.html
Oracle 10g statisticÊý¾Ýͳ¼Æ,Oracle»á¸ù¾ÝÕâЩͳ¼ÆÐÅÏ¢À´¾ö¶¨ÊÇ×ßRBO(Rule-BasedOptimization)£¬»¹ÊÇ×ßCBO(Cost-BasedOptimization)£¬»áȥѡÔñÄÄÖÖÖ´Ðмƻ®¸ü»®Ëã,Ó°ÏìÊÇ·ñ×ßÏà¹ØµÄË÷ÒýµÈ.Èç¹ûÊÇCBOµÄ»°£¬ËüÒÀ¿¿×¼È·µÄ£¨»òÕß˵±È½Ï׼ȷµÄ£©Í³¼ÆÐÅÏ¢À´²úÉúÓÅ»¯µÄÖ ......
ÎÒÃǵijɹ¦×ÜÊÇÕ¾ÔÚ¾ÞÈ˵ļç°òÉÏÎÒ£¬ÏÈתÁ˱ðÈ˾Ñ飬×îºóÔÙ×ܽá×Ô¼ºµÄʵÑé½á¹û£¬Ñ§Ï°²ÅÄÜÓнø²½£¡
OracleµÄʱÇøÎÊÌâ
Oracle 9i ¿ªÊ¼¶àÁË 3 ¸ö¹ØÓÚʱ¼äµÄÊý¾ÝÀàÐÍ£ºTIMESTAMP [(precision)] TIMESTAMP [(precision)] WITH TIME ZONE TIMESTAMP [(precision)] WITH LOCAL TIME ZONE£¬ÆäÖÐ TIMESTAMP [(precision)] ......
±í¿Õ¼ä×ÊÁϲéѯ
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 ......