Hello Friends,
Here is a quick command to create multiple process in oracle database.
1) SQL Script - the script below will create session and hold for 10 minute
sqlplus -s / as sysdba <<EOF
select resource_name, current_utilization, max_utilization from v\$resource_limit where resource_name in ('processes','sessions');
exec DBMS_LOCK.Sleep( 600 );
EOF
2) Call SQL Script multiple time. (50 times)
nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh & nohup /tmp/jm1.sh &
