Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ORACLE ROWID

Ò».rowid¼ò½é
rowid¾ÍÊÇΨһ±êÖ¾¼Ç¼ÎïÀíλÖõÄÒ»¸öid£¬ÔÚoracle 8°æ±¾ÒÔǰ£¬rowidÓÉfile#+block#+row#×é³É£¬Õ¼ÓÃ6¸öbytesµÄ¿Õ¼ä£¬10 bit µÄ file# £¬22bit µÄ block# £¬16 bit µÄ row#¡£
´Óoracle 8¿ªÊ¼rowid±ä³ÉÁËextend rowid£¬ÓÉdata_object_id#+rfile#+block#+row#×é³É£¬Õ¼ÓÃ10¸öbytesµÄ¿Õ¼ä£¬ 32bitµÄ data_object_id#,10 bit µÄ rfile#,22bit µÄ block#,16 bit µÄ row#.ÓÉÓÚrowidµÄ×é³É´Ófile#±ä³ÉÁËrfile#£¬ËùÒÔÊý¾ÝÎļþÊýµÄÏÞÖÆÒ²´ÓÕû¸ö¿â²»Äܳ¬¹ý1023¸ö±ä³ÉÁËÿ¸ö±í¿Õ¼ä²»Äܳ¬¹ý1023¸ö Êý¾ÝÎļþ¡£
˵ÁËrowidµÄ×é³É£¬ÄÇôÎÒÃÇÔÙÀ´¿´¿´rowidÔÚË÷ÒýÀïÃæÕ¼ÓõÄ×Ö½ÚÊýÓÖÊÇʲôÑù×ӵġ£ÔÚoracle 8ÒÔǰË÷ÒýÖд洢µÄrowidÕ¼ÓÃ×Ö½ÚÊýÒ²ÊÇ6bytes,ÔÚoracle8Ö®ºó£¬ËäÈ»oracleʹÓÃÁËextend rowid£¬µ«ÊÇÔÚÆÕͨË÷ÒýÀïÃæÒÀÈ»´æ´¢ÁËbytesµÄrowid£¬Ö»ÓÐÔÚglobal indexÖд洢µÄÊÇ10bytesµÄextend rowid£¬¶øextend rowidÒ²ÊÇglobal index³öÏÖµÄÒ»¸ö±ØÒªÌõ¼þ£¬ÏÂÃæÎÒÃÇ»á½âÊÍÔ­Òò¡£
Ϊʲôgolbal indexÐèÒª°Ñdata_object_id#Ò²°üº¬ÔÚindex rowid entryÖÐÄØ£¿Èç¹û²»°üº¬»áÕâôÑù£¿Ê×ÏÈÎÒÃÇÐèÒªÖªµÀindexµÄrowid entryµÄ´æÔÚÊÇΪÁËÄܸù¾ÝËüÕÒµ½±íµÄÕâÌõ¼Ç¼´æÔÚÄĸö¾ßÌåµÄÎïÀíλÖã¬ÎÒÃÇÐèÒªÖªµÀËüÔÚÄĸöÊý¾ÝÎļþ£¬ÔÚÄĸöblock£¬ÔÚÄÇÒ»ÐУ¬ÆÕͨµÄË÷Òý oracle¸ù¾Ýrfile#,block#,row#¾Í¿ÉÒÔÖªµÀÁË£¬µ«ÊÇpartition table¿ÉÒÔ·Ö²¼ÔÚ¶à¸ö±í¿Õ¼ä£¬Ò²¾ÍÊÇ¿ÉÒÔ·Ö²¼ÔÚ¶à¸öÊý¾ÝÎļþ£¬µ±ÎÒÃǽ¨Á¢local indexʱ£¬index rowid entry²¢²»°üº¬data_object_id#£¬ÒòΪoracle¿ÉÒÔÖªµÀÕâ¸öindex¶ÔÓ¦µÄÊÇÄÄÒ»¸ötable·ÖÇø£¬²¢¿ÉÒԵõ½table·ÖÇøµÄ ts#(tablespaceºÅ)£¬ÄÇôoracle¸ù¾Ýts#ºÍrfile#¾Í¿ÉÒÔÕÒµ½¾ßÌåµÄÊý¾ÝÎļþ¡£µ«ÊÇÈç¹û»»³ÉÊÇgolbal index£¬Èç¹û²»°üº¬data_object_id#£¬ÄÇôÎÒÃDz¢²»ÄÜÖªµÀÕâ¸öË÷Òý¶ÔÓ¦×ÅÄĸö±í·ÖÇø£¬Ò²×ÔÈ»²»ÄÜÖªµÀËüµÄrfile#ºÍfile#µÄת »»¹ØÏµ£¬ËùÒÔËü½«ÕÒ²»µ½Ëù¶ÔÓ¦µÄ¼Ç¼¡£°üº¬data_object_id#ºó,oracle¿ÉÒÔ¸ù¾Ýdata_object_id#ʵÏÖrfile#ºÍ file#µÄת»»È»ºóÕÒµ½¼Ç¼¶ÔÓ¦µÄÎïÀíλÖá£ÐèҪעÒâµÄÊÇÒªÀí½âÒÔÉϸÅÄîÎÒÃÇ»¹ÊÇÐèÒªÁ˽âfile#ºÍrfile#µÄÇø±ð¡£
¶þ.±È½Ïfile#ºÍrfile#
oracleÊý¾ÝÎļþΪʲô´æÔÚfile#ºÍrfile#?
¹é¸ù½áµ×µÄÔ­ÒòÊÇÒòΪ ROWID µÄ´æ´¢¸ñʽÔì³ÉµÄ£¬ÒòΪ rowid ÖÐÎļþ±àºÅ±êÖ¾Ö»ÓÐ10bit,×î´óÊý¾ÝÈÝÁ¿1024£¬ÓÉÓÚ²»´æÔÚ0±àºÅÎļþ£¬ËùÒÔʵ¼ÊÉÏÖ»ÔÊÐí1023¸öÎļþ±àºÅ¡£ÔÚoracle8 ֮ǰµÄ°æ±¾µÄÊý¾Ý¿âÖУ¬rowidÊÇÊÜÏ޵ģ¬Ö»°üÀ¨ file# /bl


Ïà¹ØÎĵµ£º

Oracle ÐÞ¸ÄÊý¾ÝÎļþµÄ·¾¶ºÍÃû³Æ

Microsoft Windows XP [°æ±¾ 5.1.2600]
(C) °æÈ¨ËùÓÐ 1985-2001 Microsoft Corp.
C:\Documents and Settings\Admin>sqlplus "/ as sysdba"
SQL*Plus: Release 10.2.0.1.0 - Production on Fri Nov 20 19:31:44 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g E ......

Oracle °²×°ÏµÁÐ ¾²Ä¬´´½¨Êý¾Ý¿â

ÉÏÆª½éÉÜÁ˾²Ä¬°²×°Êý¾Ý¿âÈí¼þ£¬ÏÂÃæ½éÉܾ²Ä¬´´½¨Êý¾Ý¿âµÄ·½·¨¡£
1. ÓÃDBCA¸ù¾ÝÖÖ×ÓÊý¾Ý¿â´´½¨Ò»¸öÄ£°å
£¨ÖÖ×ÓÊý¾Ý¿â¾ÍÊÇÔ´Êý¾Ý¿â£¬Èç¹ûûÓÐÔ´Êý¾Ý¿â£¬¿ÉÒÔÓÃDBCA´´½¨Ò»¸öеÄÄ£°æ»ò±à¼­Ô­ÓеÄÄ£°æ£©
2. ½«Oracle DB°²×°ÅÌÀïÃæresponseĿ¼ÏµÄdbca.rsp¿½±´µ½±¾»úÉÏ
3. ÐÞ¸Ädbca.rspÎļþ£¬½«Ä£°åÃûºÍDBÃûÌí¼Ó½øÈ¥
GDB ......

Oracle AQ ʹÓÃ

 Ëæ×Ų»Í¬Ó¦ÓÃÄ£¿é¼äµÄÏûÏ¢½»»¥ºÍͨÐųÉΪһ¸ö¹Ø¼üµÄ¹¦ÄÜ£¬²¢ÇÒ±äµÃÔ½À´Ô½ÖØÒª¡£OracleÒýÈëÁËÒ»ÖÖÇ¿´óµÄ¶ÓÁлúÖÆ£¬Í¨¹ýËü³ÌÐò¼ä¿ÉÒÔʵÏÖÐÅÏ¢µÄ½»»¥£¬oracle°ÑËü³Æ×÷ΪAQ - Advanced Queuing. ʹÓÃOracle AQ£¬ÎÒÃDz»ÐèÒª°²×°¶îÍâµÄÖмä¼þ£¬ËüÊÇOracleÊý¾Ý¿âµÄÒ»¸ö¹¦ÄÜ×é¼þ£¬Ö»ÒªÄã°²×°ÁËOracle Êý¾Ý¿â¾Í¿ÉÒÔʹÓÃAQÁË¡£½ ......

oracleÈ«ÎÄË÷ÒýºÍ¶¨Ê±ÈÎÎñ

--Ê×Ïȼì²éÊý¾Ý¿âÖÐÊÇ·ñÓÐCTXSYSÓû§ºÍCTXAPP½ÅÉ«¡£
--Èç¹ûûÓÐÕâ¸öÓû§ºÍ½ÇÉ«£¬Òâζ×ÅÄãµÄÊý¾Ý¿â´´½¨Ê±Î´°²×°intermedia¹¦ÄÜ¡£
--Äã±ØÐëÐÞ¸ÄÊý¾Ý¿âÒÔ°²×°ÕâÏÄÜ¡£
--ÓÃsysÓû§ÎªÁËÓû§gzinfo·ÖÅäȨÏÞ
grant
 CTXAPP 
to
 gzinfo;
grant
 
execute
 
on
 ctx_ddl 
to
......

oracle ÈÕÆÚº¯Êý

sqlÓï¾äÈçÏÂ:
select * from userdb40.numservice  where ServiceNumber =88880068
 and applytime <= to_date('2009-12-26 10:41:44','yyyy-MM-dd HH24:mi:ss')
select to_date('2007-06-28 19:51:20.0','yyyy-MM-dd HH24:mi:ss') from dual; ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ