You are not, but you can call his highness and then HE can kill the sessions.
Yechiel Adar Mehish ----- Original Message ----- To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Wednesday, September 11, 2002 5:13 PM > 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:[EMAIL PROTECTED]] > > 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 > > > [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). > > -- > > 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). > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Gogala, Mladen > 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar 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).
