Re: Many schemas in one db

On Mon, 15 May 2000 Lisa_Koivu_at_gelco.com wrote:

> Hello -
>
> Has anyone seen a database with a large number of schemas? I have one database
> here with 60 schemas, each owning between 240-650 objects. querying the data
> dictionary on this database is no easy proposition, it takes a long time.
> However, no one has complained about performance. I am wondering if there's any
> unwritten rule about how many schemas can coexist nicely in a database. Anyone
> have any experience with this?

One question that needs asked is 'How many of these schema reference other schemas in the same database?'

Moving those to separate databases would cause a performance hit, possibly a big one.

So you have 24,000 or so objects? I believe some of the big ERP apps are comparable.

When you say it takes a long time to query the entire data dictionary, do you mean the entire thing, or just looking up data on a few objects?

Do you have a lot of library cache latch waits? It doesn't sound like you do, or someone would have complained.

> Thanks
> Lsia

Isn't that spelled 'Lisa' ?

Jared Still
Certified Oracle DBA and Part Time Perl Evangelist ;-) Regence BlueCross BlueShield of Oregon
jkstill_at_bcbso.com - Work - preferred address Received on Mon May 15 2000 - 19:38:41 CDT