Wednesday, March 4, 2015
I had this guest OS in vm on window which I regularly used to connect via IPV4, but suddenly that network interface stopped working and I had IPV6 in place. So I started thinking how do I connect to IPV6 address via ssh !
I came across this post: http://serverfault.com/questions/234711/how-do-i-add-ipv6-address-into-system32-drivers-etc-hosts
Basically you need to run below command on your windows host to get the VMnet8's segment id
netsh interface ipv6 show addresses
assuming your IPV6 is - fe80::20c:29ff:feea:a19c
so your ssh command will be as follows
ssh -6 oracle@fe80::20c:29ff:feea:a19c%16
You can also make same entry in your "System32\drivers\etc\hosts" file so that you can connect to your IPV6 guest by name as well.
Posted by Technology Yogi at 10:11 AM
Monday, January 5, 2015
Even wanted to know or monitor the elapsed time of a currently running query ? - here is the query to do so
Here in this query are trying to figure out if there is any active query (status = 'active') that is running for long than 15 minutes ('00:15:00' ::INTERVAL DAY TO MINUTE)
CURRENT_TIMESTAMP - QS_TSTART ElapsedTime,
from _v_qrystat A
join _v_session B on A.QS_SESSIONID = B.id
where B.status = 'active'
and ( CURRENT_TIMESTAMP - A.QS_TSTART ) > '00:15:00' ::INTERVAL DAY TO MINUTE ;
This above query also show how to use "INTERVAL" data types which I discovered first in Oracle than in any other RDBMS.
This you can further extend for monitoring and alerting purposes, using shell and cron.
Posted by Technology Yogi at 2:12 PM
- Technology Yogi
- By profession I am a Database Administrator (DBA) with total 13 yrs. of experience in the field of Information Technology, out of that 9 yrs as SQL DBA and last 3 years in IBM System i/iSeries and DB2 LUW 9. I have handled Developer, plus production support roles, and I like both the roles. I love and live information technology hence the name "Techonologyyogi" Apart from that I am a small, retail investor, with small investments in India and United States in the form of Equity holdings via common stocks. Don't ask me if I have made money, I have been loosing money in stocks.