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,É÷ÓÃË÷Òý
Ïà¹ØÎĵµ£º
ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
Ê×ÏÈ£¬Ô ......
ºÙºÙ£¬Õ⻹ÊÇÉÏÕÂ֪ʶÁË£¬Ö»Êǵ¥Ò»Ð´³öÀ´±È½ÏºÃÒ»µã£¬ÒòΪÉÏÃæµÄÊǽϻù´¡µÄ£¬²»ÔõôÉæ¼°²Ù×÷£¬¶øÕâÀïÊÇͨ¹ý²Ù×÷³öÀ´µÄ£¬ºÇºÇ¡£
Ê×ÏÈ£¬´ò¿ªÊý¾Ý¿â·þÎñ£¬È»ºóͨ¹ý¿ØÖÆ̨´ò¿ªsqlplus£º
È»ºó½«Êý¾Ý¿âÉèÖÃΪֻ¶Á£ºalter database read only£»µ«ÊÇÄØ£¬ÕâÑùÊDz»Ä ......
1.¸ÅÊö
Ë÷ÒýÊÇÓ¦ÓÃÉè¼ÆºÍ¿ª·¢µÄÒ»¸öÖØÒª·½Ãæ¡£Èç¹ûÓÐÌ«¶àµÄË÷Òý£¬DML µÄÐÔÄܾͻáÊܵ½Ó°Ïì¡£Èç¹ûË÷ÒýÌ«
ÉÙ£¬ÓÖ»áÓ°Ïì²éѯ£¨°üÀ¨²åÈë¡¢¸üкÍɾ³ý£©µÄÐÔÄÜ¡£ÒªÕÒµ½Ò»¸öºÏÊʵÄƽºâµã£¬Õâ¶ÔÓÚÓ¦ÓõÄÐÔÄÜÖÁ¹Ø
ÖØÒª¡£
ÎÒ³£³£·¢ÏÖ£¬ÈËÃÇÔÚÓ¦Óÿª·¢ÖÐ×ÜÊÇʺó²ÅÏëÆðË÷Òý¡£ÎÒ¼á³ÖÈÏΪÕâÊÇÒ»ÖÖ´íÎóµÄ×ö·¨¡£Èç¹ûÄãÖª
µÀÊý¾Ý½«ÈçºÎ ......
ÔÎĵØÖ·£ºhttp://blog.csdn.net/fengyun14/archive/2007/03/25/1540433.aspx
¹ØÓÚLinux ÏÂkernel.shmmax µÄÉèÖÃÎÊÌâ
ÏÂÃæÊÇOracle ÎĵµÉϵĽâÊÍ£¬ http://download-west.oracle.com/doc...e.htm#sthref107
SHMMAX Available physical memory Defines the maximum allowable size of one shared memory segment.
The ......