Re: How many is too many

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Mon, 15 Aug 2011 15:28:44 +0100
Message-ID: <CABe10sa6Qt1U7qTzNSXaivCE19SvLqZveu5pn+ONyHNanGi1VQ_at_mail.gmail.com>

mostly only a small percentage get used. Eg we have an apps client with 22k tables, but only 418 tables have more than 1000 rows in them - very poor proxy for commonly used tables.

On Mon, Aug 15, 2011 at 2:57 PM, Guillermo Alan Bort <cicciuxdba_at_gmail.com>wrote:

> 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 ...
>>>
>>>
>>
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

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

Received on Mon Aug 15 2011 - 09:28:44 CDT