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

Oracle ·ÖÒ³´æ´¢¹ý³Ì ¼¸Ê®ÍòÌõ¼Ç¼

ºÃ³¤Ê±¼äûд¶«¶«ÁË£¬½ñÌìдÁËÒ»¸öoracleµÄ·ÖÒ³´æ´¢¹ý³Ì£¬Ìù³öÀ´Óë´ó¼Ò·ÖÏí¡£
ÓÉÓÚ¡£net¿ò¼ÜÖеÄgridviewµÈ¿Ø¼þµÄ·ÖÒ³¹¦ÄÜÌ«Èõ£¬ËùÒԴ󲿷ֳÌÐòÔ±¶¼»á×Ô¼ºÐ´·ÖÒ³¹¦ÄÜ£¬¶øµ÷Ó÷ÖÒ³´æ´¢¹ý³ÌÊDZØÐëµÄ¡£
ǰ̨aspxÒ³Ãæ²»¹ÜÊÇÓÃÏÂÔØµÄdll»¹ÊÇÓÃ×Ô¼ºÐ´µÄÓû§¿Ø¼þ£¬¶¼ÄÜʵÏÖ×Ô¼ºµÄ¹¦ÄÜ£¬È»¶ø·ÖÒ³µÄ´æ´¢¹ý³Ì¾ÍÐèÒªºÃºÃµÄ¿¼ÂÇÁË£¬Ï±ßÊÇÎÒдµÄoracleµÄ´æ´¢¹ý³Ì£¨²Î¿¼sql serverÊý¾Ý¿âµÄ´æ´¢¹ý³Ìд³ÉµÄ£©£¬Ð§ÂÊ»¹¿ÉÒÔ£¬²¢¸½Éϵ÷ÊԵĹý³Ì£¨µ÷ÊÔ»·¾³£ºwin2003¡¢oracle 9i£¬µ÷ÊÔ¹¤¾ß£ºpl/sql£©£º
--I/OÏûºÄ1071
select id,orgid,dj_date,khid,khcode,khname,feeid from fee_ysfy;
--493408
select count(id) from fee_ysfy;
--22.391Ö´ÐÐÍê³É£¨ÄÚÍâ¶¼ÓÐorder by£©
select id, orgid, dj_date, khid, khcode, khname, feeid
  from (select rownum rn, t.id, orgid, dj_date, khid, khcode, khname, feeid
          from fee_ysfy t
         where 1 = 1
         order by id desc)
 where rn <= 45
   and rn >= 30
 order by id desc
 --22.437£¨Ö»ÓÐ×Ó²éѯÓÐorder by£©
 select id, orgid, dj_date, khid, khcode, khname, feeid
  from (select rownum rn, t.id, orgid, dj_date, khid, khcode, khname, feeid
          from fee_ysfy t
         where 1 = 1
         order by id desc)
 where rn <= 45
   and rn >= 30
--ÓÅ»¯È¥µôorder by0.891£¨È¥µôËùÓеÄorder by£©
select id, orgid, dj_date, khid, khcode, khname, feeid
  from (select rownum rn, t.id, orgid, dj_date, khid, khcode, khname, feeid
          from fee_ysfy t
         where 1 = 1
         )
 where rn <= 45
   and rn >= 30
--½«order by·Åµ½Íâ±ß0.828Ã루°Ñorder by·Åµ½Íâ±ß£©
select id, orgid, dj_date, khid, khcode, khname, fee


Ïà¹ØÎĵµ£º

Red Hat Cluster Suite¼¯Èº OracleÊý¾Ý¿â


Ŀ¼
Ò»¡¢¸ÅÊö
¶þ¡¢Ó²¼þƽ̨´î½¨
Èý¡¢Redhat As4 update2°²×°ÅäÖÃ
ËÄ¡¢Oracle 10g°²×°ÅäÖÃ
Îå¡¢Red Hat Cluster Suite°²×°ÅäÖÃ
Áù¡¢ÏµÍ³Çл»²âÊÔ
Æß¡¢³£ÓÃÃüÁî
Ò»¡¢¸ÅÊö
»ÆµºÊпª·¢Çø²ÆÕþ¾Ö±¾´Î²ÉÓÃÁ½Ì¨IBM X3850£­8664·þÎñ
Æ÷¡¢
һ̨DS4300ÅÌÕ󣬯½Ì¨²ÉÓÃRedhat As4 update2 ½áºÏcluster suite£¬²¿ÊðOracle ......

ORACLEÊý¾Ý¿âÃüÃû¹æ·¶

1 Ä¿µÄ
¹æ·¶Êý¾Ý¿â¸÷ÖÖ¶ÔÏóµÄÃüÃû¹æÔò¡£
2 Êý¾Ý¿âÃüÃûÔ­Ôò
2.1 Êý¾ÝÎļþ
Èç¹ûÊý¾Ý¿â²ÉÓÃÎļþϵͳ£¬¶ø²»ÊÇÂãÉ豸£¬Ô¼¶¨ÏÂÁÐÃüÃû¹æÔò£º
1)Êý¾ÝÎļþÒÔ±í¿Õ¼äÃûΪ¿ªÊ¼£¬ÒÔ.dbfΪ½áβ£¬È«²¿²ÉÓÃСдӢÎÄ×Öĸ¼ÓÊý×ÖÃüÃû¡£Èç¸Ã±í¿Õ¼äÓжà¸öÊý¾ÝÎļþ£¬Ôò´ÓµÚ2¸öÊý¾ÝÎļþ¿ªÊ¼£¬ÔÚ±í¿Õ¼äÃûºó¼Ó_¡£
Àý£º¶Ôsystem±í¿Õ¼äµÄÊý ......

oracleÆô¶¯·ÖÎö

oracleÆô¶¯·½Ê½ÓëÃüÁî²ÎÊý»ã×Ü
±¾ÎÄÖ÷ÒªÊǶÔoracleµÄÆô¶¯·½Ê½ºÍÏà¹ØµÄÃüÁî²ÎÊý½øÐÐÒ»¸ö»ã×Ü£¬ÓÃÒÔ¼ÓÉîÓ¡Ïó¡£
OracleµÄÆô¶¯·½Ê½£º
startup nomount
startup mount
startup open (startupµÄĬÈÏÑ¡Ïî)
ÆäËû³£ÓõIJÎÊý£ºread only ,read write ,force,restrict
ÕâЩ²ÎÊý¿ÉÒÔÒ»ÆðʹÓÃ,±ÈÈç startup Óë startup open read ......

Oracle ±íµÄÒÆ¶¯ºÍË÷ÒýµÄÖØ½¨

ÔµÆðÒ»¸ö±í¿Õ¼äÌ«´ó,ɾ³ýÊý¾ÝºóÓÉÓÚÎļþβ±»ÓÃ,ÎÞ·¨resize,´òËã°ÑËùÓбí¿Õ¼äÉϵĶÔÏómoveµ½Ò»¸öÁÙʱ´æ´¢µÄ±í¿Õ¼ä×öÕûÀí¡£
moveÒ»¸ö±íµ½ÁíÍâÒ»¸ö±í¿Õ¼äʱ,Ë÷Òý²»»á¸ú×ÅÒ»Æðmove£¬¶øÇÒ»áʧЧ¡££¨LOBÀàÐÍÀýÍ⣩±ímove£¬ÎÒÃÇ·ÖΪ£º
*ÆÕͨ±ímove
*·ÖÇø±ímove
*LONG,LOB´ó×Ö¶ÎÀàÐÍmoveÀ´½øÐвâÊÔºÍ˵Ã÷¡£
Ë÷ÒýµÄmove£¬ÎÒÃÇÍ ......

Oracle 10gÖиúEMÓйصÄÎÊÌâ½â¾ö·½·¨

Oracle 10gÖеÄEM²ÉÓÃWebµÄÐÎʽÀ´¹ÜÀíÊý¾Ý¿â¼°Ïà¹Ø·þÎñ£¬µ«Ê¹Óùý³ÌÖлáÅöµ½Ò»Ð©¸úEMÓйصÄÎÊÌ⣬¸ù¾ÝͬÐеÄÌáʾ¼°±ÊÕßµÄʵ¼Ê¾­Ñ飬½øÐÐÁËһЩ¹éÄÉ£¬Ï£Íû¶ÔÏà¹Ø°®ºÃÕßÓÐËù°ïÖú£º
£¨1£©Êý¾Ý¿â¿ØÖÆÌ¨Æô¶¯ºó£¬¿´µ½1£©Êý¾Ý¿âʵÀýÎÞÐÅÏ¢2£©¼àÌý³ÌÐòΪ״̬Ϊ²»¿ÉÓÃ3£©µ½ÊµÀýµÄ´úÀíÁ¬½Ó״̬Ϊ²»¿ÉÓá£
ÎÊÌâ·ÖÎö£º
´Ëʱ·þÎñ¸ÕÆô ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ