Home » RDBMS Server » Security » Keeping a history of the V$SESSION table
Keeping a history of the V$SESSION table [message #137918] Sun, 18 September 2005 20:32 Go to next message
Messages: 29
Registered: February 2005
Junior Member
Hi Guys

I have a requirement to record details from the V$SESSION table.

We have many users connecting to the Oracle database (9206) from many third party programs. I have been asked to record all information in the V$SESSION table whenever a user connects using a particular program.

Does anyone know how I can do this?

Thanks in advance.

Re: Keeping a history of the V$SESSION table [message #137932 is a reply to message #137918] Sun, 18 September 2005 22:53 Go to previous message
Frank Naude
Messages: 4571
Registered: April 1998
Senior Member
The best you can do is to sample the V$SESSION view on regular intervals.

In fact, Oracle 10g does something similar when you set STATISTICS_LEVEL=TYPICAL or FULL. This feature is called ASH (Active Session History). Sampled data is stored in the AWR and can be queried from V$ACTIVE_SESSION_HISTORY or WRH$_ACTIVE_SESSION_HISTORY.

Best regards.

Previous Topic: exp/ imp security
Next Topic: Data Level Security
Goto Forum:

Current Time: Wed Aug 17 19:56:10 CDT 2022