Re: How many is too many
- From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
- To: Guillermo Alan Bort <cicciuxdba@xxxxxxxxx>
- Date: Mon, 15 Aug 2011 15:28:44 +0100
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@xxxxxxxxx>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@xxxxxxxxx> 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@xxxxxxxxx>
>>
>>> That's a relatively common table count for ERP ( SAP, EBIZ, peoplesoft
>>> &c)
>>>
>>> On 15 Aug 2011 08:19, "Pavel" <ocp.pauler@xxxxxxxxx> wrote:
>>>
>>> Hi
>>> Could you please tell me what system have 70000 tables?(retail or
>>> something else?)
>>>
>>> Regards,
>>> Pavel.
>>>
>>>
>>>
>>> 2011/8/12 Ram Raman <veeeraman@xxxxxxxxx>
>>> >
>>> > Toon
>>> >
>>> > You are correct. There are about 70,000 ...
>>>
>>>
>>
>
--
Niall Litchfield
Oracle DBA
http://www.orawin.info
Other related posts:
