Gathering statistics on EM tables

From: Upendra N <>
Date: Wed, 13 May 2009 03:22:57 -0400
Message-ID: <BLU129-W2345FDB24EF21862B58C94D8610_at_phx.gbl>

We have Oracle Grid control on solaris 10. Some of the custom written reports are eating up quite a bit of CPU cycles (tables are not large). The issue seems to be incorrect query plan. Do we need to anything special on gathering schema/object statistics? I am thinking of gathering statistics once a week for the entire schema. Any suggestions?


Windows Live™: Keep your life in sync.
-- Received on Wed May 13 2009 - 02:22:57 CDT

Original text of this message