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

Report message to a moderator

- 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: 4596
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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri May 02 14:23:49 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.