<dominica_at_gmail.com> wrote in message
news:1111709564.306462.279430_at_g14g2000cwa.googlegroups.com...
> Hi All,
>
>
> I inherit this production database from someone.
> I need to find out a table's last access time-stamp?
> Whether it is READ or WRITE?
>
> Let me tell you what I am trying to archieve.
>
> I have a few obsolete schemas(users) that I need to drop.
> And I already have some monitoring script to
> monitor the i/o from V$datafile, like which
> datafile has read and write at when.
>
> But now I know certain datafile(belong to some tablespace)
> get access. Since these suppose to be obsolete, I saw
> very few I/O traffic to the datafile.
>
> But I want to narrow down to exactly which table is being access.
> I am trying to look around to see which table could tell me?
>
> I don't think I could use dba_segments or dba_objects??
>
>
> Or I am trying to look V$SQLAREA or V$SQLTEXT to see
> which SQL is execute... on those obsolete schema?
>
>
>
> Thanks in advance,
>
>
> Dominica
>
Turn on auditing.
Jim
Received on Fri Mar 25 2005 - 09:04:36 CST
