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

Oracle IO ²âÊÔ¹¤¾ßORION

Ò»Ö±ÏëѧϰÈçºÎµÃµ½Êý¾Ý¿âµÄIOÊý¾Ý£¬ORIONÊÇÒ»¸ö²»´íµÄ·ÂÕæ²âÊÔOracle IOµÄ¹¤¾ß¡£
ÏÂÃæÊÇÎҵIJâÊԵIJ½Ö裺
1 ´ÓoracleµÄÍøÕ¾ÉÏÏÂÔØORIONµÄÈí¼þ£¨11.1.0.7£©
2 ½âѹorion_linux_x86-64.gz
3 ½¨Á¢²ÎÊýÎļþ mytest.lun£¬ ÕâÀïµÄÁгöµÄÊÇ·ÖÇøÉ豸£¬ÎÒÔÚÉÏÃæ½¨Á¢ÁËasmÎļþϵͳ¡£ÒòΪÓÐÊý¾ÝÔÚÀïÃæ£¬ËùÒÔÎÒÓÃwrite=0Ö»²âÊÔ¶ÁµÄIOs
/dev/sda5
/dev/sdb1
/dev/sdc1
/dev/sdd1
4. ÔËÐÐÃüÁî
./orion_linux_x86-64 -run simple -testname mytest -num_disks 4
5 Éú³É±¨¸æÎļþ£º mytest_20100426_1608_summary.txt
ORION VERSION 11.1.0.7.0
Commandline:
-run simple -testname mytest -num_disks 4
This maps to this test:
Test: mytest
Small IO size: 8 KB
Large IO size: 1024 KB
IO Types: Small Random IOs, Large Random IOs
Simulated Array Type: CONCAT
Write: 0%
Cache Size: Not Entered
Duration for each Data Point: 60 seconds
Small Columns:,      0
Large Columns:,      0,      1,      2,      3,      4,      5,      6,      7,
     8
Total Data Points: 29
Name: /dev/sda5 Size: 102404703744
Name: /dev/sdb1 Size: 102404703744
Name: /dev/sdc1 Size: 102404703744
Name: /dev/sdd1 Size: 102404703744
4 FILEs found.
Maximum Large MBPS=62.98 @ Small=0 and Large=7
Maximum Small IOPS=648 @ Small=20 and Large=0
Minimum Small Latency=7.35 @ Small=1 and Large=0
6 ¿ÉÒÔ¿´µ½×î´óµÄIOPSÊÇ648£¬Ã¿¸ödisk´ó¸Å162£¬×î´óµÄMBPSÊÇ62M¡£


Ïà¹ØÎĵµ£º

¹ØÓÚÔÚoracle ½âËø³öÏÖµÄһЩÎÊÌâ¡£

    ÔÚѧϰoracleµÄʱºòÓöµ½ÁËÒ»¸öÎÊÌ⣬µ±ÎҵǼscottÓû§µÄʱºòÔõô¾ÍÊÇÁ´½Ó²»ÉÏ£¬³öÏÖÁËÒÔÏ´íÎóÌáʾ£¬the account is locked,˵Ã÷scottÓû§±»Ëø×¡ÁË£¬ÎҾͽøÐÐÁ˽âËø£¬Óï¾äÈçÏ£ºalter user soctt account unlock;Ö´ÐÐÍêÒÔºó·¢ÏÖÓÖÌáʾÁËÒ»¸ö´íÎóÐÅÏ¢£¬No Connect
ÎÞ·¨Á´½Ó£¬ºóÀ´ÔÚÍøÉϲéÁ˲飬ÖÕÓÚÕÒµ ......

oracle¸ßˮλÏß

ʲôÊÇË®Ïß(High Water Mark)?
----------------------------
ËùÓеÄoracle¶Î(segments£¬ÔÚ´Ë£¬ÎªÁËÀí½â·½±ã£¬½¨Òé°Ñsegment×÷Ϊ±íµÄÒ»¸öͬÒå´Ê) ¶¼ÓÐÒ»¸öÔÚ¶ÎÄÚÈÝÄÉÊý¾ÝµÄÉÏÏÞ£¬ÎÒÃǰÑÕâ¸öÉÏÏÞ³ÆÎª"high water mark"»òHWM¡£Õâ¸öHWMÊÇÒ»¸ö±ê¼Ç£¬ÓÃÀ´ËµÃ÷ÒѾ­ÓжàÉÙûÓÐʹÓõÄÊý¾Ý¿é·ÖÅ䏸Õâ¸ösegment¡£HWMͨ³£Ôö³¤µÄ·ù¶ ......

ORACLE 10gÏÂÔØµØÖ·

ORACLE 10gÏÂÔØµØÖ·
Oracle Database 10g Release 2 (10.2.0.1.0) Enterprise/Standard Edition for Microsoft Windows (32-bit)
http://download.oracle.com/otn/nt/oracle10g/10201/10201_database_win32.zip
http://download.oracle.com/otn/nt/oracle10g/10201/10201_client_win32.zip
http://download.oracle.co ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ