How are you going to kill another session without a DBA role?
A command like "grant alter system to public" would certainly
do the trick, but that would create a whole lot of new DBA's and
I'm not an amiable social butterfly. I prefer to be one and only
DBA responsible for the database. One DBA to rule them all, one DBA to
find bugs one DBA to kill sessions in the system room where the
shadows lie.
> -----Original Message-----
> From: Ofer Harel [mailto:oharel_at_barak013.net.il]
> Sent: Wednesday, September 11, 2002 9:58 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: View Locks
>
>
> 1. If you grant DBA role you need no more roles. If you don't
> have DBA role,
> you need SELECT_CATALOG_ROLE role.
> 2. Yes - Kill the holding session or wait.
>
> Ofer
>
> -----Original Message-----
> Sent: Wednesday, September 11, 2002 3:23 PM
> To: Multiple recipients of list ORACLE-L
>
>
> I have a problem with normal users monitoring locks. What are
> they going to
> do with
> the results? Kill the holding session? Reconfigure the number of lock
> elements?
> Having a DBA role is a reasonable condition to run monitoring
> scripts and
> I've never
> had any problems with seeing anything as a DBA.
>
>
>
> On 2002.09.11 02:58 Ofer Harel wrote:
> > There are many scripts written in this forum to monitor
> locks. But, your
> > problem is a permission to see system views.
> > You should add a role SELECT_CATALOG_ROLE and try again.
> >
> > HTH
> > regards
> >
> > Ofer Harel
> > DBA team
> > Barak ITC
> > oharel_at_barak013.net.il
> >
> >
> >
> > -----Original Message-----
> > [mailto:cosltemp-g.manoj_at_orbitech.co.in]
> > Sent: Wednesday, September 11, 2002 8:08 AM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Hi,
> > I want to view locks if any present.
> > But when I say 'select * from v$locked_object'
> > it says 'table or view does not exists'
> > Is any alternative to view locks on tables.
> >
> > Regards,
> > Manoj
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Ofer Harel
> > INET: oharel_at_barak013.net.il
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access /
> Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> >
>
> --
> Mladen Gogala
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Mladen Gogala
> INET: mgogala_at_adelphia.net
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ofer Harel
> INET: oharel_at_barak013.net.il
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
Received on Wed Sep 11 2002 - 09:10:01 CDT
