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

Questions by Chivalrous Man

Showing Answers 1 - 7 of 7 Answers

vinodraj

  • Jul 15th, 2011
 

Code
  1. SELECT * FROM dba_ts_quotas;

-1 identicates the user has quota unlimited.

  Was this answer useful?  Yes

Rajashekar

  • Sep 5th, 2011
 

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.

  Was this answer useful?  Yes

Sharfuddin

  • Sep 29th, 2011
 

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

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions