Oracle±í¿Õ¼ä¹ÜÀí
extent--×îС¿Õ¼ä·ÖÅ䵥λ --tablespace management
block --×îСi/oµ¥Î» --segment management
create tablespace james
datafile '/export/home/oracle/oradata/james.dbf'
size 100M ¡¡¡¡¡¡¡¡¡¡¡¡--³õʼµÄÎļþ´óС¡¡
autoextend On¡¡¡¡¡¡¡¡ --×Ô¶¯Ôö³¤
next 10M¡¡¡¡¡¡¡¡¡¡ --ÿ´Î×Ô¶¯Ôö³¤´óС¡¡
maxsize 2048M¡¡¡¡ ¡¡ --×î´óÎļþ´óС
extent management local --±í¿Õ¼ä²ÉÓñ¾µØ±í¿Õ¼ä¹ÜÀí
uniform size 128k¡¡¡¡¡¡ --uniformÉèÖÃextentÿ´Î·ÖÅäµÄ´óСͳһΪ128k(Èç¹ûÊÇdb_block_size=8k
,Ôòÿ´Î·ÖÅä16¸ö¿é)¡¡
¡¡¡¡¡¡¡¡ --Èç¹û²»Ö¸¶¨´óС£¬ÔòΪ1M£¬¼´Îª1024/8¸öblock
¡¡¡¡¡¡¡¡--autoallocateÉèÖÃextent´óСÓÉϵͳ×Ô¶¯·ÖÅä
¡¡¡¡¡¡¡¡ --²»¹Üϵͳ´óС·ÖÅäΪ¶àÉÙ£¬µ«Í³Ò»³ß´çÊÇ64k£¨ÔÚbitmapÖбê¼ÇλµÄ´óС£©¡£
¡¡¡¡¡¡¡¡ --autoallocateÔÚdba_extentsÖеÄallocation_typeÖÐÏÔʾΪ SYSRTEM
segment space management auto;
--segmentÖеÄblock¹ÜÀíÓÐÁ½ÖÖ£ºMSSM(Manual Segment Space Management)£¬
ASSM(Auto Systemt Space Management)
--Auto ģʽʱֻÓÐpctfree²ÎÊýÆð×÷ÓÃ
--Manual ģʽʱfreelist,pctfree,pctused²ÎÊýÆð×÷Óá£
Tablespace ¹ÜÀí·½Ê½ÓÐÁ½ÖÖ£º£¨¹ÜÀíextent)
1 Êý¾Ý×Öµä¿Õ¼ä¹ÜÀí dictionary managed tablespace
ͨ¹ý¹ÜÀíÁ½¸öÖ÷ÒªµÄÊý¾Ý×Öµä±í£¬UET$(Used EXtends) ºÍFET$(Free EXtends
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
protected void BindData1()
{
OracleConnection orcn = new OracleConnection("User ID=wesoftwcp; Password=wesoft; Data Source=oradb");
orcn.Open();
&nb ......
ORACLE±¸·Ý²ßÂÔ(ORACLE BACKUP STRATEGY)
2007Äê11ÔÂ02ÈÕ ÐÇÆÚÎå 16:03
¸ÅÒª
1¡¢Á˽âʲôÊDZ¸·Ý
2¡¢Á˽ⱸ·ÝµÄÖØÒªÐÔ
3¡¢Àí½âÊý¾Ý¿âµÄÁ½ÖÖÔËÐз½Ê½
4¡¢Àí½â²»Í¬µÄ±¸·Ý·½Ê½¼°ÆäÇø±ð
5¡¢Á˽âÕýÈ·µÄ±¸·Ý²ßÂÔ¼°ÆäºÃ´¦
Ò»¡¢Á˽ⱸ·ÝµÄÖØÒªÐÔ
¿ÉÒÔ˵£¬´Ó¼ÆËã»úϵͳ³öÊÀµÄÄÇÌìÆ𣬾ÍÓÐÁ˱¸·ÝÕâ¸ö¸ÅÄ ......
´¥·¢Æ÷¿ª·¢µÄÄ¿µÄ£ºÈ·±£Êý¾Ý¿âÂú×ãÌض¨µÄÉÌÒµ¹æÔòºÍÆóÒµÂß¼£¬¿ÉÒÔʹÓô¥·¢Æ÷£¬Ô¼Êø£¬×Ó³ÌÐò¡£ÒòΪ
Ô¼Êø×î¼òµ¥ÇÒÐÔÄܺã¬ËùÑ¡Ô¼Êø£¬Èç¹ûÔ¼Êø²»ÄÜÂú×㣬¾ÍÓô¥·¢Æ÷£¬Èô´¥·¢Æ÷¶¼²»ÄÜÂú×ãÑ¡Ôñ×Ó³ÌÐò¡£
Ò»¡¢´¥·¢Æ÷¹¦ÄÜ£º
1£¬¿ØÖÆÊý¾Ý°²È«,ÔÚ·þÎñÆ÷¼¶±ð¿ØÖÆÊý¾Ý ......