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