Re: Oracle Dynamic Performance views questions
From: <sharmp_at_hhcs.gov.au>
Date: 27 Jan 93 12:03:57 +1100
Message-ID: <1993Jan27.120358.600_at_hhcs.gov.au>
Date: 27 Jan 93 12:03:57 +1100
Message-ID: <1993Jan27.120358.600_at_hhcs.gov.au>
In article <1993Jan20.222718.3562_at_cmutual.com.au>, btc_at_cmutual.com.au (Tony Cook) writes:
> Does anyone know what the values for the column 'command' in the view
> v$session actually mean ?
>
> Sqldba shows UPDATE and SELECT when you are looking at the table access screen
> but I would like to know what are all the valid values and what they mean.
>
Stuff deleted
>
> I would appreciate any help you may be able to give.
>
> Thanks,
> Tony
>
> --
> Tony Cook Email: TCook_at_cmutual.com.au
> Systems Analyst/Programmer Phone: +61-3-6418449
> Colonial Mutual Investment Management Fax : +61-3-6076198
-- Can't help you with the lock information, but we had to find out what the values in the COMMAND column meant as well. All the values are actually in CATALOG.SQL as a series of inserts into the AUDIT_ACTION table. Let me know if you don't have this script, and I'll put up the values for you. Regards Peter ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Peter Sharman SHARMP_at_HHCS.GOV.AU Aust. Dept Health, Housing and Community Services 06-289 7661 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~Received on Wed Jan 27 1993 - 02:03:57 CET