What is the query to find who are the users accessing a table space ?

Code
SELECT * FROM dba_ts_quotas;

suppose if we are in need of the users connected to a tablespace called abcdata 6the how to findut?

SELECT USERNAME, TABLESPACE_NAME FROM DBA_USERS WHERE TABLESPACE_NAME='ABCDATA';

this will display the users connected to the tablespace abcdata.

select username,default tablespace,temporary tablespace from dba_users;

This query executes only if following queries is run in mount stage
1. @ $ORACLE_HOME/rdbms/admin/catalog.sql
2. @ $ORACLE_HOME/rdbms/admin/catproc.sql
3 connect system/manager
@ $ORACLE_HOME/sqlplus/admin/pupbld.sql

  1 User has rated as useful.

  

Login to rate this answer.