Re: PL/SQL Newbie Question

Ed_Zep wrote:

> Hello.
>
> We are running Solaris 2.8 and Oracle RDBMS 9.2.0.4.
> I need to audit the amount of SQL*Net sessions open at a regular
> interval and also how many of those are a particular user (INTERNET).
>
> I was going to set up a table and have the PL/SQL procedure update it
> but I know nothing about PL/SQL and was wondering if anyone could tell
> me a way of doing this?
>
> I need to be able to record total sessions open, amount of INTERNET
> users logged in and the date.
>
> Hope someone can help with this.
>
> Many thanks.

AUDIT as Sybrand suggests.
Query v$session perhaps with DBMS_JOB
Use a LOGON trigger.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)