Re: Oracle 10 admin question
Date: Mon, 14 Jul 2008 12:27:56 -0700 (PDT)
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.
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