OraFAQ Forum: Server Administration » database server session history

Home » RDBMS Server » Server Administration » database server session history (Oracle 10g R2, Solaris 10)

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

database server session history [message #503541]

Sun, 17 April 2011 21:22

reym21
Messages: 241
Registered: February 2010
Location: Philippines

Senior Member

Good day...

Can I extract data from our Oracle server regarding the no. of sessions per day? But the problem is that our Boss wants a previous dates from April 11-17, 2011.

Many thanks.

Report message to a moderator

Re: database server session history [message #503542 is a reply to message #503541]

Sun, 17 April 2011 21:37

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Can I extract data from our Oracle server regarding the no. of sessions per day?
>But the problem is that our Boss wants a previous dates from April 11-17, 2011.
most likely answer is NO
Was session AUDIT enabled prior to 11 April?
Does application utilize connection pooling?

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: database server session history [message #503543 is a reply to message #503542]

Sun, 17 April 2011 22:23

reym21
Messages: 241
Registered: February 2010
Location: Philippines

Senior Member

Thanks for this.

I would try to check this first.

Regards..

Report message to a moderator

Re: database server session history [message #503544 is a reply to message #503543]

Sun, 17 April 2011 22:26

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

you might be able to obtain a close approximation by filtering listener.log file
Your Mileage May Vary

Report message to a moderator

Re: database server session history [message #503575 is a reply to message #503544]

Mon, 18 April 2011 02:35

John Watson
Messages: 8960
Registered: January 2010
Location: Global Village

Senior Member

It's in your statspack or AWR reports, for what ever periods you have snapshots. The "logons cumulative" statistic.

Report message to a moderator

Previous Topic:	job is killed ,but job'stotal_time is growing up
Next Topic:	Create multiple database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 06:43:06 CST 2024