Replies to This Discussion

Permalink Reply by Teddy Blanchette on June 11, 2013 at 1:02pm

Please use the following dynamic views to determine what the users are doing and when,

v$sql,v$sqlarea,v$session

Permalink Reply by Leoma Cheesman on June 11, 2013 at 1:07pm

this is what auditing is for:

alter system set audit_trail=db_extended scope=spfile;
audit all statements by whomever;
startup force;

then query the audit trail. That's 11.2, can't remember how it works on your old 10g database.
Those V$ views MOH_DBA mentions won't tell you anything useful, because they are populated from the SGA and have no historical information.

Permalink Reply by Teddy Blanchette on June 11, 2013 at 1:18pm

as i understand he wants to know what connecting users are doing. it did not come to my mind that he wants historical data.

------
v$ views tell u alot of things, it have the sql populated from sga and it tell u a lot of info.