Re: concurrency on a table

Ed Lufker wrote:

> 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
>
>
>

Strange question - in an Oracle database readers dont block writers and vise versa.
What time frame are you targeting? Since instance start, right now? If it is the later, you might try with v_$open_cursors and join that against v_$session or v_$sqlarea or v_$sqltext or the like. Or try v_$bh and obj$, tab$, user$. Depends - what do you look for? If you are running pl*sql and the cursors are not closed properly, you will get to high figures. If you only run pure sql, then that's not likely to be the case.

/Svend Jensen Received on Wed Jan 23 2002 - 12:37:16 CST