Re: v$session.command

From: Paul Osborn <posborn_at_menlosoftware.com>
Date: 1997/12/08
Message-ID: <348C5262.569448D0@menlosoftware.com>#1/1

This is a multi-part message in MIME format.

--------------F91839CD9E2E6CDDA7E49A5E
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Sameer Utrankar wrote:

> What's the deal with v$session.command column ? This column is supposed
> to contain a number for currently active command (name for which can be
> found from audit_actions table). I have seen values in this column
> before - not sure when I stopped seeing values in this column - I mean
> after which upgrade.. Now I am on 733 on Sun and values in this column
> are always 0 for all processes, no matter what the users are doing. Does
> anybody have any idea what it could be ?
>
> I do know how to get the full sql text out from v$sqlarea, v$sqltext,
> v$open_cursor but this v$session.command column was handy to glance at
> what all people are doing when there are dozens are users and when you
> don't care about the sql details but just want a feel for kind of
> activity against the database by glancing through commands being
> executed.
>

Sameer:

On my site: http://www.menlosoftware.com you'll find a query that will return a list of all user, the SQL statement they are currently running, and some other information.

Paul

> Anyone ?
>
> ----------------------------------------------------
> Sameer Utrankar
> sameeru_at_exchange.ml.com
> 212-449-1762

--------------F91839CD9E2E6CDDA7E49A5E
Content-Type: text/x-vcard; charset=us-ascii; name="vcard.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Osborn, Paul
Content-Disposition: attachment; filename="vcard.vcf"

begin:          vcard
fn:             Paul Osborn
n:              Osborn;Paul
org:            Menlo Software
adr:            744 College Avenue;;;Menlo Park;CA;94025-5204;US
email;internet: posborn_at_menlosoftware.com
title:          Founder
tel;work:       650.324.1286
tel;fax:        650.324.1287

x-mozilla-cpt: ;0
x-mozilla-html: FALSE

version:        2.1
end:            vcard

--------------F91839CD9E2E6CDDA7E49A5E-- Received on Mon Dec 08 1997 - 00:00:00 CST