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 -> Snapshot too old by gather_schema_stats

Snapshot too old by gather_schema_stats

From: Frederic Mockel <frederic.mockel_at_gillardon.de>
Date: Wed, 7 Aug 2002 14:52:09 +0100
Message-ID: <3d51135f$0$233$4d4ebb8e@businessnews.de.uu.net>


Hi,

i have a database running with three Rollbacksegments each 60 Mbyte big. I import data with an application making a commit all 10 Mbyte data transferred ( i calculated on the first transaction the application made by counting the used pages). when i execute dbms_stats.gather_schema_stats i got immediately an snapshot to old error. But there should be more then 40 Mbyte rollbackspace. And the rbsegs can grow until 8Gbyte but they dont grow.

Whats wrong, where can i take a look ?

Please give me a hint

Freddy Received on Wed Aug 07 2002 - 08:52:09 CDT

Original text of this message

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