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

·ÃÎÊOracleµÄÎÊÌâ

ÔÚSolarisÉϰ²×°ÁËOracle£¬ÆäËûµÄÓû§ÈçºÎ·ÃÎÊ£¿
¸øÊý¾Ý¿â·þÎñÃûºÍIPµØÖ·/¶Ë¿Ú£¬ÒÔ¼°¿ÉÒԵǽµÄÓû§ÃûºÍÃÜÂë
°²×°¿Í»§¶ËÅäÖÃÄãµÄTNSΪ·þÎñÆ÷ÉϵľͿÉÒÔ·ÃÎÊÁË

Óû§Oracle°²×°ÍêOracleÊý¾Ý¿â£¬¿ÉÒÔÕý³£·ÃÎÊ
н¨Ò»¸öÓû§£¬ÈçºÎ·ÃÎÊ

ÔÚ¿Í»§¶Ë»úÆ÷Éϰ²×°¿Í»§¶Ë£¬ÅäÖÃÁ¬½ÓÎļþta.ora,¾Í¿ÉÒÔÁ¬½Óoracle!

½¨ÒéÂ¥Ö÷»¹ÊÇÏÈ¿´¿´oracle ¿ª·¢ÕßÖ¸Äϰɡ£http://tahiti.oracle.com

ÔÚwindowsÉÏÎÒ»áÁ¬½ÓÊý¾Ý¿â
ÎÒÒªÎʵÄÊÇÔÚSolarisÉϲ»ÓÃÇл»µ½Óû§Oracle£¬ÆäËûÓû§¿ÉÒÔʹÓÃsqlplusÁ¬½Óµ½Êý¾Ý¿â

ûÓùý£¬°ï¶¥£¬²»¶ÌÁË

ÒýÓÃ
½¨ÒéÂ¥Ö÷»¹ÊÇÏÈ¿´¿´oracle ¿ª·¢ÕßÖ¸Äϰɡ£http://tahiti.oracle.com


Ç¿ÁÒ½¨Òé


Ô­À´»¹¿ÉÒÔÕâÑùµÄ,ѧϰÁË!


Ïà¹ØÎÊ´ð£º

Çë½ÌsqlÓï¾ä¡£ - Oracle / ¿ª·¢

ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
  ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......

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

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

OracleµÄblob×Ö¶ÎÎÊÌâ - Oracle / ¿ª·¢

²éÁËÒ»ÌìµÄblob£¬»¹ÊÇûÀí½âµ½£¬ÎÒÏëÔÚVCÏ´æÈ¡¶þ½øÖƵÄÎļþ£¬Ê¹ÓõÄÊÇoo4o£¬ÕÕ×ŰïÖúÎĵµÉÏÃæµÄдÁËдÈëÊý¾Ý¿âµÄ´úÂ룬»¹ÊÇûд¶Ô£¬´íÎóÌáʾÊÇthis operation is not permitted on a empty LOB£¬ÕâÊÇʲôÒâ˼°¡£¿ÕÕ ......

sqlÓÅ»¯ - Oracle / »ù´¡ºÍ¹ÜÀí

select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001' 
ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......

Çë½Ì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ºÅ