Oracle 10 admin question
From: MikeHT <mike2.li_at_gmail.com>
Date: Thu, 10 Jul 2008 15:00:51 -0700 (PDT)
Message-ID: <a229d6c1-7f96-4282-83bf-0d23ddd29470@8g2000hse.googlegroups.com>
Date: Thu, 10 Jul 2008 15:00:51 -0700 (PDT)
Message-ID: <a229d6c1-7f96-4282-83bf-0d23ddd29470@8g2000hse.googlegroups.com>
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.
Received on Thu Jul 10 2008 - 17:00:51 CDT