Gathering statistics on EM tables
From: Upendra N <nupendra_at_hotmail.com>
Date: Wed, 13 May 2009 03:22:57 -0400
Message-ID: <BLU129-W2345FDB24EF21862B58C94D8610_at_phx.gbl>
Windows Live™: Keep your life in sync.
http://windowslive.com/explore?ocid=TXT_TAGLM_BR_life_in_synch_052009
--
http://www.freelists.org/webpage/oracle-l Received on Wed May 13 2009 - 02:22:57 CDT
Date: Wed, 13 May 2009 03:22:57 -0400
Message-ID: <BLU129-W2345FDB24EF21862B58C94D8610_at_phx.gbl>
We have Oracle Grid control 10.2.0.2 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?
Thanks
-Upendra
Windows Live™: Keep your life in sync.
http://windowslive.com/explore?ocid=TXT_TAGLM_BR_life_in_synch_052009
--
http://www.freelists.org/webpage/oracle-l Received on Wed May 13 2009 - 02:22:57 CDT