Complete refreshes bypass the mlog$ table all
together. Fast refreshes only use the mlog$ table to
determine which row in the base table to retrieve,
update,insert or delete in the snap$ table. Therefore
you may see some performance degradation when the
snapshot is firing.
- Babu.Nagarajan_at_Cummins.com wrote:
> hi list
>
> would any refresh of a snapshot fire a query against
> the base table?
>
> i think its supposed to go against the mlog$ table
> of the base table. we
> have a situation where there is a poor-performing
> query that is fired at
> exact intervals accessing the base table and no
> application seems to be
> firing it?
>
> babu
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author:
> INET: Babu.Nagarajan_at_Cummins.com
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
Do You Yahoo!?
Yahoo! Photos - Share your holiday photos online!
Received on Fri Jan 12 2001 - 16:12:35 CST
