Re: What is the best way to find out which process is updating what table
From: Gennadiy Shestakov <sgena_at_optonline.net>
Date: Tue, 25 Jun 2002 22:59:39 -0400
Message-ID: <p6aS8.15373$5M2.810527_at_news4.srv.hcvlny.cv.net>
Date: Tue, 25 Jun 2002 22:59:39 -0400
Message-ID: <p6aS8.15373$5M2.810527_at_news4.srv.hcvlny.cv.net>
What did u mean "which process.."
"Gina Lee" <glee_at_aol.com> wrote in message
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.
> 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 Wed Jun 26 2002 - 04:59:39 CEST