Re[2]: snapshots

From: <dgoulet_at_vicr.com>
Date: Mon, 15 Jan 2001 08:50:22 -0500
Message-Id: <10742.126662@fatcity.com>

James,

Rowid's are not included in snapshots unless specifically specified in the create snapshot statement with the "with rowid" qualifier. With primary key is the default.

Dick Goulet

____________________Reply Separator____________________

Subject: Re: snapshots
Author: james ellis <jellis24_gso_at_yahoo.com> Date: 1/12/2001 2:16 PM

Dennis,

I would think since the snap$ table has the rowid value that when a delete needs to be performed it would delete using the rowid.

James
--- Dennis Taylor <ismgr_at_pctc.com> wrote:
> At 10:06 AM 1/12/01 -0800, you 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?
>
> The mlog$ table only contains a couple of fields,
> one of which is the ROWID
> of the affected record, and another is the dml
> operation (insert, delete,
> update). I'd assume that the snapshot update uses
> this info to go get the
> affected record (unless it's a delete) from the base
> table.
>
> This is weird when you think of it. It implies that
> the snapshot process is
> able to get "old" information, i.e. the record from
> before the delete, so
> that it can grab the PK info. Or am I missing
> something?
>
>
> Dennis Taylor
> --------------------------------
> Save the plankton - nuke the whales!
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Dennis Taylor
> INET: ismgr_at_pctc.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! http://photos.yahoo.com/

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: james ellis
  INET: jellis24_gso_at_yahoo.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

Received on Mon Jan 15 2001 - 07:50:22 CST