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 > [EMAIL PROTECTED] > > > > -----Original Message----- > [mailto:[EMAIL PROTECTED]] > 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).