Oracle ASM Ïê½â
ASM:Automatic Storage Management, ÊÇOracle Ö÷ÍƵÄÒ»ÖÖÃæÏòOracleµÄ´æ´¢½â¾ö·½°¸£¬ ASM ºÍ RDBMS ·Ç³£ÏàËÆ£¬ASM Ò²ÊÇÓÉʵÀýºÍÎļþ×é³É£¬ Ò²¿ÉÒÔͨ¹ýsqlplus ¹¤¾ßÀ´Î¬»¤¡£
1. ASM ʵÀýÓÉSGA ºÍºǫ́½ø³Ì×é³É¡£
1.1 SGA ×é³É:
ASM ʵÀýµÄSGA°üÀ¨Buffer Cache£¬ Share Pool£¬ Large PoolµÈ¡£ ÐèҪעÒâµÄÊÇShare Pool£¬ ÒòΪExtent Map Òª·ÅÔÚÕⲿ·ÖµÄÄÚ´æÖУ¬ÐèÒª¸ü¾ßÊý¾ÝÁ¿À´¹À¼ÆExtent Map µÄ´óС×öÏàÓ¦µÄµ÷Õû¡£
Extent Map µÄ´óС¿ÉÒÔ¸ù¾ÝËùÓÐÎļþ´óСµÄºÍÀ´¹ÀË㣬ʹÓÃÏÂÃæµÄÓï¾äÀ´¼ÆËãËùÓÐÎļþºÍ£º
Select sum(bytes)/(1024*1024*1024) from v$datafile;
Select sum(bytes)/(1024*1024*1024) from v$logfile a, v$log b where a.Group#=b.Group#;
Select sum(bytes)/(1024*1024*1024) from v$tempfile where status='online';
Õâ3¸ösum µÄ×ܺͶÔÓ¦×ÅÊý¾Ý¿â´æ·ÅASMÖÐËùÓÐÎļþ´óС×ܺͣ¬ ¶ÔÓÚʹÓÃExternal Redundancy µÄ´ÅÅÌ×飬 ÿ100G ÐèÒª1MB µÄExtent Map£¬ ¸ù¾ÝÕâ¸ö±ÈÀý¼ÆËãExtent Map ËùÐèÒªµÄ¿Õ¼ä£¬ÔÚ¼ÓÉ϶îÍâµÄ2MB¾Í¿ÉÒÔÁË¡£ ÔÚʵ¼Ê¹¤×÷ÖÐÒ»°ã²»ÐèÒª¿¼ÂÇASM SGAµÄÅäÖ㬠ʹÓÃOracle ÌṩµÄȱʡֵ¾Í¿ÉÒÔÁË¡£
1.2 ºǫ́½ø³Ì
ASM ʵÀý±ÈRDBMS ʵÀý¶à2¸ö½ø³Ì£º RBAL ºÍ ABRn¡£
RBAL£º Õâ¸ö½ø³ÌÒ²½ÐRebalancer½ø³Ì£¬ ¸ºÔð¹æ»®ASM ´ÅÅÌ×éµÄReblance»î¶¯¡£
ABRn£ºÊÇRBAL½ø³ÌµÄ×Ó½ø³Ì£¬Õâ¸ö½ø³ÌÔÚÊýÁ¿ÉÏ¿ÉÒÔÓжà¸ö£¬ n´Ó1~9£¬ Õâ×é½ø³Ì¸ºÔðÕæÕý
Ïà¹ØÎĵµ£º
OleDbConnectioncon=newOleDbConnection(cnnstr);
try
{
con.Open();
}
catch
{}
OleDbCommandcmd=newOleDbCommand(strSQL,con);
System.Data.OleDb.OleDbDataReaderdr=cmd.ExecuteReader();
while(dr.Read())
{
stringdd=dr["gggg"].ToString();
byte[]ooo=(byte[])dr["hhhh"];
stringstr;
str=Sys ......
ÎÒÁгöÎÒÈ«²¿µÄ×ö·¨£º
table a ÓÐid1, str1, str2, str3
¿ªÊ¼µÄpkÊÇid1, str1, str2
Ï£Íû¸Ä³Éid1, str1, str3
--ÎÊÌâ
СµÜÏÈÓÐÈçÏÂÎÊÌ⣺
Ò»¸ö±íÔÀ´µÄPKÊÇ id1+str1+str2 ÁÐ
ÏÈÐ޸ijÉid1+str1+str3ÁÐ
¶øÕâÈýÁÐÏÖÔÚµ±Ç°Êý¾Ý¿âµÄÊý¾ÝÓÐÖظ´µÄÇé¿ö£¬ СµÜÏÖÔÚÓÃsql:
ALTER table a a ......
ÈÕ³£¿ª·¢»î¶¯ÖУ¬ÓÐʱºòÐèÒª¶ÔoracleÖ´Ðмƻ®½øÐмà¿Ø£¬ÒÔ´ËÀ´µ÷ÓųÌÐòºÍÊý¾Ý¿â·½ÃæµÄÐÔÄÜ¡£
³£Ó÷½·¨ÓÐÒÔϼ¸ÖÖ£º
Ò»¡¢Í¨¹ýPL/SQL Dev¹¤¾ß
1¡¢Ö±½ÓFile->New->Explain Plan Window£¬ÔÚ´°¿ÚÖÐÖ´ÐÐsql¿ÉÒԲ鿴¼Æ»®½á¹û¡£ÆäÖУ¬Cost±íʾcpuµÄÏûºÄ£¬µ¥Î»Îªn%£¬Cardinality±íʾִÐеÄÐÐÊý£¬µÈ¼ÛRow ......
±í¡¡¡¡¡¡¡¡tree
¡¡¡¡×ֶΡ¡¡¡¡¡master
¡¡¡¡¡¡¡¡¡¡¡¡¡¡sub
¡¡¡¡¡¡¡¡¡¡¡¡¡¡sales
¡¡¡¡insert into tree values
¡¡¡¡('Ö÷1',¡¡¡¡ 'Ö÷2',¡¡ 15);¡¡
¡¡¡¡insert into tree values¡¡¡¡¡¡
¡¡¡¡('Ö÷1',¡¡¡¡ 'Ö÷3',¡¡ 20);¡¡¡¡¡¡¡¡¡¡
¡¡¡¡insert into tree values
¡¡¡¡('Ö÷2',¡¡¡¡ 'Ö÷4',¡¡¡¡5);¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡
¡ ......