Message-Id: <22528.293422@fatcity.com> From: Ofer Harel Date: Wed, 11 Sep 2002 08:56:24 +0200 Subject: RE: View Locks 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@barak013.net.il -----Original Message----- From: cosltemp-g.manoj@orbitech.co.in [mailto:cosltemp-g.manoj@orbitech.co.in] Sent: Wednesday, September 11, 2002 8:08 AM To: Multiple recipients of list ORACLE-L Subject: View Locks 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.