RE: Find out export from remote locations

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Mon, 22 Oct 2001 10:20:05 -0700
Message-ID: <F001.003B18B3.20011022102435@fatcity.com>

> -----Original Message-----
> From: Tatireddy, Shrinivas (MED, Keane)
> [mailto:Shrinivas.Tatireddy_at_med.ge.com]
>
> In V$session I am able to find only the session that is connected. But
> it is not showing anything in program column.
>
> Can I find the program, that is being executed(here it is export) from
> any table?

Exactly what problem are you trying to solve? If you want to find out, for example, if a regularly scheduled export is running, and if for some reason the program column is not being populated in v$session, you could create a username that would only be used for the export, and then check for sessions under that username. Received on Mon Oct 22 2001 - 12:20:05 CDT