Re: Oracle 10 admin question
From: <rogergorden_at_....gmail.com>
Date: Mon, 14 Jul 2008 12:27:56 -0700 (PDT)
Message-ID: <79a46190-e8e1-4d76-825b-94d984b2665d@e53g2000hsa.googlegroups.com>
Date: Mon, 14 Jul 2008 12:27:56 -0700 (PDT)
Message-ID: <79a46190-e8e1-4d76-825b-94d984b2665d@e53g2000hsa.googlegroups.com>
On Jul 10, 6:00 pm, MikeHT <mike2..._at_gmail.com> wrote:
> How to get the DB activity report (like sar in UNIX), like number of
> queries, history of queries, % utilization of SGA_TARGET, %
> utilization of CPU, %IO, etc from within Oracle 10.
> Can the info be obtained via sql queries against Oracle admin views? I
> don't have access to OEM.
> Please advise.
> Thanks.
You might look into the dbms_statspack package, and how to run it.
HTH. Roger Gorden Received on Mon Jul 14 2008 - 14:27:56 CDT