Re: ORA-00920 when using function returning boolean...

> Now, sometimes applications crash, leaving data in the spatial
> tables. So, I'm going to do a little cronjob which cleans out
> those tables once per day, probably midnight.
> That job first gets all session id's and then deletes the data of
> all non-active sessions.

That is exactly what I am curious about.

How do you plan to gather the session_id's and determine which are active?

Remember, this is not available in v$session. The required session id is available only to the current session.

Jared Received on Sat Sep 10 2005 - 01:06:50 CDT