OraFAQ Forum: General » Active Sessions

Home » Other » General » Active Sessions (Oracle 10g, Windows )

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Active Sessions [message #501560]

Tue, 29 March 2011 22:57

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

Report message to a moderator

Re: Active Sessions [message #501562 is a reply to message #501560]

Tue, 29 March 2011 23:07

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

Report message to a moderator

Re: Active Sessions [message #501563 is a reply to message #501562]

Tue, 29 March 2011 23:11

gxeon
Messages: 53
Registered: January 2011
Location: Mumbai

Member

no sir Its not 3 Tier application. Its a Client Server Application, No middle Tier.

Report message to a moderator

Re: Active Sessions [message #501564 is a reply to message #501563]

Tue, 29 March 2011 23:13

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

Report message to a moderator

Re: Active Sessions [message #501566 is a reply to message #501564]

Tue, 29 March 2011 23:16

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.

Report message to a moderator

Re: Active Sessions [message #501567 is a reply to message #501566]

Tue, 29 March 2011 23:18

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.

Report message to a moderator

Re: Active Sessions [message #501568 is a reply to message #501567]

Tue, 29 March 2011 23:21

gxeon
Messages: 53
Registered: January 2011
Location: Mumbai

Member

ok sir,Sorry i will fallow as u said.

Thanks.

GG

Report message to a moderator

Previous Topic:	Data synchronization
Next Topic:	AWR

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 15 18:24:15 CST 2025