oracleÈ«ÎÄË÷ÒýºÍ¶¨Ê±ÈÎÎñ
--Ê×Ïȼì²éÊý¾Ý¿âÖÐÊÇ·ñÓÐCTXSYSÓû§ºÍCTXAPP½ÅÉ«¡£
--Èç¹ûûÓÐÕâ¸öÓû§ºÍ½ÇÉ«£¬Òâζ×ÅÄãµÄÊý¾Ý¿â´´½¨Ê±Î´°²×°intermedia¹¦ÄÜ¡£
--Äã±ØÐëÐÞ¸ÄÊý¾Ý¿âÒÔ°²×°ÕâÏÄÜ¡£
--ÓÃsysÓû§ÎªÁËÓû§gzinfo·ÖÅäȨÏÞ
grant
CTXAPP
to
gzinfo;
grant
execute
on
ctx_ddl
to
gzinfo;
--»Øµ½gzinfoÓû§
--´´½¨²âÊÔ±í,CLOBTEXT×Ö¶ÎΪÐèÒªË÷ÒýµÄ×Ö¶Î
create
table
INXTEXT (ID
number
(
13
), CLOBTEXT CLOB);
--´´½¨·Ö´Ê,ÕâÀïÓÃÁËchinese_vgram_lexer,·Ö´ÊÃûΪGZINFO_LEXER
call ctx_ddl.create_preference (
'
GZINFO_LEXER
'
,
'
chinese_vgram_lexer
'
);
--´´½¨Ë÷Òý,Ë÷ÒýÃûΪINX_TEST (PARAMETERS ÖÐÐèÒªÒÔLEXER¿ªÍ·,Ìæ»»Ê±ÓÃreplace)
create
index
INX_TEST
ON
INXTEXT (CLOBTEXT) INDEXTYPE
IS
CTXSYS.CONTEXT PARAMETERS (
'
LEXER INFO_LEXER
'
);
--´´½¨¼Ç¼±í
create
table
JOBTEST (ID DATE, CONTENT
VARCHAR2
(
200
));
--´´½¨Í¬²½´æ´¢¹ý³Ì,ctx_ddl.sync_index('INX_TEST')Ϊͬ²½È«ÎÄË÷Òý,ͬ²½±í×Ö¶ÎÖеÄÐÅÏ¢
create
or
replace
procedure
PROC_SYNC_INDEX
is
begin
ctx_ddl.sync_index(
'
INX_TEST
'
);
insert
into
JOBTEST
values
(SYSDATE,
'
ͬ²½ÈÎÎñÓÚ
'
||
SYSDATE
||
'
Ö´ÐÐ
'
);
end
;
--´´½¨Í¬²½ÓÅ»¯´æ´¢¹ý³Ì,ctx_ddl.optimize_index('INX_TEST','FULL')ΪÓÅ»¯È«ÎÄË÷Òý
Code
create
or
replace
procedure
PROC_SYNC_OPTIMIZE
is
begin
ctx_ddl.sync_index(
'
INX_TEST
'
);
ctx_ddl.optimize_index(
'
INX_TEST
'
,
'
FULL
'
);
insert
into
JOBTEST
values
(SYSDATE,
'
ͬ²½ÓÅ»¯ÈÎÎñÓÚ
'
||
SYSDATE
||
'
Ö´ÐÐ
'
);
end
;
--´´½¨¶¨Ê±ÈÎÎñÒÔ±ãͬ²½È«ÎÄË÷Òý
DECLARE
X
NUMBER
;
BEGIN
SYS.DBMS_JOB.SUBMIT
(
job &n
Ïà¹ØÎĵµ£º
1.ÒÔsysÓû§µÇ¼oracle
2.²éÕÒÄãÒª¸ü¸ÄµÄ±í£¬ÎÒÃÇ“TEST”ÖеēAAA”±íΪÁУ¬×¢Ò⣬ÔÚoracleÖУ¬±íºÍ¿Õ¼ä¶¼ÊÇÒÔ´óд×ÖĸÏÔʾµÄ£¬ËùÒÔÕâÀï¶¼ÒªÓôó×Ö×Öĸ
Ö´ÐÐ
select object_id from all_objects where owner='TEST' and object_name='AAA';
»áµÃµ½Ò»¸öobject_id,Õâ¾ÍÊÇÎÒÃÇÐèÒª¸ü¸Ä±íµÄid£¬ÎÒÃÇÒ ......
ÎÊÌâÒ»£ºÈç±£¼ÓÔØJDBCÇý¶¯³ÌÐò£º
¡¡¡¡Õý³£ÎÒÃǼÓÔØÇý¶¯³ÌÐòÓÐÈý¸ö;¾¶£º
¡¡¡¡1£©Class.forName(String)ÕâÏëµ±ÓÚclassLoaderÒ»¸öStringÖ¸¶¨µÄÀ࣬ÔÚ×°ÔØÊ±°Ñ¸ÃÇý¶¯³ÌÐòµÄ¾²Ì¬ÄÚÈݶ¼³õʼ»¯£¬ÆäʵÕâʱÇý¶¯³ÌÐòÀàµ÷ÓÃÁËDriverManager.registerDriver(driver)·½·¨
¡¡¡¡2£©Ê¹ÓÃϵͳÊôÐÔ£ºSystem.getProperty().load(new Fil ......
Õâ¸öÎÊÌâÒÔǰÀ§ÈŹýÎÒ£¬Á½Õߺó׺Ãû¶¼ÊÇ.DBF¡£¼ÇµÃµ±Ê±ºÃÏñÈ¥ÂÛ̳ÉÏ·¢Á˸öÌû×ÓÎÊ£¬²»¹ýºÃ¼¸ÌìûÈ˽â´ð£¬ÎÞÄÎÖ®ÏÂÎҾͰÑÌû×Ó¸ø½áÁË¡£
½ñÌìÕýºÃÔÚÒ»±¾ÊéÖп´µ½Óн²Á½ÕßÇø±ðµÄ£¬ÓÖÈ¥ÍøÉÏËÑÁËËÑ£¬Ð¡×ܽáһϣ¬¼ÇÏÂÀ´¡£
±¾µØ¹ÜÀíµÄÁÙʱ±í¿Õ¼äÊÇ»ùÓÚÁÙʱÎļþµÄ£¬ÕâЩÎļþÓëÆÕͨµÄÊý¾ÝÎļþ·Ç³£ÏàËÆ£¬µ«ËüÃÇ»¹¾ßÓÐÈçÏÂÌØÐÔ£º
ÁÙʱ ......
ÔÚJAVAÖеÄSQL Óï¾äµÄ±àд·½Ã棬ûÓÐʹÓÃORACLE °ó¶¨±äÁ¿£¬ºÜ´ó³Ì¶ÈÉϽµµÍÁËÊý¾Ý¿âµÄÐÔÄÜ£¬±íÏÖÔÚÁ½¸ö·½Ã棺
1¡¢SQLÓï¾äÓ²·ÖÎö(Hard Parse)Ì«¶à£¬ÑÏÖØÏûºÄCPU×ÊÔ´£¬ÑÓ³¤ÁËSQLÓï¾ä×ܵÄÖ´ÐÐʱ¼ä
SQLÓï¾äµÄÖ´Ðйý³Ì·Ö¼¸¸ö²½Ö裺Óï·¨¼ì²é¡¢·ÖÎö¡¢Ö´ÐС¢·µ»Ø½á¹û¡£ÆäÖзÖÎöÓÖ·ÖΪӲ·ÖÎö(Hard Parse)ºÍÈí·ÖÎö(Soft Pars ......
Ëæ×Ų»Í¬Ó¦ÓÃÄ£¿é¼äµÄÏûÏ¢½»»¥ºÍͨÐųÉΪһ¸ö¹Ø¼üµÄ¹¦ÄÜ£¬²¢ÇÒ±äµÃÔ½À´Ô½ÖØÒª¡£OracleÒýÈëÁËÒ»ÖÖÇ¿´óµÄ¶ÓÁлúÖÆ£¬Í¨¹ýËü³ÌÐò¼ä¿ÉÒÔʵÏÖÐÅÏ¢µÄ½»»¥£¬oracle°ÑËü³Æ×÷ΪAQ - Advanced Queuing. ʹÓÃOracle AQ£¬ÎÒÃDz»ÐèÒª°²×°¶îÍâµÄÖмä¼þ£¬ËüÊÇOracleÊý¾Ý¿âµÄÒ»¸ö¹¦ÄÜ×é¼þ£¬Ö»ÒªÄã°²×°ÁËOracle Êý¾Ý¿â¾Í¿ÉÒÔʹÓÃAQÁË¡£½ ......