IZEA

Sunday, May 12, 2013

Query to find Locked Tables in Oracle


Query to find Locked Objects:
 
select a.object_name, b.oracle_username, b.os_user_name,c.sid, c.serial# ,c.terminal, d.sql_text
from sys.dba_objects a, v$locked_object b, v$session c, v$sqltext d      
where a.object_id = b.object_id
and c.sid = b.session_id
and c.sql_hash_value = d.hash_value

(OR)

select a.object_id, b.owner, b.object_name, a.session_id, a.oracle_username, a.process
from v$locked_object a, dba_objects b

where a.object_id = b.object_id;

Query to find m/c & user name having lock:

select sid, username, osuser, process, machine, program
from v$session
where sid = sid_of_hanging_session;

Query to kill Session:

ALTER SYSTEM KILL SESSION 'SID,SERIAL#' IMMEDIATE;

Query to find PID of session:

select pid from v$process where addr=
(select paddr from v$session where sid=sid_of_hanging_session);

Whenever there is a lock in the object, if you issue a DML command on the same, it will thrown the below error.

ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired.
 

Thursday, May 9, 2013

How To Enable Telnet In Windows Server 2008

Telnet is a network protocol used on the Internet or LAN to provide a bidirectional interactive text-oriented communication facility. Users of different platform use this facility mainly to check the communication between 2 servers or machines. In Windows Server 2008, Telnet is not enabled by default but included as a feature ‘Telnet Client’. Basically allows a computer to connect to a remote Telnet server and run applications on that server.

Unlike Windows 2003, if you give the Telnet command in Windows Server 2008 you will be promoted below message. 


Follow the below steps to enable Telnet on Windows Server 2008.
  • Click Start  > Server Manager, Open Server Manager.


    In Server Manager, click on Features and then Click on Add Features.



    Select Telnet Client from the available list of features, then click Next.


     Installation in Progress...



    Installation is Completed .

    Now run the telnet command and as you expect, it is recognized by Windows Server 2008 and you can start using it to connect to your telnet servers.

Tuesday, April 23, 2013

GAYLE Storm Smashes Pune Warriors



It’s been a day of records in the history of IPL where Chris Gayle (RCB) holds most of it. In the Royal Challengers Bangalore - Pune Warriors India IPL clash, Gayle's fireworks will be remembered by cricket fans for long time.  With his stunning shots, RCB scored the highest T20 score - 263 for five wickets in their 20 overs. "It was one of those days. I got a good total. I can't say it's a decent total - it's a good total. All I had for breakfast this morning was a plain omelet, two pancakes and a hot chocolate." Gayle said after his brutal innings. 

Fastest Century in T20:


Chris Gayle's 30-ball century is fastest ever in IPL. Chris Gayle set a new record for the fastest century in professional cricket by reaching 100 off 30 balls. He scored 175 not out in just 66 balls with 17 sixes and 13 boundaries. He beats the previous 34-ball ton Twenty20 league record set by Australia's Andrew Symonds.  South African Richard Levi holds the record for fastest international T20 hundred in 45 balls against New Zealand in 2011 at Hamilton.  Pakistan's Shahid Afridi holds the record of fastest century in ODI (37 balls) while Viv Richards holds the record of fastest ton (56 balls) in Test history.

Interesting Tweets on Gayle’s show:

Brian Lara: I like that one wen "Gayle bats fielders become spectators and spectators become fielders" chilling @ home watching some awesome hitting.

Mahendra Singh Dhoni: Life is all about taking the right decision, seeing Gayle bat today I think I took the right decision of being a wicket keeper.

Suresh Raina: A ball just flew past Chepauk! Did it come from Chinnaswamy??????

Shilpa Shetty: Unbelievable inning by Gayle! Thank God we r not at the receiving end!!ha ha ha;) Incredible...he makes it all look so easy!

Dale Steyn: Oh no... Actually, Wow!!! This is insane!!

Darren Sammy: @henrygayle he's not human..He’s a tsunami mixed with a nuclear bomb