Oracle ´´½¨²»Í¬Êý¾Ý¿éµÄ±í¿Õ¼ä
OracleÊý¾Ý¿âµÄÊý¾Ý¿éDB_BLOCK_SIZE´óСȷ¶¨Êý¾Ý¿âµÄ×îСÊý¾Ý¿éµÄ´óС£¬ÔÚ´´½¨±í¿Õ¼äʱ¿ÉÒÔÈç¹û²»ÏëʹÓÃĬÈϵÄÊý¾Ý¿é´óС£¬¿ÉÒÔͨ¹ýÉèÖÃ×Ô¼ºµÄÊý¾Ý¿é´óС¡£
¾ßÌåʵÀýÈçÏ£º
create tablespace test_16k
blocksize 16K
datafile 'd:\oradata\test_16k.dbf' size 100m reuse
extent management local
uniform size 1M
segment space management manual£»
ÁíÍ⣬±ØÐëΪÕâÀà±í¿Õ¼äµÄÊý¾Ý¿é½¨Á¢Êý¾Ý¸ßËÙ»º³åÇø£¬Ä¬ÈϵÄDB_CACHE_SIZEµÄ´óСֻΪĬÈϵÄÊý¾Ý¿é´óСµÄÊý¾Ý¸ßËÙ»º³åÇø£¬¿ÉÒÔͨ¹ý²ÎÊýDB_nK_CACHE_SIZEÉèÖÃÆäËû¿é´óСÊý¾Ý¸ßËÙ»º³åÇø£¬ÓÉÓÚ½¨Êý¾Ý¿âʱ´Ë²ÎÊýΪ0.
¿ÉÒÔͨ¹ýÐ޸ģº
alter system set db_16k_cache_size= 10M scope=spfile ;
Ϊ¸Ã±í¿Õ¼äµÄÊý¾ÝÉèÖÃÊý¾Ý¸ßËÙ»º³åÇø¡£
Ïà¹ØÎĵµ£º
mysql ´ó¶ÔÏó´æÈ¡:
ÀàÐÍÒ»°ãÓ¦¸ÃÓÃmediumblod,
blobÖ»ÄÜ´æ2µÄ16´Î·½¸öbyte,
mediumblodÊÇ24´Î·½,
Ò»°ãÀ´Ëµ¹»ÓÃÁË.longblobÊÇ32´Î·½ÓÐЩ´ó.
MYSQLĬÈÏÅäÖÃÖ»ÄÜ´æ1M´óСµÄÎļþ,ÒªÐÞ¸ÄÅäÖÃ,WIN°æ±¾µÄÔÚmysql.iniÎļþÖÐ
ÐÞ¸Ämax_allowed_packet,net_buffer_lengthµÈ¼¸¸ö²ÎÊý,»òÖ±½ÓSET GLOBAL varName=value.
linux°æ± ......
¸ù¾Ý±í½á¹¹Éú³ÉJavaÎļþµÄ¹¤¾ß£¬ÔÚÈ¡µÃ±íµÄ×Ö¶ÎʱÈçºÎÈ¡µÃ±íµÄ¸÷ÖÖÐÅÏ¢ºÍ×¢ÊÍ£¬¾¶à·½ËÑÑ°ÕÒµ½ÈçÏÂ×ÊÁϱ¸Ó㺠oracle£º
user_tab_comments;±í×¢ÊÍ
user_col_comments;±í×Ö¶Î×¢ÊÍ
Ò ......
´ò¿ªRman
·½·¨1£º¿ªÊ¼²Ëµ¥--ÔËÐÐ--“ÊäÈë”rman£¬»Ø³µ£¬´ò¿ªrmanÃüÁîÐÐÌáʾ´°¿Ú£¬ÊäÈ룺connect target;Á¬½ÓÉÏÊý¾Ý¿â£¬½ÓÏÂÀ´¾Í¿ÉÒÔ½øÐвÙ×÷ÁË¡£
·½·¨2£º¿ªÊ¼²Ëµ¥--ÔËÐÐ--“ÊäÈë” rman target username/userpwd@Orcl £¬£¨ºìÉ«×ÖÌå±íʾÊý¾Ý¿âʵÀýÃû£©»Ø³µ£¬´ò¿ªµÄrmanÃüÁîÐд°¿Ú£¬ÒѾÁ¬½ÓÉÏÊ ......
http://hi.baidu.com/wzbg/blog/item/005f9c098e31a12f6b60fbfb.html
Oracle±í½éÉÜ--Ë÷Òý×éÖ¯±í
2010-01-12 16:03
Ë÷Òý×éÖ¯±í(IOT)²»½ö¿ÉÒÔ´æ´¢Êý¾Ý£¬»¹¿ÉÒԴ洢Ϊ±í½¨Á¢µÄË÷Òý¡£Ë÷Òý×éÖ¯±íµÄÊý¾ÝÊǸù¾ÝÖ÷¼üÅÅÐòºóµÄ˳Ðò½øÐÐÅÅÁеģ¬ÕâÑù¾ÍÌá¸ßÁË·ÃÎʵÄËٶȡ£µ«ÊÇÕâÊÇÓÉÎþÉü²åÈëºÍ¸üÐÂÐÔÄÜΪ´ú¼ÛµÄ(ÿ´ÎдÈëºÍ¸üкó¶¼Òª ......
/*²»´øÈκβÎÊý´æ´¢¹ý³Ì(Êä³öϵͳÈÕÆÚ)*/
create or replace procedure output_date is
begin
dbms_output.put_line(sysdate);
end output_date;
/*´ø²ÎÊýinºÍoutµÄ´æ´¢¹ý³Ì*/
create or replace procedure get_username(v_id in number,v_username out varchar2)
as
begin
select username into v_usern ......