Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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 addressReceived on Wed Aug 07 2002 - 13:23:41 CDT