Understood.  Thanks Alan, you have really helped me.  Cheers!

Thanks Alan, 

Good to hear of your experience.  You're right, HA isn't a concern here and it's a relief not to be hacking around on live.  I'll install on...

On balance, yes, excel would do it but my users want something more "formy" that can generate (basic) reports and do things in a way they are used to. ...

Cheers all, nice to know I'm not missing a trick. Last login / host / prog would be VERY useful.

I've set up a job to check logins every...

Great, thanks. Sometimes I just need a pointer! Appreciate the response. 🙂

Thank you! Much obliged.

Understood, thanks Perry. I was hoping you would answer.

ok, thanks John.

Thanks blob_eater. I'll probably leave it then. Seems a bit pointless unless there's another reason I don't know about.

Thanks all. I get the gist. Didn't know if there was a:

DROP TABLE [sessionID, databaseName, #tableName] command I didn't know about.

Appreciate your time to respond. Have...

ah ... the bit of info I was missing was the NLS_DATE_FORMAT.

Once I understood this I could see my true date/times.

Then I used TRUNC to group by.

Thanks for your help

Thanks for the reply.

I may not have explained myself very well but I have made a bit of progress, when I round the date field I am seeing the results...

also is there an osql -L equivalent to locate oracle instances?

Thank you!!

Perfect, thank you both for clear & concise answers! It really helps.

Thanks all, appreciate your replies!

I was quite lost. I could see incoming calls to SQL from host A supposedly via the access db. However, having spent...