Re: Many schemas in one db

I don't think the schemas reference each other. The whole point was to keep 'account data separate for auditing purposes'. Don't ask.

We are at ~20,000 objects, once the query returns. Any query looking up info in the data dictionary takes a while, that's what I'm referring to.

The library cache misses is a little out of line - 2% of gets - but as far as library cache latch waits, it's at .7%.
I think I'm OK with the latches.

Gosh you'd think I'd know this stuff off the top of my head - just passed OCP exam 4 today. And how much do I remember? I can't even spell my own name. Here's my other favorite misspelling: LIAS.

Thanks for your response Jared!

Jared Still <jkstill_at_bcbso.com> on 05/15/2000 08:54:20 PM

Please respond to ORACLE-L_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc: (bcc: Lisa Koivu/GELCO)

Subject: 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 jkstill_at_teleport.com - private

--
Author: Jared Still
  INET: jkstill_at_bcbso.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may