• Home
  • Chivalrous Man Questions

Submitted Questions

  • Apr 08 2011
    09:27 PM
    5346
    7

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

    • Chivalrous Man

    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

    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.