RE: Alternate option for v$lock is DBA_LOCKS
Martin Gainty <[email protected]>
| Newsgroups | gmane.comp.db.oracle.toad.free |
|---|---|
| Message-ID | <[email protected]> |
Nicht DBA-Zugriff für Menschen aus Indien Martin ______________________________________________ Verzicht und Vertraulichkeitanmerkung Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen. To: [email protected] From: [email protected] Date: Thu, 12 Jul 2012 17:16:21 +0530 Subject: [toad] Alternate option for v$lock is DBA_LOCKS 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