PL/SQL Newbie Question

From: Ed_Zep <ed_zep_at_ntlworld.com>
Date: 8 May 2005 12:49:18 -0700
Message-ID: <1115581758.745124.179560@o13g2000cwo.googlegroups.com>

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. Received on Sun May 08 2005 - 14:49:18 CDT