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
CW2005
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.

CW
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: 4579
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.

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


Current Time: Thu Mar 28 07:22:15 CDT 2024