Re: PL/SQL Newbie Question

DA Morgan schrieb am 08.05.2005 in <1115592165.925251_at_yasure>:

> 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.

How to write a logon- trigger? What event on what table I have to use?

Andreas

-- 
wenn email, dann AndreasMosmann <bei> web <punkt> de