Identifying User Tablespaces and Space Usage in Oracle
Feb 4, 2024 · 3 min read · database administration resource optimization performance monitoring data management tablespace dba_extents user space user ·Query to Display All Tablespaces Used by A Specified User and The Total Space Occupied (rounded to MB) Sample SQL Command 1select tablespace_name 2, ceil(sum(bytes) / 1024 / 1024) "MB" 3from dba_extents 4where owner like '&user_id' 5group by tablespace_name 6order by tablespace_name 7/ Sample Oracle …
Read MoreLock or Unlock an Oracle User in the Database Lock User SQL Code 1alter user <username> account lock; 2/ Unlock User SQL Code 1alter user <username> account unlock; 2/ Sample Oracle Output: 1 2no rows selected 3SQL> Purpose: To lock a specific user account in the Oracle database, preventing any further …
Read More