Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: View Locks

RE: View Locks

From: Ofer Harel <oharel_at_barak013.net.il>
Date: Wed, 11 Sep 2002 08:56:24 +0200
Message-Id: <22528.293422@fatcity.com>


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-----
From: cosltemp-g.manoj_at_orbitech.co.in
[mailto:cosltemp-g.manoj_at_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. Received on Wed Sep 11 2002 - 01:56:24 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US