OraFAQ Forum: Server Administration » Information About All Sessions Activity !!!

Home » RDBMS Server » Server Administration » Information About All Sessions Activity !!!

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

Information About All Sessions Activity !!! [message #54988]

Mon, 23 December 2002 05:50

CHANDRESH CHAUHAN
Messages: 1
Registered: December 2002

Junior Member

Is It possible to store sessions activity information before it lost from v$session and v$sql.

Report message to a moderator

Re: Information About All Sessions Activity !!! [message #54990 is a reply to message #54988]

Mon, 23 December 2002 08:22

B
Messages: 327
Registered: August 1999

Senior Member

Create a trigger ....

Report message to a moderator

Re: Information About All Sessions Activity !!! [message #54995 is a reply to message #54988]

Mon, 23 December 2002 13:36

sai sreenivas jeedigunta
Messages: 370
Registered: November 2001

Senior Member

All u need to do is ,
create the after logon / similar kinda triggers and put the appropriate information in the tables, which u can later use for reporting stuff..

sai

Report message to a moderator

Previous Topic:	ora-01578 and ora-01110
Next Topic:	Date Storage

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 01:24:12 CDT 2024