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 -> Re: SQL ID with large Version Count encountered

Re: SQL ID with large Version Count encountered

From: Joel Garry <joel-garry_at_home.com>
Date: 18 Apr 2006 15:33:11 -0700
Message-ID: <1145399591.749368.294210@j33g2000cwa.googlegroups.com>


Are the trace files being generated every hour? That could be MMON shooting itself in the foot...

If so, try DBMS_WORKLOAD_REPOSITORY.MODIFY_SNAPSHOT_SETTINGS

jg

-- 
@home.com is bogus.
http://catless.ncl.ac.uk/Risks/24.24.html#subj3
Received on Tue Apr 18 2006 - 17:33:11 CDT

Original text of this message

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