Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Question re dbms_monitor

Re: Question re dbms_monitor

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Thu, 13 Sep 2007 08:13:59 +0100
Message-ID: <7765c8970709130013w252c9948lf595c24f3335fdfb@mail.gmail.com>


Hi, I'd love to have that sort of problem! The package does work on it's own (tested 10.2 ). In general you'll want to warn them about large numbers or size of trace files. Watch DBA_ENABLED_TRACES. In 10.2 there is DATABASE_TRACE_ENABLE which must've been added as a way of filling filesystems really fast. Other than that I'd say you should look after that developer well oh and point out DBMS_APPLICATION_INFO as well.

On 13/09/2007, William Wagman <wjwagman_at_ucdavis.edu> wrote:
> Greetings,
>
> Running 10.2.0.3.0 Standard Edition on RHEL3. One of the developers has
> requested access to the DBMS_MONITOR package. I'm just wondering about
> the pros and cons of granting such access. And is granting execute on
> the DBMS_MONITOR package sufficient or are other privileges necessary to
> get full use out of it?
>
> Thanks.
>
> Bill Wagman
> Univ. of California at Davis
> IET Campus Data Center
> wjwagman_at_ucdavis.edu
> (530) 754-6208
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Sep 13 2007 - 02:13:59 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US