Oracle 10 admin question

From: MikeHT <>
Date: Thu, 10 Jul 2008 15:00:51 -0700 (PDT)
Message-ID: <>

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

Original text of this message