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

ORACLE µÄ²¹¶¡ÏÂÔØµØÖ· (ת)

oracle²¹¶¡ÏÂÔØ
¹Ø¼ü×Ö: oracle
9.2.0.4  = 3095277
9.2.0.5  = 3501955
9.2.0.6  = 3948480
9.2.0.7  = 4163445
9.2.0.8  = 4547809£¨9i×îÖÕ£©
10.1.0.3 = 3761843
10.1.0.4 = 4163362
10.1.0.5 = 4505133
10.2.0.2 = 4547817
10.2.0.3 = 5337014
10.2.0.4 = 6810189
ÏÂÔØ²¹¶¡Ê±£¬¿É½øÈëcmd£¬Ê¹ÓÃftpÃüÁîÖ±½ÓµÇÂ¼ÍøÕ¾ÏÂÔØ¡£Ïàͬ°æ±¾£¬Õë¶Ô²»Í¬µÄ²Ù×÷ϵͳ£¬»áÓв»
ͬµÄ²¹¶¡¡£Ã¿¸ö²¹¶¡´óСԼÔÚ500MB~1.3GBÖ®¼ä¡£ÏÂÃæÒÔoracle 10.2.0.2 ²¹¶¡ÎªÀý£º
ftp updates.oracle.com
user metalib_user ÊäÈëÃÜÂë
cd 4547817
dir
p4547817_10202_AIX64-5L.zip
p4547817_10202_HP64.zip
p4547817_10202_HPUX-IA64.zip
p4547817_10202_LINUX.zip
p4547817_10202_Linux-IA64.zip
p4547817_10202_Linux-x86-64.zip
p4547817_10202_MVS.zip
p4547817_10202_SOLARIS.zip
p4547817_10202_SOLARIS64.zip
p4547817_10202_WINNT.zip
p4547817_10202_WINNT64.zip
ʹÓÃmgetÃüÁîÏÂÔØ¼´¿É¡£
½áºÏѸÀ×,¿ÉÒÔÈ¡µÃʰ빦±¶µÄЧ¹û,Á´½ÓÈçÏ£º
oracle 9206 patchset:
ftp://updates.oracle.com/3948480/p3948480_9206_AIX64-5L.zip
ftp://updates.oracle.com/3948480/p3948480_9206_HP64.zip
ftp://updates.oracle.com/3948480/p3948480_9206_HPUX-IA64.zip
ftp://updates.oracle.com/3948480/p3948480_9206_LINUX.zip
ftp://updates.oracle.com/3948480/p3948480_9206_Linux-x86-64.zip
ftp://updates.oracle.com/3948480/p3948480_9206_MVS.zip
ftp://updates.oracle.com/3948480/p3948480_9206_SOLARIS.zip
ftp://updates.oracle.com/3948480/p3948480_9206_SOLARIS64.zip
ftp://updates.oracle.com/3948480/p3948480_9206_TRU64.zip
ftp://updates.oracle.com/3948480/p3948480_9206_WINNT.zip
ftp://updates.oracle.com/3948480/p3948480_9206_WINNT64.zip
oracle 9207patch set:
ftp://updates.oracle.com/4163445/p4163445_92070_AIX64-5L.zip
ftp://updates.oracle.com/4163445/p4163445_92070_HP64.zip
ftp://updates.oracle.com/4163445/p4163445_92070_HPUX-IA64.zip
ftp://updates.oracle.com/4163445/p4163445_92070_LINUX.zip
ftp://updates.oracle.com/4163445/p4163445_92070_Linux-IA64.zip
ftp://updates.oracle.com/4163445/p4163445_


Ïà¹ØÎĵµ£º

Oracle Data blocks £¬Extents£¬Segment

£¨Ò»£©Data blocks £¬Extents£¬Segment
    Õâ¾ÍÊÇËûÃÇÖ®¼äµÄÂß¼­½á¹¹¡£
    ÏÈ¿´Data blocks£¨Ò²½ÐÂß¼­¿é£¬oracle¿é£¬Ò³£©°É£¬oracle´æ´¢Êý¾Ý¶¼ÊÇÔÚÕâЩÊý¾Ý¿éÖУ¬Ò»¸öÊý¾Ý¿éÊÇ´ÅÅÌÉÏÊý¾Ý¿âÎïÀí¿Õ¼äһϵÁÐÎïÀí×Ö½ÚµÄ×é³É¡£
    ±ÈData blocks¸ü¸ßÒ»²ãµÄÂß¼­Êý¾Ý¿é¿Õ¼äÊÇe ......

Êý¾Ý¿âtimestenÓë oracle ´¦ÀíÈÕÆÚÉÏд·¨ÉϵIJ»Í¬

     ÓÉÓÚ¹«Ë¾ÒµÎñÔö³¤½Ï¿ì£¬Êý¾Ý¿âoracleѹÁ¦Ô½À´Ô½´ó£¬¹«Ë¾¿¼ÂÇÔÚÓ¦Ó÷þÎñÆ÷ Websphere ºÍ Êý¾Ý¿âoracleÖ®¼äÔö¼Ó timestenÊý¾Ý¿âÀ´ÊµÏÖÊý¾ÝµÄ¶Áд·ÖÀ룬ÁíÍâÓÉÓÚtimestenÊÇÄÚ´æÊý¾Ý¿â£¬ËùÒÔ²éѯËÙ¶ÈÉÏÒªÓÅÓÚ oracle Êý¾Ý¿â£¬Á½¸öÊý¾Ý¿âËäÈ»¶¼ÊÇoracle¹«Ë¾µÄ²úÆ·£¬µ«ÊÇÔںܶàsqlµÄд·¨ÉÏÊDz»ÏàͬµÄ£¬Ï ......

ÐÞ¸ÄOracle×î´óÁ¬½ÓÊý

1¡¢ÐÞ¸ÄOracle×î´óÁ¬½ÓÊýµÄ·½·¨
  
   a¡¢ÒÔsysdbaÉí·ÝµÇ½PL/SQL »òÕß Worksheet
   b¡¢²éѯĿǰÁ¬½ÓÊý
      show parameter processes;
   c¡¢¸ü¸ÄϵͳÁ¬½ÓÊý
      alter system set processes=1000 scope=spfile; ......

ARCSDE for Oracle Êý¾Ý´æ´¢ÐÎʽΪst_geometry

SELECT sde.st_area(zone) from sde.test1 ORDER BY name;//
SELECT shape from schools ORDER BY name;
SELECT objectid, sde.st_astext(SDE.ST_POINTfromSHAPE(shape,0)) AS points from schools;
SELECT name, sde.st_x (zone) "The X coordinate" from test ; //ÕýÈ·Ö´ÐÐ
SELECT name, sde.st_x (shape)  "The ......

OracleÖг£Óõĺ¯Êý

  ---sqlµÄº¯ÊýµÄʹÓÃ(Oracle)      
      ---dualµÄʹÓãºÑÆÔª±í£ºÃ»ÓбíÐèÒª²éѯµÄʱºò ¿ÉÒÔÓÃËü
               ---select 'Hello World' from dual;     ---½á¹û£ºH ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ