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

Oracle¶Î¸ßˮλ(HWM, high water mark)ÎÊÌâ

Oracle¶Ô±í×öÈ«±íɨÃèµÄʱºò
£¬»áɨÃèÍêHWMÒÔÏÂ
µÄÊý¾Ý¿é¡£Èç¹ûij¸ö±ídelete(delete²Ù×÷²»»á½µµÍ¸ßˮλ)ÁË´óÁ¿Êý¾Ý£¬ÄÇôÕâʱ¶Ô±í×öÈ«±íɨÃè¾Í»á×öºÜ¶àÎÞÓù¦£¬É¨ÃèÁËÒ»´ó¶ÑÊý¾Ý¿é£¬×îºó·¢ÏÖ¿éÀïÃæ¾ÓȻûÓÐÊý¾Ý¡£
ͨ³££¬ÔÚ¶Ô±í×öÁË´óÅúÁ¿delete²Ù×÷Ö®ºó£¬¾ÍÓ¦¸ÃÂíÉϽµµÍ±íµÄ¸ßˮ룬¿ÉÒÔʹÓÃshrink ÃüÁî»òÕßalter table table_name move½µµÍ±íµÄ¸ßˮλ¡£ÔÚ½µµÍ±íµÄ¸ßˮλ֮ºó£¬±íÉÏÃæµÄË÷Òý»áʧЧ£¬ÒòΪ±íµÄrowid¸ü¸ÄÁË£¬Õâ¸öʱºòÐèÒªrebuildË÷Òý¡£
ÈçºÎÇó³ö¶ÎµÄ¸ßˮλ£¿ÆäʵºÜ¼òµ¥£¬Ê×ÏȶԱíÊÕ¼¯Í³¼ÆÐÅÏ¢£¬È»ºó²éѯDBA_TABLESµÄblocks£¬ÒÔ¼°empty_blocks×ֶΣ¬blocks±íʾÒѾ­ÓÃÁ˶àÉÙ¸öblocks,empty_blocks±íʾ´ÓÀ´Ã»ÓÐʹÓùýµÄblocks¡£ÄÇôblocks¾Í±íʾ¶ÎµÄ¸ßˮλ¡£
¿ÉÒÔʹÓÃÏÂÃæµÄÓï¾ä²é¿´±íµ½µ×ÓÃÁ˶àÉÙ¸öblocks
select count( distinct dbms_rowid.rowid_block_number(rowid)) from table_name;
 
    È»ºóÔÙ¶Ô±Èdba_tables±íÖеÄblocksÁУ¬Èç¹ûÇó³öµÄblocksÊýÓëdba_tablesÏà²îÔÚ10×óÓÒ£¬ÄÇô±íʾÕâ¸ö±í²»ÐèÒªshrink,ÓÃÉÏÃæµÄ½Å±¾Çó³öµÄblocksÊýû¼ÆËã¶ÎÍ·£¬Î»Í¼¹ÜÀí¿é¡£Èç¹ûÏà²îºÜ´ó£¬ÄÇô±íʾÕâ¸ö±íÐèÒªshrinkÁË£¬²»¹ýÕâÑù×ö±È½ÏÂé·³£¬²»ÊÇÂð£¿
Æäʵ»¹¿ÉÒÔ¼à¿Ø±íµÄDML²Ù×÷£¬¸ù¾Ý¼à¿ØµÄ½á¹û£¬ÎÒÃǾͿÉÒÔÅжÏÄÄЩ±íÐèÒª½µµÍ¸ßˮλ¡£ÔÚOracle10gÖÐDBA_TAB_MODIFICATIONSÕâ¸öÊÓͼ¼Ç¼ÁË×ÔÉÏ´ÎÊÕ¼¯Í³¼ÆÐÅÏ¢ÒÔÀ´±íµÄDML²Ù×÷ÐÅÏ¢¡£µ±ÎÒÃÇÔٴζԱíÊÕ¼¯Í³¼ÆÐÅÏ¢£¬¸ÃÊÓͼµÄ¼Ç¼¾Í»á±»Çå¿Õ¡£
¶ÔÓÚ·Ç·ÖÇø±í£¬¿ÉÒÔʹÓÃÏÂÃæ½Å±¾³õ²½¼ì²âÄÄЩ±íÐèÒª½µµÍ¸ßˮλ
 
exec  DBMS_STATS.FLUSH_DATABASE_MONITORING_INFO ;
col table format a35
select a.owner || '.' || a.table_name "Table",a.num_rows,a.avg_row_len,b.inserts,b.deletes,a.num_rows+nvl(b.inserts,0)-nvl(b.deletes,0) total_rows,
round(a.avg_row_len*(a.num_rows+nvl(b.inserts,0)-nvl(b.deletes,0))/1024/1024,4) "Calculate_Sizle(Mb)",c.bytes/1024/1024 "Segment_Size(Mb)"
from dba_tables a left join all_tab_modifications b 
on  a.owner=b.table_owner and a.table_name=b.table_name  inner join dba_segments c&n


Ïà¹ØÎĵµ£º

OracleºÍSQL serverµÄÊý¾ÝÀàÐͱȽÏ


ÀàÐÍÃû³Æ
Oracle
SQLServer
±È½Ï
×Ö·ûÊý¾ÝÀàÐÍ
CHAR
CHAR
¶¼Êǹ̶¨³¤¶È×Ö·û×ÊÁϵ«oracleÀïÃæ×î´ó¶ÈΪ2kb£¬SQLServerÀïÃæ×î´ó³¤¶ÈΪ8kb
±ä³¤×Ö·ûÊý¾ÝÀàÐÍ
VARCHAR2
VARCHAR
OracleÀïÃæ×î´ó³¤¶ÈΪ4kb£¬SQLServerÀïÃæ×î´ó³¤¶ÈΪ8kb
¸ù¾Ý×Ö·û¼¯¶ø¶¨µÄ¹Ì¶¨³¤¶È×Ö·û´®
NCHAR
NCHAR
Ç°Õß×î´ó³¤¶È2kbºóÕß×î´ó³¤¶È4 ......

Oracle tnslsnrÉèÖÿÚÁî

CmdÃüÁîÐÐÊäÈëlsnrctl½øÈë¼àÌýģʽ£¬Í¨¹ýset passwordÉèÖÃÃÜÂë¡£
ͨ¹ý change_password ÐÞ¸ÄÃÜÂë¡£
LSNRCTL> help
ÒÔϲÙ×÷¿ÉÓÃ
ÐǺŠ(*) ±íʾÐ޸ķû»òÀ©Õ¹ÃüÁ
 
start               stop    &nbs ......

Oracle 9iÐÔÄܵ÷Õû


Oracle 9iÐÔÄܵ÷Õû
/* *
×÷Õß:Å·³¯¾´
QQ:35712069
ÊÖ»ú:13873195792
ÇëתÔØÕß²»Òª¸ü¸ÄÔ­°æÄÚÈÝ
 */
1¡¢ÉèÖúÏÊʵÄSGA
¡¡¡¡³£³£ÓÐÈ˱§Ô¹·þÎñÆ÷Ó²¼þºÜºÃ£¬µ«ÊÇOracle¾ÍÊǺÜÂý¡£ºÜ¿ÉÄÜÊÇÄÚ´æ·ÖÅä²»ºÏÀíÔì³ÉµÄ¡£
¡¡¡¡(1)¼ÙÉèÄÚ´æÓÐ512M£¬Õâͨ³£ÊÇСÐÍÓ¦Ó᣽¨ÒéOracleµÄSGA´óÔ¼240M£¬ÆäÖУº¹²Ïí³Ø£¨SHARED_POOL ......

Ubuntu10.04Ï°²×°Oracle 10G






<!--
@page { margin: 2cm }
P { margin-bottom: 0.21cm }
-->
¹«ÍøÖÕÓÚͨµÄ£¬ÎÒµÄubuntu
Ò²ÖÕÓÚ¿ÉÒÔ¼ÌÐøʹÓÃÁË¡£¡£¡£


Ê×ÏȰѱ¾×ÓµÄubuntu
´Ó9.04
Éý¼¶µ½10.04
£¬·¢ÏÖϵͳ±ä³ÉÓ¢ºº»ìÓÃÁË£¬ÖØÑ¡ÓïÑÔÖ§³Ö°üÒ²²»¿ÉÒÔ£¬ÊäÈë·¨Ò²Ìí¼Ó²»ÉÏ£¬µ¹ÊÇûÓÐÍøÉÏÓÐÈËÌáµ½µÄϵͳÏìÓ¦·Ç³£»ºÂýµÄÎ ......

oracle ´æ´¢¹ý³ÌµÄ»ù±¾Óï·¨ ¼°×¢ÒâÊÂÏî

oracle ´æ´¢¹ý³ÌµÄ»ù±¾Óï·¨ ¼°×¢ÒâÊÂÏî
oracle ´æ´¢¹ý³ÌµÄ»ù±¾Óï·¨
1.»ù±¾½á¹¹
CREATE OR REPLACE PROCEDURE ´æ´¢¹ý³ÌÃû×Ö
(
    ²ÎÊý1 IN NUMBER,
    ²ÎÊý2 IN NUMBER
) IS
±äÁ¿1 INTEGER :=0;
±äÁ¿2 DATE;
BEGIN
END ´æ´¢¹ý³ÌÃû×Ö
2.SELECT INTO STATEMENT
  ½«selec ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ