oracleÈ«ÎÄË÷ÒýÖ®datastore
Oracle Text¹¦ÄÜÊ®·ÖÇ¿´ó£¬¿ªÊ¼Ñ§Ï°£¬Ö÷Òª²Î¿¼
yangtingkun
µÄblogºÍÎĵµ½øÐС£
µÚÒ»²½ÏȸãÇå³þdatastoreµÄÀàÐÍ¡£
DATASTOREµÄÀàÐÍÈçÏ£º
DIRECT_DATASTORE
MULTI_COLUMN_DATASTORE
DETAIL_DATASTORE
FILE_DATASTORE
NESTED_DATASTORE
URL_DATASTORE
USER_DATASTORE
ÏÂÃæ¾Í¸÷ÖÖÀàÐͽøÐвâÊÔ£¬DIRECT_DATASTOREÊÇ×î¼òµ¥µÄ£¬Ä¬ÈÏÊǾÍÊÇÓÃÕâÖÖÀàÐÍ
OracleµÄÈ«ÎÄË÷Òý²»ÒªÇó±»Ë÷ÒýµÄÎÄÕÂÒ»¶¨´æ´¢ÔÚÊý¾Ý¿âÖУ¬²»¹ýÈç¹ûÎÄÕ´洢ÔÚÊý¾Ý¿âµÄÒ»ÁÐÖУ¬ÄÇôÕâÖÖÇé
¿ö½¨Á¢Ë÷ÒýÊÇ×î¼òµ¥µÄ¡£
SQL> CREATE TABLE T (ID NUMBER, DOCS VARCHAR2(4000));
±íÒÑ´´½¨¡£
SQL> INSERT INTO T VALUES (1, 'This is a sample for Oracle TEXT.');
ÒÑ´´½¨ 1 ÐС£
SQL> INSERT INTO T VALUES (2, 'This is a direct database store sample');
ÒÑ´´½¨ 1 ÐС£
SQL> COMMIT;
Ìá½»Íê³É¡£
¶ÔÓÚÉÏÃæÌáµ½µÄDIRECT DATASTOREÀàÐÍ£¬ÏÂÃæÈýÖÖ´´½¨Ë÷Òý·½Ê½Êǵȼ۵ģº
SQL> CREATE INDEX IND_T_DOCS ON T (DOCS) INDEXTYPE IS CTXSYS.CONTEXT;
Ë÷ÒýÒÑ´´½¨¡£
SQL> SELECT * from T WHERE CONTAINS(DOCS, 'DATABASE') > 0;
ID DOCS
---------- ----------------------------------------
2 This is a direct database store sample
SQL> DROP INDEX IND_T_DOCS;
Ë÷ÒýÒѶªÆú¡£
SQL> CREATE INDEX IND_T_DOCS ON T (DOCS) INDEXTYPE IS CTXSYS.CONTEXT
2 PARAMETERS ('DATASTORE CTXSYS.DEFAULT_DATASTORE');
Ë÷ÒýÒÑ´´½¨¡£
SQL> SELECT * from T WHERE CONTAINS(DOCS, 'DATABASE') > 0;
ID DOCS
---------- ----------------------------------------
2 This is a direct database store sample
SQL> DROP INDEX IND_T_DOCS;
Ë÷ÒýÒѶªÆú¡£
SQL> CREATE INDEX IND_T_DOCS ON T (DOCS) INDEXTYPE IS CTXSYS.CONTEXT
2 PARAMETERS ('DATASTORE CTXSYS.DIRECT_DATASTORE');
Ë÷ÒýÒÑ´´½¨¡£
SQL> SELECT * from T WHERE CONTAINS(DOCS, 'DATABASE') > 0;
ID DOCS
---------- ----------------------------------------
2 This is a direct database store sample
ÉÏÃæ¸ø³öÁËÒ»¸ö×î¼òµ¥µÄÈ«ÎÄË÷ÒýµÄÀý×Ó¡£
ÁíÍ⣬ÓÉDR$¿ªÍ·µÄ4ÕűíÊÇϵͳΪÁËÖ§³ÖÈ«ÎÄË÷Òý¶ø×Ô¶¯Éú³ÉµÄ£¬²»¹ýÕâ4ÕűíµÄÓô¦¾Í²»ÔÙÕâÀïÌÖÂÛÁË¡£
SQL> SELECT * from TAB;
TNAME TABTYPE CLUSTERID
------------------------------ -------
Ïà¹ØÎĵµ£º
extent--×îС¿Õ¼ä·ÖÅ䵥λ --tablespace management
block --×îСi/oµ¥Î» --segment management
create tablespace james
datafile '/export/home/oracle/oradata/james.dbf'
size 100M ¡¡¡¡¡¡¡¡¡¡¡¡--³õʼµÄÎļþ´óС¡¡
autoextend On¡¡¡¡¡¡¡¡ --×Ô¶¯Ôö³¤
next 10M¡ ......
¹ØÓÚlatchºÍmutexµÄÎÊÌâ
from:http://www.itpub.net/thread-1004815-1-1.html
A:
latchÊÇãÅËø£¬ÊÇÒ»ÖÖ´®Ðл¯»úÖÆ£¬ÓÃÀ´±£»¤SGAÖеÄÄÚ´æ½á¹¹¡£
mutexÊÇʲô£¬Ò²ÊÇÒ»ÖÖ´®Ðл¯»úÖÆ£¬ÊÇ»¥³âËø£¿
¸öÈ˶ÔmutexûÓÐʲô¸ÅÄî¡£Õâ¸öÊÇ10GÐÂÒý½øµÄ£¿9IºÃÏñûÓа¡¡£
ÄÄλÃ÷°×ÈË£¬¸ø°ïæÏêϸ½âÊÍÏÂmutex£¬×îºÃ»¹ÄܺÍlatch ×öϱȽ ......
http://hi.baidu.com/james_yulei/blog/item/7cc8c834063d6f3a0b55a920.html
OracleÊý¾Ý¿âRMANµÄ×Ô¶¯±¸·Ý½Å±¾
2009-12-21 18:04
OracleÊý¾Ý¿âRMANµÄ×Ô¶¯±¸·Ý½Å±¾
²Ù×÷ϵͳ£ºLinux
Êý¾Ý¿â£ºoracle9.2.0.4
1¡¢Êý¾Ý¿âÉèÖÃΪ¹éµµ·½Ê½
2¡¢Êý¾Ý¿âµÄ±¸·Ý½Å±¾
db_full_backup.sh £ºÊý¾Ý¿âÈ«±¸½Å±¾
db_l0_backup.sh £ºÊý¾Ý¿ ......
µÚÒ»²¿·Ö »ù±¾¸ÅÄî
Ò»¡¢ ......
SQL> create table test2(s1 varchar(10),s2 varchar2(10));
±íÒÑ´´½¨¡£
SQL> insert into test2 values('11','111');
ÒÑ´´½¨ 1 ÐС£
SQL> insert into test2 values('22','222');
ÒÑ´´½¨ 1 ÐС£
SQL> CREATE OR REPLACE PACKAGE test222 AS
2 TYPE t_cursor IS REF CURSOR;
3 procedure p_tes ......