12c EM Agent CPU spiking and High Usage on Solaris
12c EM Agent CPU spiking and High Usage on Solaris with many Database and Listener Targets (Doc ID 1536871.1)
Month: July 2014
To add in ODSM new ldap servers – use the command line
Adding initial LDAP servers to ODSM can only be done from the command line. Note: In the recent releases this can now be done in the Web GUI. Run the OUD dsconfig utility. choose option 6 Add both option (first option 1, then option 2) once done select options 8 1 5 5 choose 2 …
To add in ODSM new ldap servers – use the command line Read More »
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 …
cpu hog
perl -e 'while (–$ARGV[0] and fork) {}; while () {}' 4
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 »