Re: View Locks

2002-09-12 Thread Yechiel Adar
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

RE: View Locks

2002-09-12 Thread Mark Leith
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

RE: View Locks

2002-09-11 Thread Ofer Harel
]] 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

RE: View Locks

2002-09-11 Thread Magaliff, Bill
v$lock -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 11, 2002 2: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

Re: View Locks

2002-09-11 Thread Mladen Gogala
] -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

RE: View Locks

2002-09-11 Thread Ofer Harel
- [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

RE: Re: View Locks

2002-09-11 Thread Stephane Faroult
I have a problem with normal users monitoring locks. Do you consider developers to be normal users? Given the number of locking problems which you can trace back to the code, I would have no problem in that case. Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ:

RE: View Locks

2002-09-11 Thread Gogala, Mladen
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

RE: Re: View Locks

2002-09-11 Thread Gogala, Mladen
: RE: Re: View Locks I have a problem with normal users monitoring locks. Do you consider developers to be normal users? Given the number of locking problems which you can trace back to the code, I would have no problem in that case. Regards, Stephane Faroult Oriole

RE: Re: View Locks

2002-09-11 Thread Naveen Nahata
users and Al Quaida members are not normal members of society. Both are very dangerous. -Original Message- From: Stephane Faroult [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 11, 2002 11:09 AM To: Multiple recipients of list ORACLE-L Subject: RE: Re: View Locks I have

RE: Re: View Locks

2002-09-11 Thread Magaliff, Bill
, September 11, 2002 11:09 AM To: Multiple recipients of list ORACLE-L Subject: RE: Re: View Locks I have a problem with normal users monitoring locks. Do you consider developers to be normal users? Given the number of locking problems which you can trace back to the code, I would

RE: Re: View Locks

2002-09-11 Thread Gogala, Mladen
To: Multiple recipients of list ORACLE-L Subject: RE: Re: View Locks Please don't use wrong words like these for the Al Qaida members, you risk termed an 'infidel' and getting your house attacked by a suicide bomber :-) -Original Message- Sent: Wednesday, September 11, 2002 9:44 PM

RE: Re: View Locks

2002-09-11 Thread DENNIS WILLIAMS
, September 11, 2002 12:30 PM To: Multiple recipients of list ORACLE-L Subject: RE: Re: View Locks Please don't use wrong words like these for the Al Qaida members, you risk termed an 'infidel' and getting your house attacked by a suicide bomber :-) -Original Message- Sent: Wednesday

OT: RE: Re: View Locks

2002-09-11 Thread Gogala, Mladen
their databases. -Original Message- From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 11, 2002 2:59 PM To: Multiple recipients of list ORACLE-L Subject: RE: Re: View Locks Mladen - Reminds me of the book The Difference between God and Larry Ellison. Good book

RE: Re: View Locks

2002-09-11 Thread Hand, Michael T
Naveen, Mladen, On almost any other day I could brush off these comments, but not TODAY. Let's think before we type. Mike -Original Message- Sent: Wednesday, September 11, 2002 12:30 PM To: Multiple recipients of list ORACLE-L Please don't use wrong words like these for the Al Qaida

Re: Re: View Locks

2002-09-11 Thread Jared Still
. -Original Message- From: Stephane Faroult [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 11, 2002 11:09 AM To: Multiple recipients of list ORACLE-L Subject: RE: Re: View Locks I have a problem with normal users monitoring locks. Do you consider developers to be normal users

View Locks

2002-09-10 Thread cosltemp-g . manoj
BDY.RTF Description: RTF file