Oracle10g r1ÔÚLINUX OS4Éϵݲװ
°²×°oralce10g R1(10.1)²½Öè·½·¨£º
µÚÒ»²¿·Ö£º
Ò». Ó²¼þ»·¾³£º
1. RAM£ºÖÁÉÙ512M
2. ½»»»·ÖÇø´óСÖÁÉÙ1G£¨»òÕßÊÇÄÚÔÚµÄ2±¶£©
3./tmpĿ¼ ÖÁÉÙÓÐ400M¿ÕÏпռä
4. oracleÈí¼þ°²×°¿Õ¼äÖÁÉÙÔÚ1.5G--3GÖ®¼ä£¨ÒÀ¾Ý°²×°oracleÀàÐͶø¶¨£©
5. 1.2GµÄ´ÅÅ̿ռ䣨ԤÖÃÊý¾Ý¿â¿Õ¼ä´óС£¬Îļþϵͳ´æ´¢£©
6. ÆäËü¿ÕÏдÅÅ̿ռ䡣
¶þ¡¢¼ì²éÄÚ´æ´óС
AIX # /usr/sbin/lsattr -E -l sys0 -a realmem
HP-UX # grep "Physical:" /var/adm/syslog/syslog.log
Linux # grep MemTotal /proc/meminfo
Solaris # /usr/sbin/prtconf | grep "Memory size"
Tru64 UNIX # /bin/vmstat -P | grep "Total Physical Memory"
Èý¡¢¼ì²éswap´óС
AIX # /usr/sbin/lsps -a
HP-UX # /usr/sbin/swapinfo -a
Linux # grep SwapTotal /proc/meminfo
Solaris # /usr/sbin/swap -s
Tru64 UNIX # /sbin/swapon -s
ËÄ¡¢²é¿´/tmp´óС
¡ö HP-UX:
# bdf /tmp
¡ö Other operating systems:
# df -k /tmp
Îå¡¢¼ì²éϵͳ¿ÕÏдÅÅÌ¿Õ¼ä
# df -k
ƽ̨ °²×° ÀàÐÍ Ðè´ÅÅÌ¿Õ¼ä´óС£¨G£©
AIX Enterprise Edition 3
Standard Edition 3
Custom (maximum) 3
HP-UX &
Ïà¹ØÎĵµ£º
ÀýÒ»£º·¢ËÍSignaling Packet£º
Signaling CommandÊÇ2¸öBluetoothʵÌåÖ®¼äµÄL2CAP²ãÃüÁî´«Êä¡£ËùÒÔµÃSignaling CommandʹÓÃCID 0x0001.
¶à¸öCommand¿ÉÒÔÔÚÒ»¸öC-frame£¨control frame£©Öз¢ËÍ¡£
Èç¹ûÒªÖ±½Ó·¢ËÍSignaling Command.ÐèÒª½¨Á¢SOCK_RAWÀàÐ͵ÄL2CAPÁ¬½ÓSocket¡£ÕâÑù²ÅÓлú»á×Ô¼ºÌî³äCommand Code£¬Identi ......
ORACLE´¥·¢LGWRÈÕ־д½ø³ÌµÄÌõ¼þ
µ±Ä³¸öÊÂÎñÌύʱ
µ±ÖØ×öÈÕÖ¾»º³åÇøÖб仯µÄ¼Ç¼³¬¹ý1MBʱ
µ±ÖØ×öÈÕÖ¾»º³åÇøÖÐËù´æµÄ¼Ç¼Òѳ¬¹ý»º³åÇøÈÝÁ¿µÄ1/3
ÔÚDBWR½«Êý¾Ý¿â¸ßËÙ»º³åÇøÖÐÐ޸ĹýµÄÊý¾Ý¿éдµ½Êý¾ÝÎļþ֮ǰ
ÿ3ÃëÖÓ
......
ORACLE´¥·¢CHECKPOINTµÄÌõ¼þ
1.µ±·¢ÉúÈÕÖ¾×éÇл»µÄʱºò
2.µ±·ûºÏLOG_CHECKPOINT_TIMEOUT£¬LOG_CHECKPOINT_INTERVAL£¬fast_start_io_target,fast_start_mttr_target²ÎÊýÉèÖõÄʱºò
3.µ±ÔËÐÐALTER SYSTEM SWITCH LOGFILEµÄʱºò
4.µ±ÔËÐÐALTER SYSTEM CHECKPOINTµÄʱºò
5.µ±ÔËÐÐalter tablespace XXX begin backup£¬e ......
Oracle 9i±È8i¶àÁËÄÄЩÐÂÌØÐÔ£¿
¼òҪ˵£º
9i¸üÒ×ÓÚ¹ÜÀí¡£
Ïêϸ˵£º
²¢·¢¼¯Èº£¬8i OPSÉý¼¶Îª9i RAC£¬8i½áµã¼äÓÃÓ²Å̽»»»ÐÅÏ¢£¬9i½áµã¼ä²ÉÓøßËÙÍøÏߵĻº´æÈÛºÏ(Cache Fusion)¼¼Êõ½»»»ÐÅÏ¢£¬½»»»ËÙ¶ÈÌá¸ß100±¶ÒÔÉÏ¡£
9i¿ÉÒÔÔÚÏßÐÞ¸ÄÄں˲ÎÊýºÍÄÚ´ ......
»¥³âÁ¿´Ó±¾ÖÊÉÏ˵¾ÍÊÇÒ»°ÑËø, Ìṩ¶Ô¹²Ïí×ÊÔ´µÄ±£»¤·ÃÎÊ.
1. ³õʼ»¯:
ÔÚLinuxÏÂ, Ï̵߳Ļ¥³âÁ¿Êý¾ÝÀàÐÍÊÇpthread_mutex_t. ÔÚʹÓÃÇ°, Òª¶ÔËü½øÐгõʼ»¯:
¶ÔÓÚ¾²Ì¬·ÖÅäµÄ»¥³âÁ¿, ¿ÉÒÔ°ÑËüÉèÖÃΪPTHREAD_MUTEX_INITIALIZER, »òÕßµ÷ÓÃpthread_mutex_init.
¶ÔÓÚ¶¯Ì¬·ÖÅäµÄ»¥³âÁ¿, ÔÚÉêÇëÄÚ´æ(malloc)Ö® ......