Re: SQL*DBA Monitor question
Date: 1995/08/11
Message-ID: <40frgu$nh3_at_newsbf02.news.aol.com>#1/1
In article <40dvb5$opa_at_spruce.citicorp.com>, Melisa Mrazik <mmrazik> writes:
>Subject: SQL*DBA Monitor question
>From: Melisa Mrazik <mmrazik>
>Date: 10 Aug 1995 21:56:53 GMT
>
>I am currently assisting a group in our facility by tracking their
row/table
>locks using SQL*DBA Monitor. Since we are trying to get as detailed as
>possible of information from this, I am trying to figure out what the
columns
>'Resource ID1' and 'Resource ID2' mean. The Oracle Utilities User's
Guide
>conveniently describes only the Mode Held and Mode Requested columns
leaving
>me
>in the dark.
>Can anyone help me decipher this information?
>
>TIA,
>Melisa
Resource ID1 you can get from dba_objects - when resource ID2 is null.
When
both are in one lock monitor row I have no idea what they mean...
Chris Kasten
Opinions? Mine Mine Mine Mine all Mine! Received on Fri Aug 11 1995 - 00:00:00 CEST