Re: How many is too many

From: Guillermo Alan Bort <cicciuxdba_at_gmail.com>
Date: Mon, 15 Aug 2011 10:57:08 -0300
Message-ID: <CAJ2dSGSsr8sa5TMND6JDQA6E9CTKOFYWO_gvp_EiFabj6pH8sg_at_mail.gmail.com>

wow... I'd like to see a memory report and a couple of AWR reports... I think library cache will either be very big, have a high miss rate or perhaps there are 70k objects but only a small (about 1%?) are used.

this is why I hate "canned" software...
Alan.-

On Mon, Aug 15, 2011 at 4:43 AM, Pavel <ocp.pauler_at_gmail.com> wrote:

> Hi
> Thanks for reply, Niall. And what percent of usage these tables (in
> common)? Didn't work with this count of tables yet . :)
>
> Regards,
> Pavel.
>
>
> 2011/8/15 Niall Litchfield <niall.litchfield_at_gmail.com>
>
>> That's a relatively common table count for ERP ( SAP, EBIZ, peoplesoft &c)
>>
>> On 15 Aug 2011 08:19, "Pavel" <ocp.pauler_at_gmail.com> wrote:
>>
>> Hi
>> Could you please tell me what system have 70000 tables?(retail or
>> something else?)
>>
>> Regards,
>> Pavel.
>>
>>
>>
>> 2011/8/12 Ram Raman <veeeraman_at_gmail.com>
>> >
>> > Toon
>> >
>> > You are correct. There are about 70,000 ...
>>
>>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Aug 15 2011 - 08:57:08 CDT