Create The World With Creativity
 
Welcome, Guest:Log in | Register | Information Center | Languages | Search | Tags | FAQs | Lite
There was a problem with the request. Check your permission or contact with administrator.




Your Ad Here

Grade this thread

Quote Favorites Report
Starter:  Topic: : Show Who's logged in and be active
myDBA 
4 Stars
 

Info: Moderator Offline Male
From: Not Specified 
Posts: 223  
Digest 1  
Credits: 40
Money: 1168 $OraclePoint
Registered on 2007-04-12
ProfileProfile BuddyBuddy PMPM Send EmailEmail Reply Reply QuotesQuotes   1 F 
Show Who's logged in and be active



It shows you who's logged in and active -- and if active, the statement they are executing (and the latest text shows you how long that statement has been executing).  Currently, it shows only SQL that is executing right now, just change the predicate from "where status = 'ACTIVE'" to "where status = status" if you want to see the currently executing as well as LAST executed (in which case the latest column text shows you how long they've been idle -- not how long that statement took to execute) 
[url=http://www.oraclepoint.com]Mqxlim7jMOraclePointxQFluX5zz[/url]


See output bellow...    

[Lasted edited on 2007-08-15 10:40 myDBA ]



Zip attachment: show_who_logged.rar (Size:1.06kb, Download times:28)


Tags: scripts 

2007-08-15 10:25
  Grade this thread



Similar Threads Forum Author Replies Views Last Post
Provide Oracle Performance Healthcheck
Oracle Tools, Utilities & Scripts Rui 3 8452  2009-06-08 10:24
Oracle Health Checks with Health Monitor; Using PL/SQL or ADR
Oracle Database 11G R.Wang 0 1448  2008-11-17 15:22
Script to Detect bugs on Statistics
Oracle Tools, Utilities & Scripts R.Wang 0 955  2008-08-15 15:00
Oracle Matalink Database Scripts Index
Oracle Tools, Utilities & Scripts R.Wang 0 2087  2008-08-15 11:28
Trace Analyzer - Analyzing SQL Trace (10046)
Oracle Tools, Utilities & Scripts R.Wang 0 1982  2008-07-22 14:09

  Quick Response
Title:
Content:




Upload: Disable
Username:
Password:
  



Recommend to a friend Print Article Mode





 


Powered by BMForum Powered by BMForum 2007 5.6 RSS Feed  
Processed in 0.85407996 second(s),8 queries  
Top