DA Morgan wrote:
> Chuck wrote:
>> sybrandb_at_hccnet.nl wrote:
>>> On Fri, 29 Jun 2007 18:05:07 GMT, Chuck
>>> <skilover_nospam_at_bluebottle.com> wrote:
>>>
>>>> What exactly does this column represent? The docs simply say
>>>> 'Consistent
>>>> gets'. Is it all consistent gets for the transaction? Or is it just
>>>> gets
>>>> that required rolling back a change from the undo segment listed in the
>>>> xidusn column?
>>>
>>> Please read up on what consistent gets are.
>>>
>> Please reread the question. Your smug answers are not helpful.
>
> Before you jump on Sybrand you might want to spend the 10-15
> seconds required to look up the definition of "consistent gets"
> in the Oracle docs. It really is self-explanatory and there
> really is nothing smug or unhelpful about Sybrand's response.
> It is not his, or anyone else's, responsibility to do your
> tahiti search for you. You were pointed to the correct answer
> and it couldn't be more straight-forward unless English is not
> a language with which you are comfortable.
I already know what consistent gets are. They are blocks read in
consistent mode - which means they may or may not have required reading
an undo block to construct a read-consistent view of the data. So once
again back to my question - Are the consistent gets referenced in
v$transaction all consistent gets for the transaction, or are they just
the ones needed to be rolled back from the undo segment also referenced
on the same row of v$transaction. The Oracle documentation on this
column - which I did read - is extremely lacking.
Received on Thu Jul 05 2007 - 09:13:08 CDT
