Path: news.easynews.com!easynews!crtntx1-snh1.gtei.net!nycmny1-snh1.gtei.net!news.gtei.net!newsfeed.mathworks.com!oleane.net!oleane!bnewspeer00.bru.ops.eu.uu.net!bnewspost00.bru.ops.eu.uu.net!emea.uu.net!businessnews.de.uu.net!not-for-mail From: "Frederic Mockel" Newsgroups: comp.databases.oracle.server References: <3d51135f$0$233$4d4ebb8e@businessnews.de.uu.net> Subject: Re: Snapshot too old by gather_schema_stats Date: Thu, 8 Aug 2002 10:10:06 +0100 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 Lines: 55 Message-ID: <3d5222c3$0$223$4d4ebb8e@businessnews.de.uu.net> NNTP-Posting-Host: 194.175.100.4 X-Trace: 1028793027 businessnews.de.uu.net 223 194.175.100.4 X-Complaints-To: abuse@de.uu.net Xref: easynews comp.databases.oracle.server:157239 X-Received-Date: Thu, 08 Aug 2002 00:47:43 MST (news.easynews.com) 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" schrieb im Newsbeitrag news:ul2qq6o0i2ua40@corp.supernews.com... > > "Frederic Mockel" wrote in message > news: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 > > > > > > > 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 > > >