RE: Find which table's data has been changed in last five hours.
- From: "Jiang, Lu" <Lu.Jiang@xxxxxxxxxxxx>
- To: "Adam Musch" <ahmusch@xxxxxxxxx>
- Date: Tue, 4 Aug 2009 10:57:30 -0400
Thanks Adam for the info. I will look into this. It seems that by default
system flush table monitoring info everything 15 minutes automatically, but I
cannot remember it clearly.
Fortunately our issue has been fixed by a new patch, but it is always good to
be well prepared for the worst case :)
-----Original Message-----
From: Adam Musch [mailto:ahmusch@xxxxxxxxx]
Sent: Monday, August 03, 2009 5:31 PM
To: Jiang, Lu
Cc: Julio Aguilar-Chang; ORACLE-L
Subject: Re: Find which table's data has been changed in last five hours.
If the table is being monitored (ALTER TABLE .... MONITORING, which
the default statistics job sets on your behalf) and one executes
dbms_stats.flush_database_monitoring_info, then all the tables which
appear in the
*_TAB_MODIFICATIONS view have had DML or been truncated since the last
time statistics were gathered. If one doesn't run
DBMS_STATS.FLUSH_DATABASE_MONITORING_INFO, the information in the
*_TAB_MODIFICATIONS views can be stale.
On Mon, Aug 3, 2009 at 1:52 PM, Jiang, Lu<Lu.Jiang@xxxxxxxxxxxx> wrote:
> Thanks Julio.
>
> dba_tab_modifications returns no rows with today's timestamp :)
>
>
>
>
>
> From: Julio Aguilar-Chang [mailto:jachang@xxxxxxxx]
> Sent: Monday, August 03, 2009 2:39 PM
>
> To: Jiang, Lu
> Cc: ORACLE-L
> Subject: Re: Find which table's data has been changed in last five hours.
>
>
>
> Try dba_tab_modifications. It has columns such as the table_owner,
> table_name, number of inserts/updates/deletes, and the timestamp.
>
>
>
> Jiang, Lu wrote:
>
> Hi DBA gurus,
>
>
>
> I need to flashback our EBS database to 10 hours ago, also hope the last
> five hours data can be recovered with export/import. Is there a way to find
> which table's/schema's data has been changed in last five hours, so that I
> could export the schemas/tables before flashback and import them after
> flashback?
>
>
>
> Thanks,
>
> Lu
>
> --
>
>
>
> *****************************************
>
> Julio Aguilar-Chang
>
> jachang@xxxxxxxx
>
> (505) 667-1004 - work
>
> *****************************************
--
Adam Musch
ahmusch@xxxxxxxxx
--
//www.freelists.org/webpage/oracle-l
Other related posts:
