Re: concurrency on a table

From: Chris Weiss <chris_at_www.hpdbe.com>
Date: Wed, 23 Jan 2002 13:27:09 -0500
Message-ID: <a2mue3$p7c$1@msunews.cl.msu.edu>

If you query the oracle meta data, you can see what SQL has been executed and the frequency of access. If you are looking for a particular table:

SELECT SUM(EXECUTIONS) FROM V$SQLAREA WHERE SQL_TEXT LIKE '%<TABLE>%';

This query will be ****slow**** so be careful when you run it depending on your system load.

Good Luck!

--

~~~~~~~~~~~~~~~~
Chris Weiss
www.hpdbe.com
High Performance Database Engineering
~~~~~~~~~~~~~~~~


"Ed Lufker" <elufker_at_shimi.swcp.com> wrote in message
news:a2mqrf$sjq$1_at_iruka.swcp.com...


> Hi All:

>

> Is there a command that will allow me to show how many user access a

> table. Is table concurrency the right term to use??

>

> Thanks in advance for any help here.

> Eddie Lufker

>

>

Received on Wed Jan 23 2002 - 12:27:09 CST