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

Home -> Community -> Usenet -> c.d.o.server -> Measuring Rollback Usage

Measuring Rollback Usage

From: Greg Stark <greg-spare-1_at_mit.edu>
Date: Fri, 10 Nov 2000 00:28:08 GMT
Message-ID: <877l6czn50.fsf@HSE-MTL-ppp62193.qc.sympatico.ca>

Is there any way to measure how much rollback is being generated by each query, and for each how much of that rollback is actually being read?

The goal here is to maximize the time that useful rollback is kept available by finding queries generating lots of rollback that isn't actually being read, and isolate that rollback in a separate rollback segment.

-- 
greg
Received on Thu Nov 09 2000 - 18:28:08 CST

Original text of this message

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