Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> snapshots

snapshots

From: <Babu.Nagarajan_at_Cummins.com>
Date: Fri, 12 Jan 2001 13:07:31 -0500
Message-Id: <10739.126535@fatcity.com>


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 Received on Fri Jan 12 2001 - 12:07:31 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US