Writing About Our Experiences With Oracle Databases
Friday May 18th 2012

Latest Topics

Using current_scn for RMAN incremental ? Think again..

I am bloging about experience we had using rman incremental backup for syncing standby database. We had a standby [Read More]

Poll on Sql Plan Management

Dominic is conducting poll on SPM and Sql Profiles usage on his website. Link can be found hereĀ  I have been using SPM [Read More]

Oracle Direct connector for HDFS

Some time back oracle had announced Oracle Big Data appliance. Along with this Oracle released Big Data Connectors to [Read More]

ORA-7445 core dump [kokscold()+849] from EM 12c

The first problem reported by my EM 12c is an ORA-7445 error. After checking the alert log following is the exact [Read More]

Copying Oracle Scheduler jobs with Arguments

Oracle provides dbms_scheduler.copy_job function to copy oracle scheduler jobs which works great. But problem is that [Read More]

AIX

AIX

Number of Cpu’s

$/usr/sbin/lsdev -C -c processor -S Available| wc -l

Memory Details

$/usr/sbin/lsattr -E -l sys0 -a realmem

Swap Configured

$/usr/sbin/lsps -a

To find maximum processes allowed and change it to 10000

$lsattr -El sys0 -a maxuproc
#chdev -l sys0 -a maxuproc='10000'

Find memory utilization by process on AIX

ps axwv | awk '{t=t+ -  ;print  - ,,,,}END{print t}' | sort -rn | pg

Script for Monitoring memory just like vmstat
===============================================
copy the contents in file like mem_mon.sh

### Usage mem_mon.sh (interval) (occurences) e.g sh mem_mon.sh 2 10 ###
### This will give top 10 memory consuming processes #####
wt_time=
lmt=
 let a=0
while [[ $a -lt $lmt ]] ; do
ps axwv |sort -nrk 7,7|grep -v "COMMAND" \
|awk 'BEGIN {printf ("MemoryinKb \t ProcessId \t PerCPU \t PerMem \t Command \n")}{t=t+ -  ;printf("%13d \t %10d \t %6.2f \t %6.2f \t %s \n", - ,,,,)}END{print t}'|head -10
 let      a+=1
sleep $wt_time
done

Share

Leave a Comment

*

Recent Comments

Amit had this to say

hi Bhushan, Em should be pretty easy. I will try to do it in my test setup and document it. cheers Amit Read the post

bhushan had this to say

Hey Amit, Any Document to Setup the Dataguard using EM12C? Any tips any suggestion? Regards Bhushan Read the post

Amit had this to say

By default window is created with LOW prioirty. If there are two overlapping windows with low and high priority. High Read the post

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 11 other subscribers

asd123