Maybe do some shared pool tuning to size the dictionary cache.
"Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in message
news:jlvM9.6746$jM5.19160_at_newsfeeds.bigpond.com...
> I'd have to question any design for a database that requires half a
million
> tables. Point of fact, I can't imagine any circumstances when that number
of
> tables would be required.
>
> So go on, enlighten me!
>
> But no, the number of tables should not in and of itself make any
> discernible impact on performance. But the bodgy design that requires that
> many tables will inevitably cause grief, big time.
>
> Regards
> HJR
>
> "Massis Isagholian" <massis_at_att.com> wrote in message
> news:totM9.4801$p_6.376353_at_bgtnsc04-news.ops.worldnet.att.net...
> > Does a large number of tables (say 500,000) in an Oracle database affect
> > performance? If so, what exaclty is affected?
> >
> > Thanks,
> > Massis
> >
> >
> >
>
>
Received on Thu Dec 19 2002 - 21:33:39 CST
