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

LinuxÏÂOracleµÄ°²×°Ïêϸ²½Öè

 
1.       ϵͳÅäÖùý³Ì
2.1. oracle°²×°Ìõ¼þ¼ì²é
2.1.1.               Ó²¼þ¼ì²é
¼ì²éÓ²¼þÇé¿öÊÇ·ñ·ûºÏoracle 10g µÄ°²×°ÒªÇó¡£ÒÔrootµÇ¼ϵͳ£¬ÓÃϱíÃüÁîÊä³öµÄÖµÓ¦´óÓÚ»òµÈÓÚ½¨ÒéÖµ¡£
¼ì²éÏîÄ¿
ÃüÁî/·½·¨
½¨ÒéÖµ
ÄÚ´æ
#grep MemTotal /proc/meminfo
1GB
½»»»·ÖÇø
#grep SwapTotal /proc/meminfo
1.5±¶ÄÚ´æ´óС
/tmpĿ¼¿ÕÏÐÇø
#df –k /tmp
400MB
Ó²ÅÌ¿ÕÏпռä
#df -k
4GB
 
 
 
 
 
 
2.1.2.               Èí¼þ¼ì²é
2.1.2.1.  ϵͳÈí¼þ°ü¼ì²é
¶ÔSUSE Linux Enterprise 10ÐèÒªÈçϵÄÈí¼þ°ü£º
binutils-2.15.90.0.1.1-32.5
gcc-3.3.3-43.24
gcc-c++-3.3.3-43.24
glibc-2.3.3-98.28
gnome-libs-1.4.1.7-671.1
libstdc++-3.3.3-43.24
libstdc++-devel-3.3.3-43.24
make-3.80-184.1
pdksh-5.2.14-780.1
sysstat-5.0.1-35.1
xscreensaver-4.16-2.6
libaio-0.3.105-2
Ò»°ãÇé¿öϳýÁË compatºÍlibaioµÄһЩ°üûÓа²×°Í⣬ÆäËûµÄ°ü¶¼ÒѾ­°²×°ÁË£¬¿ÉÒÔʹÓÃÕâ¸öÃüÁî½øÐвéѯ£»
¶ÔRedHatEL 5À´Ëµ£¬ÐèÒªÒÔϰü£¨°´Ë³Ðò°²×°£©£º
1.      Kernel-header-2.6.18-128.wl5.i386.rpm
2.      glibc-headers-2.5-34.i386.rpm
3.      glibc-devel-2.5-24.i386.rpm
4.      glibc-2.5-34.i386.rpm
5.      libaio-0.3.106-3.2.i386.rpm
6.      libgomp-4.3.2.7-7.el5.i386.rpm
7.      libxp-1.0.0-8.1.el5.i386.rpm
8.      openmotif-2.3.1-2.el5.i386.rpm
9.      compat-gcc-3.4.6-4.i386.rpm
10.  compat-gcc-34-c+-3.4.6-4.i386.rpm
11.  compat-libf2c-34-3.4.6-4.i386.rpm
12.  compat-gcc-34-g77-3.4.6-4.i386.rpm
13.  compat-libstdcff-33-3.3.3-6c.i386.rpm
14.  gcc-4.1.2-44.el5.i386.rpm
 
¼ì²éÒѰ²×°µÄ°ü  # rpm -q package_name
°²×°ËùÐè°ü(ÉϱíËùÁÐ)   &n


Ïà¹ØÎĵµ£º

ʵսLinux Bluetooth±à³Ì£¨Èý£© HCI²ã±à³Ì

1. HCI²ãЭÒé¸ÅÊö£º
HCIÌṩһÌ×ͳһµÄ·½·¨À´·ÃÎÊBluetoothµ×²ã¡£ÈçͼËùʾ£º
´ÓͼÉÏ¿ÉÒÔ¿´³ö£¬Host Controller Interface(HCI)  ¾ÍÊÇÓÃÀ´¹µÍ¨HostºÍModule¡£Hostͨ³£¾ÍÊÇPC£¬ ModuleÔòÊÇÒÔ¸÷ÖÖÎïÀíÁ¬½ÓÐÎʽ£¨USB,serial,pc-cardµÈ£©Á¬½Óµ½PCÉϵÄbluetooth Dongle¡£
ÔÚHostÕâÒ»¶Ë£ºapplication,SDP,L2capµÈЭÒé ......

oracle 8i,9iºÍ10g µÄÇø±ð

Oracle 9i±È8i¶àÁËÄÄЩÐÂÌØÐÔ£¿
 ¼òҪ˵£º
    9i¸üÒ×ÓÚ¹ÜÀí¡£
Ïêϸ˵£º
    ²¢·¢¼¯Èº£¬8i OPSÉý¼¶Îª9i RAC£¬8i½áµã¼äÓÃÓ²Å̽»»»ÐÅÏ¢£¬9i½áµã¼ä²ÉÓøßËÙÍøÏߵĻº´æÈÛºÏ(Cache Fusion)¼¼Êõ½»»»ÐÅÏ¢£¬½»»»ËÙ¶ÈÌá¸ß100±¶ÒÔÉÏ¡£
    9i¿ÉÒÔÔÚÏßÐÞ¸ÄÄں˲ÎÊýºÍÄÚ´æ·ÖÅä£ ......

Oracle µÄ Round º¯數(ËÄÉáÎåÈë)º¯Êý


 
¸Ãº¯ÊýÓÃÀ´·µ»ØÒ»¸öËÄÉáÎåÈëºóµÄÖµ
 
SELECT ROUND( number, [ decimalplaces ] ) from DUAL
 
參數:
±ØÌîÏnumber : Òª´¦ÀíµÄÊýÖµ(ÊýÖµ±í´ïʽ)
¿ÉÑ¡Ïdecimalplaces : ËÄÉáÎåÈëʱȡµÄСÊýµÄλÊý£¬²»ÌîÔò·µ»ØÕûÊý
 
Sample :
 
select round(123.456) from dual;& ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ