Re: Snapshot too old by gather_schema_stats

Hi,
thanks for the answers, but it's not the real thing i wonder. I changed my testenvironment so i get the same error. But in the test environment i get it after 30 seconds. But at the other machine i got it **immediately** after starting the package. and i dont know why i got such a quick response.

Freddy

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> schrieb im Newsbeitrag news:ul2qq6o0i2ua40_at_corp.supernews.com...
>
> "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
>
>
>
Received on Thu Aug 08 2002 - 04:10:06 CDT