dbms_session.unique_session_id for other sessions?

From: Volker Hetzer <volker.hetzer_at_ieee.org>
Date: Tue, 30 Aug 2005 16:26:09 +0200
Message-ID: <df1qa2$mdb$1@nntp.fujitsu-siemens.com>

Hi!
We've got an application which runs concurrently, So each app identifies its data by having the session id in one column. (We can't use temp tables because we use oracle spatial.) Now, sometimes that app dies and leaves data in the table. It doesn't really matter result wise since each new instance cleans out the tables using its own session id as key but nevertheless, I'd like to avoid accumulations of data because session it's won't get reused that frequently.

What I'd like is to get rid of that data. What I had in mind was a cronjob which once per weekend figures out all current session ids and throws out the rest of the data.

Can I do that? How could I find out the unique session ids for all currently active sessions?

Lots of Greetings!
Volker Received on Tue Aug 30 2005 - 09:26:09 CDT