Monthly Archives: September 2011

DB Session Management

Posted on by

Session Management is very important for Database Administrators. Hosting a database is not always fun as people accessing the database can do all kinds of stuff to it. These sessions need to be sometimes killed for the greater good. Below is session management for a few databases.

For Oracle Database Session Management;

Make sure you are have admin credentials. Use V$Session View for Session Management for Oracle Database.

select * from v$session;

or specifically

select sid,serial#,username,machine,program from v$session; to avoid unnecessary complicated data.

Now to kill the unnecessary session. Using the SID and Serial # of the session you can kill the session as below;

alter system kill session ‘SID,Serial #’;

e.g., alter system kill session ‘13,10196’;

For MS SQL Server 200x;

SQL Server has the simplest Session monitoring there is. Connect to the DB server from SQL Server Management Studio. Right Click on the Server and select “Activity Monitor”. In the resulting window expand the “Processes” pane to get the sessions running. Right click on the desired pesky session and select “Kill Process”.

I will add other Databases session management info soon….

Fragship

Posted on by

Whats “Fragship” you say? Its Fragging Friendship…. This is the kind of friendship you see between two gamers or two friends who are gaming.

Every gamer has Fragship stories…….Here are some of mine.

  • Foot boards; Friends playing Need for Speed 2 with feet instead of hands over an irritating roommate’s PC.
  • Princess is in another Castle; A friend losing a life at the end of the lava stage and the entire classroom who were concentrating on his screen gasps “oooooh” bewildering the tutor.
  • In the land of the Blind, the guy with one eye is the king; Playing Unreal Tournament with my friends: Always hogging the invisible power and then camping on the skyscraper and sniping the hell out of everyone.
  • No one gets left behind; Playing Army of Two with a friend who always leaves me behind and rushes of ahead.
  • Mind Blowing; Achieving a Head shot through sniper scope zoomed in on the enemy while a friend is having dinner much to his discomfort.
  • King of the Hill; Having a score of 21-24 in a 25 kill death match and getting 4 kills with a vehicle and winning the match at 3 am in the morning.
  • Of mice and Men; Playing an online fps on a buddy’s laptop using his track pad and him letting me do it.

Gaming rocks but friends rock harder……

Thanks Ashu, Nagar, Sravan, Venky, Vijay, Bhanu, Anil and many more….