EXCELµ¼ÈëORACLE
·½·¨Ò»£¬Ê¹ÓÃSQL*Loader
Õâ¸öÊÇÓõĽ϶àµÄ·½·¨£¬Ç°Ìá±ØÐëoracleÊý¾ÝÖÐÄ¿µÄ±íÒѾ´æÔÚ¡£
´óÌå²½ÖèÈçÏ£º
1 ½«excleÎļþÁí´æÎªÒ»¸öÐÂÎļþ±ÈÈçÎļþÃûΪtext.txt£¬ÎļþÀàÐÍÑ¡Îı¾Îļþ£¨ÖƱí·û·Ö¸ô£©£¬ÕâÀïÑ¡ÔñÀàÐÍΪcsv£¨¶ººÅ·Ö¸ô£©Ò²ÐУ¬µ«ÊÇÔÚдºóÃæµÄcontrol.ctlʱҪ½«×Ö¶ÎÖÕÖ¹·û¸ÄΪ','(fields terminated by ',')£¬¼ÙÉè±£´æµ½cÅ̸ùĿ¼¡£
2 Èç¹ûûÓдæÔڵıí½á¹¹£¬Ôò´´½¨,¼ÙÉè±íΪtest£¬ÓÐÁ½ÁÐΪdm£¬ms¡£
3 ÓüÇʱ¾´´½¨SQL*Loader¿ØÖÆÎļþ£¬ÍøÉÏ˵µÄÎļþÃûºó׺Ϊctl£¬ÆäʵÎÒ×Ô¼º·¢ÏÖ¾ÍÓÃtxtºó׺ҲÐС£±ÈÈçÃüÃûΪcontrol.ctl£¬ÄÚÈÝÈçÏ£º(--ºóÃæµÄΪעÊÍ£¬Êµ¼Ê²»ÐèÒª£©
¡¡¡¡load data¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡ --¿ØÖÆÎļþ±êʶ
¡¡¡¡infile 'c:\test.txt'¡¡¡¡¡¡¡¡ --ÒªÊäÈëµÄÊý¾ÝÎļþÃûΪtest.txt(ÎļþÃûÒªºÍ±íÃûÏàͬ)
¡¡¡¡append into table test¡¡¡¡¡¡¡¡--Ïò±ítestÖÐ×·¼Ó¼Ç¼
¡¡¡¡fields terminated by X'09'¡¡¡¡--×Ö¶ÎÖÕÖ¹ÓÚX'09'£¬ÊÇÒ»¸öÖÆ±í·û£¨TAB£©
¡¡¡¡(dm,ms)¡¡¡¡ --¶¨ÒåÁжÔӦ˳Ðò
±¸×¢£ºÊý¾Ýµ¼ÈëµÄ·½Ê½ÉÏÀýÖÐÓõÄappend£¬ÓÐһϼ¸ÖÖ£ºinsert£¬ÎªÈ±Ê¡·½Ê½£¬ÔÚÊý¾Ý×°ÔØ¿ªÊ¼Ê±ÒªÇó±íΪ¿Õ£»append£¬ÔÚ±íÖÐ×·¼ÓмǼ£»replace£¬É¾³ý¾É¼Ç¼£¬Ìæ»»³ÉÐÂ×°ÔØµÄ¼Ç¼
£»truncate£¬Í¬replace¡£ &n
Ïà¹ØÎĵµ£º
±í¿Õ¼ä×ÊÁϲéѯ
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 ......
ËäÈ»×Ô¼ºÑ§Ï°JavaÒ²»¹Ò»¶Îʱ¼äÁË£¬Ò²Á¬¹ýһЩÊý¾Ý¿â£¬±ÈÈç˵mysql£¬ÄÇÒÑÊǺó¤Ö®Ç°µÄÊÂÁË£¬µ«ÊÇÄØ£¬OracleÎҾʹÓδÁ¬¹ý£¬¾¡¹ÜÎÒѧϰOracleÒ²ÓÐÒ»¶Îʱ¼äÁË£¬ºÙºÙ£¬½ñÌì¾Í³¢ÊÔÁËÒ»ÅÌ£¬ÕæµÄ¾õµÃ£¬ËùÓеĶ«Î÷£¬¶¼Òª×Ô¼º³¢ÊÔ²ÅÐа¡¡£
Ê×ÏÈÊÇдºÃÁËÁ¬½Ó£º ......
ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
Ê×ÏÈ£¬Ô ......
¸Õ²ÅÉÏÍøËÑcheckpoint cnt£¬¿´µ½EYGLEдµÄһƪÎÄÕ£¬Ð´µÃ²»´í£¬´æÆðÀ´·½±ãÒÔºóѧϰ¡£
=========================================================================
ͨ¹ýÊÔÑé˵Ã÷checkpoint cnt ºÍcheckpoint scnµÄ¹ØÏµ
1.ÔÚ²»Í¬Ìõ¼þÏÂת´¢¿ØÖÆÎļþ
SQL> alter session set events 'immediate trace name C ......