DevTech101

DevTech101

Month: July 2014

Matching ZFS Storage Block Size with Hitachi (HDS) Block Size

How to match Oracle ZFS appliance(ZFSSA) with VSP block size The example below uses a 1Tb lun size Starting Base block size for a 1Tb lun on Oracle ZFS Appliance(ZFSSA). 1099511627776 To match this with the VSP block size, this is what was used, it was 6291456 more. 1099517919232 = 1099511627776+6291456 (768*8192) On the VSP …

Matching ZFS Storage Block Size with Hitachi (HDS) Block Size Read More »

jmeter web site load test

Before the change. threads.search=170 threads.category=50 threads.detail=34 threads.refine=6 threads.cart=8 threads.other=0 test.duration=5000 test.ramp_up=1500 test.startup_delay=0 After the chnage threads.search=130 threads.category=24 threads.detail=45 threads.refine=9 threads.cart=21 threads.other=0 test.duration=5000 test.ramp_up=1000 test.startup_delay=0 Last working test threads.search=115 threads.category=20 threads.detail=45 threads.refine=9 threads.cart=21 threads.other=0 test.duration=5000 test.ramp_up=1000 test.startup_delay=0  

Oracle SQL Database Commend Line Capturing Continues Select

Example 1 echo exit | sqlplus / as sysdba @/var/tmp/usera/foo.sh |egrep “COUNT|3|Elapsed:” >>/var/tmp/db_timing.out Example 2 while :; do echo exit | sqlplus / as sysdba @/var/tmp/usera/foo.sh |egrep “COUNT|3|Elapsed:” >>/var/tmp/db_timing.out; sleep 2; done Example 3 while :; do sqlplus eli/eli @/var/tmp/usera/foo.sh >>/var/tmp/db_timing.out ; sleep 2; done

To change the Oracle SQL listner to SDP

Change pga size, set the pga to at least 32gb >Set to the number of cores show parameter gcs_server – 16; Change DB options to filesystemio_options     setall To change listner to SDP crsctl modify resource ora.LISTENER.lsnr -attr “ENDPOINTS=SDP:1521” crsctl modify resource ora.LISTENER_SCAN1.lsnr -attr “ENDPOINTS=SDP:1521” crsctl modify resource ora.LISTENER_SCAN2.lsnr -attr “ENDPOINTS=SDP:1521” crsctl modify resource ora.LISTENER_SCAN3.lsnr -attr …

To change the Oracle SQL listner to SDP Read More »

How to change an Oracle Database from TCP to RDS on Infiniband

Changing an Oracle Database from TCP to RDS If your Oracle Database runs on an Infiniband network, you can greatly benefit by switching from TCP to RDS for DB cluster communications First enable RDS svcadm enable svc:/system/rds:default svcs svc:/system/rds:default STATE STIME FMRI online 4:40:52 svc:/system/rds:default For ASM On one node crsctl stop cluster -all On …

How to change an Oracle Database from TCP to RDS on Infiniband Read More »