Re: insert into statement

"Simon Cunningham" <cs40_at_gre.ac.uk> wrote in message news:3BB08493.553150B7_at_gre.ac.uk...
> HI all
>
> Right I have created a table stats based on v$session with a few
> selected columns ie username, terminal, sid and so on. I have a script
> that inserts into my table stats every half an hour from the v$session,
> the table has no primary key as yet. If I have a user connected for
> longer than half an hour he will be entered twice making my stats
> incorrect. What I want is some sort of validation to check the table
> before entering the data. Any light on my problem would be great
>
> Thanks in advance
>

Why don't you just use audit connect.
Those results are correct, as they will be updated when the client connects and logs off.
Your method is imposing overhead on the system and bound to fail.

Hth,

Sybrand Bakker, Senior Oracle DBA Received on Tue Sep 25 2001 - 12:30:58 CDT