Posted in 2017

Knowledge Window

select
     path
  from v$asm_disk
  where (disk_number, group_number) in
     (select
            distinct DISK_KFFXP,
            group_kffxp
            from x$kffxp where (group_kffxp,NUMBER_kffxp) in 
(SELECT f.group_number, f.file_number FROM v$asm_file f where f.type='ONLINELOG'))
order by 1
/

! Add the following options to the boot loader (grub) configuration
• iommu=soft elevator=noop apm=off transparent_hugepage=never numa=off powersaved=off

! For very high performance database systems add the following options to the boot loader (grub) configuration in addition to those listed above (PVSCSI required)
• vmw_pvscsi.cmd_per_lun=256 vmw_pvscsi.ring_pages=32

root@oel63ebs lv02]# iozone -a -I -s 256m -r 8192 -g 2G -i 0 -i 1
        Iozone: Performance Test of File I/O
                Version $Revision: 3.414 $
                Compiled for 64 bit mode.
                Build: linux

        Run began: Tue Oct 14 17:47:44 2014

        Auto Mode
        O_DIRECT feature enabled
        File size set to 262144 KB
        Record Size 8192 KB
        Using maximum file size of 2097152 kilobytes.

        Command line used: iozone -a -I -s 256m -r 8192 -g 2G -i 0 -i 1
        Output is in Kbytes/sec
        Time Resolution = 0.000002 seconds.
        Processor cache size set to 1024 Kbytes.
        Processor cache line size set to 32 bytes.
        File stride size set to 17 * record size.
                                                            random  random    bkwd   record   stride                                  
              KB  reclen   write rewrite    read    reread    read   write    read  rewrite     read   fwrite frewrite   fread  freread
          262144    8192 1052943 1359337  1657157  1713078                                                                         
          524288    8192 1357404 1531524  1728982  1745811                                                                         
         1048576    8192 1378301 1626261  1497152  1650120                                                                         
         2097152    8192 1267582 1455948  1531769  1525500                                                                         

iozone test complete.

ost_physical:~ # dd if=/dev/zero of=/lv01/test1 bs=2G count=1 oflag=dsync
0+1 records in
0+1 records out
2147479552 bytes (2.1 GB) copied, 3.53109 s, 608 MB/s
ost_physical:~ # dd if=/lv01/test1 of=/dev/null bs=2G count=1 oflag=dsync
0+1 records in
0+1 records out
2147479552 bytes (2.1 GB) copied, 1.44924 s, 1.5 GB/s

host_physical:/lv01 # hdparm -t --direct /dev/sda3

/dev/sda3:
Timing O_DIRECT disk reads: 1132 MB in  3.00 seconds = 376.96 MB/sec
host_physical:/lv01 # hdparm -t --direct /dev/sdb1

/dev/sdb1:

Timing O_DIRECT disk reads: 7010 MB in  3.00 seconds = 2336.51 MB/sec
host_physical:/lv01 #

https://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=2069356&customTheme=otn

https://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=2053145&customTheme=otn

http://www.vmware.com/content/dam/digitalmarketing/vmware/en/pdf/partners/oracle/oracle-databases-on-vmware-best-practices-guide.pdf

https://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=1010398

Advertisements

Author:

Database administrator who loves to work with Oracle software. (Sometimes not)

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s