Lisa,
I've worked with systems with >50K objects and haven't
noticed any performance issues accessing the dd.
Someone hasn't analyzed any of SYS's objects by any
chance? If so, delete the stats on them ASAP!
HTH,
- Anita
- Lisa_Koivu_at_gelco.com wrote:
> 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)
>
>
>
>
> 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
> also send the HELP command for other information
> (like subscribing).
>
>
>
>
>
>
> --
> Author:
> INET: Lisa_Koivu_at_gelco.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
> also send the HELP command for other information
> (like subscribing).
Received on Tue May 16 2000 - 17:44:20 CDT
