Re: Performace with 500,000 tables

From: M Hashim <m.a.n.hashim_at_sympatico.ca>
Date: Thu, 19 Dec 2002 22:31:50 -0800
Message-ID: <n4wM9.6595$B_6.1408908@news20.bellglobal.com>

Calling AT&T..:)

One would have to examine the actual setup to measure performance. Not knowing what your architecture would look like, performance may not be an issue if you have BIG ASS BOXes.

One item that pops right out with having 500,000 tables is a fairly sizeable data dictionary. Depending on what you are planning to do with the db, this could influence performance.

"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 Fri Dec 20 2002 - 00:31:50 CST