Alternate option for v$lock is DBA_LOCKS

[email protected]
Newsgroups gmane.comp.db.oracle.toad.free
Message-ID <OFD42307BE.8693DC4B-ON65257A39.00403814-65257A39.0040A60B@tcs.com>
Hi,

My DBA says we must not use v$lock and find an alternative option for it.

I found that dba_locks is an alternate option for v$lock in Oracle.

But when i use "select  *  from dba_locks". It throws an error message 
"ORA00942 Table or View does not exists."

Could you please tell me what i am missing.

Also can u tell me what privilege i need to give such that dba_locks can 
be selected for the records using my login to the oracle DB.

Regards,

Nirubama Ananthasairam
Tata Consultancy Services
Mailto: [email protected]
Website: http://www.tcs.com
____________________________________________
Experience certainty.   IT Services
                        Business Solutions
                        Outsourcing
____________________________________________
=====-----=====-----=====
Notice: The information contained in this e-mail
message and/or attachments to it may contain 
confidential or privileged information. If you are 
not the intended recipient, any dissemination, use, 
review, distribution, printing or copying of the 
information contained in this e-mail message 
and/or attachments to it are strictly prohibited. If 
you have received this communication in error, 
please notify us by reply e-mail or telephone and 
immediately and permanently delete the message 
and any attachments. Thank you
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.