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>


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

Original text of this message