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

oracleÖÐʹÓú¯ÊýË÷ÒýFBI

×÷Õß:ÂÞ´ú¾ù http://hi.baidu.com/luodaijun/
ʹÓûùÓÚº¯ÊýµÄË÷Òý(FBI)ʱ£¬ÐèÒªÏÈÉèÖóõʼ»¯²ÎÊýquery_rewrite_enabled=TRUE(ĬÈÏΪfalse)
¸Ã²ÎÊýÔÚinit.oraÀïÉèÖã¬ÒÔoracle 9i2ΪÀý£¬init.oraÎļþ·¾¶ÎªD:\oracle\admin\mydb\pfile,ÎÒÕâÀï°Ñoracle×°ÔÚDÅÌ£¬mydbÊÇÎÒµÄÊý¾Ý¿â.
--˳±ã˵˵£¬´´½¨º¯ÊýË÷ÒýµÄ·½·¨
Óбíemployee,°üº¬3¸ö×Ö¶Î id, op-date, qty    , ÕâÀïÎÒÃÇÐèÒª»ã×Üop_dateÿ¸öÔµÄÊý¾Ý
select to-char(op_date,'YYYY-MM') mon,sum(qty)
from employee
group by to-char(op_date,'YYYY-MM')
ÓÉÓÚÔÚop_dateÉÏʹÓÃÁËto_charº¯Êý£¬ËùÒÔ²»ÄÜʹÓÃË÷Òý
ÏÂÃæ´´½¨FBI»ùÓÚº¯ÊýµÄË÷Òý
create index idx_employee_opdate on employee(to_char(op_date,'YYYY-MM'))
ok,ÏÖÔھͿÉÒÔʹÓÃË÷Òý
˳±ã˵¾ä£¬Ê¹ÓÃË÷Òý£¬ÔںܶàÇé¿öϲ»ÊDzéѯÊý¾Ý×î¿ìµÄ·½·¨£¬
Ë÷Òý²éÕÒ£¬Ã¿´Î¶ÁÒ»¸öÊý¾Ý¿é£¬¶øÈ«±íɨÃ裬ÿ´Î¶Á¶à¸öÊý¾Ý¿é£¬ÕâÑù¿ÉÒÔ¼õÉÙ´ÅÅÌi/o
ÏàÐÅCBO,É÷ÓÃË÷Òý


Ïà¹ØÎĵµ£º

oracle¸´Ï°£¨¶þ£© Ö®À©Õ¹ ÉèÖÃÊý¾Ý¿âΪֻ¶Á

      ºÙºÙ£¬Õ⻹ÊÇÉÏÕÂ֪ʶÁË£¬Ö»Êǵ¥Ò»Ð´³öÀ´±È½ÏºÃÒ»µã£¬ÒòΪÉÏÃæµÄÊǽϻù´¡µÄ£¬²»ÔõÃ´Éæ¼°²Ù×÷£¬¶øÕâÀïÊÇͨ¹ý²Ù×÷³öÀ´µÄ£¬ºÇºÇ¡£
      Ê×ÏÈ£¬´ò¿ªÊý¾Ý¿â·þÎñ£¬È»ºóͨ¹ý¿ØÖÆÌ¨´ò¿ªsqlplus£º
È»ºó½«Êý¾Ý¿âÉèÖÃΪֻ¶Á£ºalter database read only£»µ«ÊÇÄØ£¬ÕâÑùÊDz»Ä ......

ORACLE Ò»Ö¶Á(Consistent Read)µÄ²½Öè

1. Read the Data Block.
2. Read the Row Header.
3. Check the Lock Byte to determine whether there's an ITL entry.
4. Read the ITL entry to determine the Transaction ID (Xid).
5. Read the Transaction Table using the Transaction ID. If the transaction has been committed and has a System Commit ......

LinuxϵÄOracle 10g°²×°¼°ÅäÖÃ

Ò».×ÊÔ´ÐèÒª£º
ÖÁÉÙ1024 MBÎïÀíÄÚ´æ
1024£­2048 Ðè1.5±¶µÄ½»»¥¿Õ¼ä
2048£­8192 Ðè1±¶µÄ½»»¥¿Õ¼ä
8192£­ Ðè0.75±¶µÄ½»»¥¿Õ¼ä
ÖÁÉÙ400 MB /tmp ÁÙʱĿ¼¿Õ¼ä
oracleÈí¼þÐèÒª1.5 GB µ½ 3.5 GB ´ÅÅ̿ռä
ĬÈÏÊý¾Ý¿âÐèÒª1.2 GB
¶þ.²é¿´ÏµÍ³×ÊÔ´Ïà¹ØÓï ......

oracleÅж϶ÔÏóÊÇ·ñ´æÔÚ

declare    
    v_isexist number(3,0):=0;  
begin  
    select count(1) into v_isexist from sys.all_objects where owner = 'TEST' and object_type = 'TABLE' and object_name = 'TAB1';
    if  v_isexist>0 ......

OracleÊý¾Ý¿â»¹Õæ²»ºÃÕû

´ÓÔÚLinuxÉϰ²×°Oracleµ½Í¶ÈëʹÓòż¸Ì죬Åöµ½µÄÎÊÌâ¾Í³É°ÙÉÏǧµÄ¡£ÔÚʹÓÿͻ§¶ËÁ¬½ÓÔ¶³ÌOracleÊý¾Ý¿â·þÎñÆ÷ʱ£¬³öÏÖÁËlistener refused the connection with the following error ora-12519 Listener refused the connection with the following error:ORA-12519, TNS:no appropriate service handler foundThe Connection ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ