OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » tablespace used by?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

tablespace used by? [message #172838]

Thu, 18 May 2006 04:37

nani_ar
Messages: 58
Registered: March 2006

Member

hi all,

can anybody tell me who are the users using the particular tablespace x?....i.e i would like to know all the users using a particular tablespace or the objects lying in the tablespace....

With regards

nani

Report message to a moderator

Re: tablespace used by? [message #172839 is a reply to message #172838]

Thu, 18 May 2006 04:40

Frank Naude
Messages: 4580
Registered: April 1998

Senior Member

Try:

SELECT DISTINCT owner FROM dba_segments WHERE tablespace_name = 'USERS';

and

SELECT DISTINCT owner, segment_type, segment_name
  FROM dba_segments
 WHERE tablespace_name = 'USERS'
/

Report message to a moderator

Re: tablespace used by? [message #172853 is a reply to message #172839]

Thu, 18 May 2006 06:34

nani_ar
Messages: 58
Registered: March 2006

Member

hi,
tx for the reply..

may be my question was not right...actually i would like to know whether anybody is using the tablespace right now....i.e any transcations are going on in the tablespace at this moment.? if so, how to find out?

Plz help me out..

Report message to a moderator

Re: tablespace used by? [message #172904 is a reply to message #172838]

Thu, 18 May 2006 09:58

smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida

Senior Member

I believe statspack snapshots have an option to indicate segment / tablespace / file activity.

Report message to a moderator

Previous Topic:	Error in using dbms_stats
Next Topic:	DB buffer

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 12:44:02 CDT 2024