A fairly easy script today that isn’t really hard to work out for yourself but I find it useful to have this script kicking around for when you find high resource using Oracle server process and you want to identify the offending SQL.
set pages 1000;
set lines 200;
col username for a10;
select b.status,a.inst_id,a.PID "Ora PID",a.SPID "Server PID",
b.terminal,a.terminal,b.Process "Client Process"
from gv$process a,gv$session b where a.addr=b.paddr and b.sid=&SID
See you next week!
Since I dont post on here to often I will try and post a weekly script that I find useful day-to-day.
First up is a short simple script to scp your private key to a defined server. Usage is pretty simple call the script with the username@hostname
e.g ./ssh_key_scp.sh username@hostname
If no ssh key already exists the script gives you the option to generate one.
# Andrew Paz
if [ ! -f ~/.ssh/id_rsa.pub ];then
echo "Private key not found at $KEY"
while true; do
read -p "Do you wish to generate a private key?" yn
case $yn in
[Yy]* ) ssh-keygen -t rsa; break;;
[Nn]* ) exit;;
* ) echo "Please answer yes or no!";;
if [ -z $1 ];then
echo "Please specify user@host as the first parameter of this script"
echo "Putting your key on $1... "
ssh -q $1 "mkdir ~/.ssh 2>/dev/null; chmod 700 ~/.ssh; echo "$KEYCODE" >> ~/.ssh/authorized_keys; chmod 644 ~/.ssh/authorized_keys"
echo "done :D Key Uploaded!"
Thats it for this week, will post another next week.