topic Oracle 10 Admin question in Operating System - HP-UX

Oracle 10 Admin question

Mike_Ca Li — Thu, 10 Jul 2008 01:14:37 GMT

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.

Re: Oracle 10 Admin question

James Brand — Thu, 10 Jul 2008 13:24:08 GMT

Oracle has a tool called "STATSPACK" that has been around since version 8. They released a new tool for Oracle 10G called "AWR" but I believe STATSPACK still works. I'm not a DBA and have never used either tool. I'd suggest searching the Oracle web site for more information.

Re: Oracle 10 Admin question

patrik rybar_1 — Fri, 11 Jul 2008 04:12:42 GMT

you have AWR automaticaly running there
to change it's period of snapshots creation or retention you can do with
exec dbms_workload_repository.modify_snapshot_settings (retention => 7200,interval => 30);

for creating reports (html or text) you can use
on *nix
@?/rdbms/admin/awrrpti.sql
on M$
@?\rdbms\admin\awrrpt.sql

add. info you can find here
http://www.oracle-base.com/articles/10g/AutomaticWorkloadRepository10g.php

Re: Oracle 10 Admin question

Volker Borowski — Sat, 12 Jul 2008 09:21:35 GMT

Hi,

AWR belongs to Oracle Diagnostics.
If you use it, it requires an
"extra cost" license.
Check first if you really want to use it.

As far as I know, statspack still works in 10g and does not require a separate fee for
an additional component.

Volker

Re: Oracle 10 Admin question

TwoProc — Tue, 15 Jul 2008 14:14:45 GMT

Use Statspack, its free, recommended and gives exactly what you're asking for.