Keeping a history of the V$SESSION table [message #137918] |
Sun, 18 September 2005 20:32 |
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 |
Frank Naude
Messages: 4580 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
|
|
|