Re: Snapshot too old by gather_schema_stats

"Frederic Mockel" <frederic.mockel_at_gillardon.de> wrote in message news:3d51135f$0$233$4d4ebb8e_at_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
>
>

Check out ora-1555 in the newsgroup archives and on Metalink and increase the number of initial extents and/or the size of the extents in your rollback segments.

Hth

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address