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

ORACLEÖÐÁÙʱÎļþºÍÊý¾ÝÎļþµÄÇø±ð

Õâ¸öÎÊÌâÒÔÇ°À§ÈŹýÎÒ£¬Á½Õߺó׺Ãû¶¼ÊÇ.DBF¡£¼ÇµÃµ±Ê±ºÃÏñÈ¥ÂÛ̳ÉÏ·¢Á˸öÌû×ÓÎÊ£¬²»¹ýºÃ¼¸ÌìûÈ˽â´ð£¬ÎÞÄÎÖ®ÏÂÎҾͰÑÌû×Ó¸ø½áÁË¡£
½ñÌìÕýºÃÔÚÒ»±¾ÊéÖп´µ½Óн²Á½ÕßÇø±ðµÄ£¬ÓÖÈ¥ÍøÉÏËÑÁËËÑ£¬Ð¡×ܽáһϣ¬¼ÇÏÂÀ´¡£
±¾µØ¹ÜÀíµÄÁÙʱ±í¿Õ¼äÊÇ»ùÓÚÁÙʱÎļþµÄ£¬ÕâЩÎļþÓëÆÕͨµÄÊý¾ÝÎļþ·Ç³£ÏàËÆ£¬µ«ËüÃÇ»¹¾ßÓÐÈçÏÂÌØÐÔ£º
ÁÙʱÊý¾ÝÎļþµÄ״̬²»ÄÜÖÃΪֻ¶Á
²»Äܽ«ÁÙʱÊý¾ÝÎļþÖØÐÂÃüÃû
ÁÙʱÊý¾ÝÎļþ×ÜÊÇÖÃΪNOLOGGING״̬
²»ÄÜʹÓÃALTER DATABASEÃüÁî´´½¨ÁÙʱÊý¾ÝÎļþ
ÒÔÖ»¶Á·½Ê½ÔËÐеÄÊý¾Ý¿âÐèÒªÁÙʱÊý¾ÝÎļþ
½éÖʻָ´ÊDz»Äָܻ´ÁÙʱÊý¾ÝÎļþµÄ


Ïà¹ØÎĵµ£º

jdbcÁ¬½ÓOracle

      ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
    ½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
    ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
    Ê×ÏÈ£¬Ô ......

oracle±í·ÖÎöʾÀý

drop table test;
select count(*) from test;
--´´½¨²âÊÔ±í
create table test
(
id number(9),
nick varchar2(30)
);
--²åÈë²âÊÔÊý¾Ý
begin
  for i in 1..100000 loop
        insert into test(id) values(i);
  end loop;
  commit;
end;
select * ......

Oracle PGA²ÎÊý

Oracle PGA²ÎÊý
PGA: ³ÌÐòÈ«¾ÖÇø£¬·þÎñÆ÷½ø³ÌʹÓõÄÄÚ´æÇøÓò£¬°üÀ¨Ìض¨·þÎñÆ÷½ø³ÌµÄÊý¾ÝºÍ¿ØÖÆÐÅÏ¢£¬ÀýÈçʹÓõIJÙ×÷ϵͳ×ÊÔ´µÈ¡£
UGA: Óû§È«¾ÖÇø£¬Ìض¨SessionʹÓõÄÄÚ´æÇøÓò£¬ÀýÈçSessionµÄSQL¹¤×÷Çø¡¢µÇ½ÈÏÖ¤ÐÅÏ¢µÈ¡£SessionµÄSQL¹¤×÷Çø´óС¶Ô²éѯÐÔÄܵÄÓ°Ïì±È½Ï¹Ø¼ü£¬shared serverģʽʱUGA´ÓSGAµÄlarge pool£¨Èç¹ ......

Oracle Êý¾Ý¿â°²È«»ù´¡ÖªÊ¶

Ëæ׿ÆËã»úµÄÆÕ¼°ÒÔ¼°ÍøÂçµÄ·¢Õ¹£¬Êý¾Ý¿âÒѾ­²»ÔÙ½ö½öÊÇÄÇЩ³ÌÐòÔ±ËùרÓеĻ°Ìâ¡£¶øOracleÊý¾Ý¿â¸üÊÇƾ½èÆäÐÔÄÜ׿Խ£¬²Ù×÷·½±ãÁé»îµÄÌص㣬ÔÚÊý¾Ý¿âµÄÊг¡ÖÐÒѾ­Õ¼¾ÝÁËһϯ֮µØ¡£µ«ÊÇͬÑùËæ×ÅÍøÂç¼¼ÊõµÄ²»¶Ï½ø²½£¬Êý¾ÝÐÅÏ¢µÄ²»¶ÏÔö¼Ó£¬Êý¾Ý°²È«ÒѾ­²»ÔÙÊÇÒÔÇ°µÄ“ÀÏÉú³¤Ì¸”£¬Ò²¸ü²»ÊÇÒÔÇ°Êé±¾ÉÏÄÇЩ“¿ÉÍû² ......

ÔÚoracleÖиıä×Ö¶ÎÔÚ±íÖеÄ˳Ðò

1.ÒÔsysÓû§µÇ¼oracle
2.²éÕÒÄãÒª¸ü¸ÄµÄ±í£¬ÎÒÃÇ“TEST”ÖеēAAA”±íΪÁУ¬×¢Ò⣬ÔÚoracleÖУ¬±íºÍ¿Õ¼ä¶¼ÊÇÒÔ´óд×ÖĸÏÔʾµÄ£¬ËùÒÔÕâÀﶼҪÓôó×Ö×Öĸ
Ö´ÐÐ
select object_id from all_objects where owner='TEST' and object_name='AAA';
»áµÃµ½Ò»¸öobject_id,Õâ¾ÍÊÇÎÒÃÇÐèÒª¸ü¸Ä±íµÄid£¬ÎÒÃÇÒ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ