Re: What is the best way to find out which process is updating what table

Interesting.. I want #2..How do I know if logminer is laready installed on my system? If it isn't, I guess I am not going to be able to see what processes update what tables.. I am a unix admin, not a dba with low priv level..

"Gennadiy Shestakov" <sgena_at_optonline.net> wrote in message news:p6aS8.15373$5M2.810527_at_news4.srv.hcvlny.cv.net...
> What did u mean "which process.."
> In Oracle instance DBRW ONLY can write to
> all and any tables.
> If u want know, which session is working with some tables, then this is 2
> questions:
> --1-- what session is updating some table right now?
> U have to use v$sessions and v$sql dynamic views.
> -- 2 -- what session was updating some table during ...?
> U have to use something like LogMiner.
>
> "Gina Lee" <glee_at_aol.com> wrote in message
> news:W41S8.8973$mi.8325_at_news01.bloor.is.net.cable.rogers.com...
> > What is the best way to find out which process is updating what table? I
 am
> > on HPUX 11 and want to figure what processes update which tables during
 our
> > batch runs..
> >
> >
> >
> > thanks
> >
> >
> >
> >
> >
>
>
Received on Thu Jun 27 2002 - 01:17:42 CEST