Home » Other » General » Active Sessions (Oracle 10g, Windows )
Active Sessions [message #501560] Tue, 29 March 2011 22:57 Go to next message
gxeon
Messages: 53
Registered: January 2011
Location: Mumbai
Member
Hello

Need your help. I have Oracle 10g setup on Windwos Environment. i want to know curretnly how many sessions are running at a given point of time. Also who are the users who are currently logged in, and what SQL Statments they have fired so far with the curent SQL statment info.

please Help
GG
Re: Active Sessions [message #501562 is a reply to message #501560] Tue, 29 March 2011 23:07 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>i want to know curretnly how many sessions are running at a given point of time
SELECT COUNT(*) FROM V$SESSION;

Is application 3-tier as in below?
EndUser<=>browser<=>WebServer<=>ApplicationServer<=>DatabaseServer
Re: Active Sessions [message #501563 is a reply to message #501562] Tue, 29 March 2011 23:11 Go to previous messageGo to next message
gxeon
Messages: 53
Registered: January 2011
Location: Mumbai
Member
no sir Its not 3 Tier application. Its a Client Server Application, No middle Tier.
Re: Active Sessions [message #501564 is a reply to message #501563] Tue, 29 March 2011 23:13 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>and what SQL Statments they have fired so far with the curent SQL statment info.
you need to enable SQL_TRACE
Re: Active Sessions [message #501566 is a reply to message #501564] Tue, 29 March 2011 23:16 Go to previous messageGo to next message
gxeon
Messages: 53
Registered: January 2011
Location: Mumbai
Member
ok sir Thanks !! can u please guide my step by step how to do it. i am new to Oracle DBA.

please help.
Re: Active Sessions [message #501567 is a reply to message #501566] Tue, 29 March 2011 23:18 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Which part of the Posting Guidelines ( http://www.orafaq.com/forum/t/88153/0/ ) did you NOT read & follow?
Was it the part about using SEARCH ( http://www.orafaq.com/forum/s/136107/ ) or GOOGLE ( http://google.com ) before posting?
Why should we repeat here, what is already documented at http://tahiti.oracle.com
Please post DOCUMENTED solution back here after you have found it.
Re: Active Sessions [message #501568 is a reply to message #501567] Tue, 29 March 2011 23:21 Go to previous message
gxeon
Messages: 53
Registered: January 2011
Location: Mumbai
Member
ok sir,Sorry i will fallow as u said.

Thanks.

GG
Previous Topic: Data synchronization
Next Topic: AWR
Goto Forum:
  


Current Time: Fri Dec 03 05:51:53 CST 2021