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

Çë½Ì¹ØÓÚoracleË÷ÒýµÄ¼¸¸öÎÊÌâ

ÎÒÏÖÔÚÓõÄÊÇoracle 9i
1.Ò»¸ö±í½¨Á¢¶àÉÙ¸öË÷Òý±È½ÏºÏÊÊ£¿±ÈÈç˵²»´óÓÚ5¸ö 
2.ÁªºÏË÷Òý±Èµ¥Ë÷ÒýµÄЧÂʸßô£¿
3.compress Õâ¸öѹËõ £¬ÄÜÆðµ½Ê²Ã´×÷Óã¿
4.ÉÏÍøÉϲé×ÊÁÏʱ£¬¶¼ËµoracleʹÓÃÁªºÏË÷ÒýÐèҪǰµ¼ÁУ¬Õâ¸öºÍ°æ±¾ÓйØÏµÂð£¿
5.Èç¹û²»ÐèҪǰµ¼Áеϰ£¬reverse Õâ¸ö·´×ª ÓÖÆðµ½Ê²Ã´×÷ÓÃÄØ£¿

ÎÒ×Ô¼ºÓÃÒ»¸öµ¥±í¶ÔË÷Òý½øÐÐÁËÒ»¸ö¼òµ¥µÄ²âÊÔ£¬½á¹ûÈçÏ£º
1¡¢¶à¸öµ¥Ë÷Òý Ò»ÆðʹÓÃ
»á·Ö±ðµ÷Óø÷×ÔµÄË÷Òý

2¡¢µ¥Ë÷ÒýºÍÎÞË÷Òý×ֶΠ
»áʹÓõ¥Ë÷Òý

3¡¢ÁªºÏË÷ÒýºÍÎÞË÷Òý×Ö¶Î £¨²»³öÏÖµ¥Ë÷Òý×ֶΣ©
»áʹÓÃÁªºÏË÷Òý £¨ÁªºÏË÷Òý×Ö¶Î ²»ÓÃÇ¿µ÷˳Ðò £¬Ò²¾ÍÊDz»ÐèҪǰµ¼ÁУ¬ÎÞË÷Òý×ֶλ¹¿ÉÒÔÔÚÁªºÏË÷Òý×Ö¶ÎÖ®¼ä£©

4¡¢µ¥Ë÷ÒýºÍÁªºÏË÷ÒýÒ»ÆðʹÓÃ
  1£©Èç¹ûÁªºÏË÷ÒýÖÐ×Ö¶ÎÈ«²¿³öÏÖ ÔòʹÓÃÁªºÏË÷Òý £¨ÁªºÏË÷Òý×Ö¶Î ²»ÓÃÇ¿µ÷˳Ðò£©
  2£©Èç¹ûÁªºÏË÷ÒýÖÐÖ»Óв¿·Ö×ֶγöÏÖ Ôò»áʹÓõ¥Ë÷Òý 

5¡¢ÁªºÏË÷ÒýºÍÁªºÏË÷ÒýÒ»ÆðʹÓÃ
1£©Èç¹ûÆäÖÐÒ»¸öÁªºÏË÷ÒýÖÐÖ»Óв¿·Ö×ֶγöÏÖ Ôò»áʹÓÃÁíÒ»¸öÁªºÏË÷Òý
2£©Èç¹ûÁ½¸ö¶¼ÍêȫʹÓ㬻ò¶¼²»ÍêȫʹÓà »áÑ¡ÔñÆäÖÐÒ»¸öʹÓ㨲»³öÏÖµ¥Ë÷Òý×ֶΣ¬Èç¹û³öÏÖ£¬»áʹÓü䵥Ë÷Òý£©£¬ ¾ßÌåÔõôѡÔñµÄ£¬²»Çå³þ£¿£¿£¿£¿

˵µÄ²»×¨Òµ ´ó¼Ò´ÕºÏ¿´£¬ Ï£ÍûÖ¸µãСµÜһϡ£ ÏÈллÀ²¡£
ÎÞÈËÎʽòѽ¡£ ×Ô¼º¶¥Ò»Ï¡£

¸øLZ¶¥ÆðÀ´ÏÈ£¬Ï£ÍûÄãµÄÎÊÌâÄܱ»½â¾ö

ßÀ¡£¡£ ÈËÆø²»ºÃѽ¡£
ÐÖµÜÃǸ÷Ê㼺¼ûѽ¡£


ÒýÓÃ
ÎÒÏÖÔÚÓõÄÊÇoracle 9i
1.Ò»¸ö±í½¨Á¢¶àÉÙ¸öË÷Òý±È½ÏºÏÊÊ£¿±ÈÈç˵²»´óÓÚ5¸ö 
    Õâ¸öûÓж¨ÂÛ£


Ïà¹ØÎÊ´ð£º

oracle 10g webµÇ½EMµÄÎÊÌ⣿ - Oracle / »ù´¡ºÍ¹ÜÀí

°²×°ÁËOracle 10g£¬Ä¬Èϰ²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿

1
¿ÉÒÔɾ³ý
2
ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......

javaÔõôÁ¬½ÓOracle£¬¼±°¡ - Java / JavaÏà¹Ø

private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......

Windows 7 ÔõÑù°²×°Oracle - Oracle / »ù´¡ºÍ¹ÜÀí

¸÷λ´ó¸ç£¬°ï¸öæ¡£

ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ 
http://www.oracle.com/technology/software/products/database/index.html 
------------------------------------------- ......

oracleÓëaix - Oracle / ¸ß¼¶¼¼Êõ

ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó
#topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬
Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7 
Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼­¾íºÅlv04 
#lslv -l lv04 ......

Çë½ÌOracleÊÂÎñ¸ôÀë¼¶±ðÎÊÌâ - Oracle / ·Ç¼¼ÊõÇø

²é¿´ÊÂÎñ¸ôÀë¼¶±ðµÄÃüÁ
MySQLʹÓõÄÊÇselect @@tx_isolation;
ÔÚOracleÖв鿴ÊÂÎñ¸ôÀë¼¶±ðµÄÃüÁîÊÇÄĸö£¿

SQL code:

SELECT /*+ rule */ s.username,decode(l.type,'TM','TABLE LOCK','TX','ROW LOCK', ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ