Re: Grid Control and one database cpu usage
- From: Karl Arao <karlarao@xxxxxxxxx>
- To: cemail_219@xxxxxxxxxxx
- Date: Fri, 3 Sep 2010 02:49:26 +0800
It's also interesting to see and analyze the quartile placement (on text),
frequency distribution (on image), as well as plotting the data in a time
series manner.
Because you'll discover important factors let's say peak periods that may
affect your capacity planning on the server.
On Fri, Sep 3, 2010 at 1:42 AM, Karl Arao <karlarao@xxxxxxxxx> wrote:
>
> You can use my script that is mentioned here
> http://karlarao.wordpress.com/2010/01/31/workload-characterization-using-dba_hist-tables-and-ksar/
> ,
> that's on the instance level so if you are running RAC you should also run
> it on the other nodes. If you want to have just the certain period you can
> edit the script to filter on particular workload periods .. example.. every
> Mon-Fri, 9am-6pm
>
> Take note that this uses AWR, but you can also do the same on Statspack.
>
> Also to be statistical about the data points you could check my example
> here http://karlarao.tiddlyspot.com/#dbms_stat_funcs which you could make
> use of the Oracle statistical functions
>
>
> <http://karlarao.wordpress.com/2010/01/31/workload-characterization-using-dba_hist-tables-and-ksar/>
>
> --
> Karl Arao
> karlarao.wordpress.com
> karlarao.tiddlyspot.com
>
--
Karl Arao
karlarao.wordpress.com
karlarao.tiddlyspot.com
Other related posts:
