Just an add-on to my previous post. The oracle install wizard for 8.0.5 defaults redo logs to a
size of 1 Mb per log file. This means you will perform at least one checkpoint per 1Mb of redo
data.
"Stephen Ferracioli" <ferracioli_at_101freeway.com> wrote in message
news:JXTEa.417$R21.34571367_at_newssvr15.news.prodigy.com...
> I'd recommend you post a copy of your "init<SID>.ora" file before you reorg.
> Did you install it? Did you use the wizard to install it? If yes, then it's
> more likely that the problem is related to db buffers, shared sql area and
> checkpoint parameters than with the data. The last time I inherited an NT
> install, the database was using less than 12 Mb for the SGA on a box with
> 2Gb of RAM.
>
> "Heiko" <ht_at_bigfoot.de> wrote in message
> news:6ea78$3ee33b26$d4cac0e3$20785_at_nf1.news-service.com...
> > Hi @All!
> >
> > Is there a tool to reorg a Oracle 8 database? Size is 10 GB with > 100
> > tables.
> >
> > Thanks!
> > Heiko
> >
> >
>
>
Received on Mon Jun 09 2003 - 11:53:12 CDT
