Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Query for active tablespaces
On 10 Oct, 15:08, Chuck <skilover_nos..._at_bluebottle.com> wrote:
> Does anyone have a query to show which tablespaces are currently being
> used by a session? What I'm using now is pretty basic and I don't think
> it will work if any of the segments are partitioned.
>
> The oracle version is 9.2. Here's the query I'm using now.
>
> SELECT DISTINCT s.tablespace_name
> FROM v$access a, dba_segments s, v$session sx
> WHERE
> /* joins */
> s.owner = a.owner
> AND s.segment_name = a.OBJECT
> AND s.segment_type = a.TYPE
> AND a.SID = sx.SID
> /* filters */
> AND sx.status = 'ACTIVE';
>
> TIA
Erm... why?
Received on Tue Oct 16 2007 - 07:55:06 CDT