Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: v$transaction.cr_gets
DA Morgan wrote:
> Chuck wrote:
>> 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.
They were already posted. In fact it was a direct quote from that exact search you're suggesing I run.
If you don't want to answer the question then don't but please stop trolling. In the mean time I'll take the question somewhere else where folks understand how a consistent get is done (i.e. that it can involve undo segments) and post the answer here for anyone else who may have the same question and stumble on this thread. Received on Thu Jul 05 2007 - 13:38:53 CDT
![]() |
![]() |