Blog Home  Home Feed your aggregator (RSS 2.0)  
The Johnnynine Weblog - Who has open connections on your oracle database
A weblog by Johnny Hughes
 
 Tuesday, July 12, 2005

Sometimes (especially when running web applications) it's nice to see how many open connections you have to your database. Use this select statement to get them (ignore SID of <="5).

select * from v$lock

Cross reference SID with:

select * from v$session where sid=1234

Tuesday, July 12, 2005 4:34:31 PM (US Mountain Standard Time, UTC-07:00)  #    Comments [0]   Database | Oracle  |  Tracked by:
"outdoor misting fan" (online) [Trackback]
"hanes hosiery" (online) [Trackback]
"yucca root" (online) [Trackback]
"porcelain wares" (online) [Trackback]
"nautica baby bedding" (online) [Trackback]
"dansko molly" (online) [Trackback]
Name
E-mail
(will show your gravatar icon)
Home page

Comment (Some html is allowed: a@href@title, b, blockquote@cite, em, i, strike, strong, sub, super, u)  

Copyright © 2008 Johnny Hughes. All rights reserved.
DasBlog 'Portal' theme by Johnny Hughes.