On Fri, Aug 21, 2009 at 10:31 AM, Fuad Arshad <fuadar@xxxxxxxxx> wrote: > List > I'm trying to figure out someone that potientially can be basic > I know awr and ash contain data about users that were connected I'm trying > to find a way to tell at a point in time how many users were connected > I.e abc had 500 sessions > Def has 600 sessions > Basically looking to match the users the caused my process resource limit > to exceed .this is more of debugging exercise > You can do that with auditing by enabling session auditing. select username ,timestamp logon ,logoff_time logoff , os_username ,terminal ,action_name ,returncode from dba_audit_session order by timestamp / Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist