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 Output …

Retrieving User Role Privileges in Oracle using the view dba_role_privs This page examines an Oracle SQL code snippet that fetches granted roles and their associated admin options for a specified user. SQL Code 1select grantee 2, granted_role 3, admin_option 4from dba_role_privs 5where grantee like upper('&username') …

Lock or Unlock an Oracle User in the Database A brief guide on locking user accounts using the alter user <username> account lock; command, including its purpose, key points, and best practices. Lock User SQL Code 1alter user <username> account lock; 2/ Unlock User SQL Code 1alter user <username> account unlock; 2/ …

Show latent parameter changes Analyzing Modified Oracle Database Parameters for Insights and Optimization Uncover configuration customizations, potential performance bottlenecks, and security considerations by examining modified initialization parameters in Oracle Database. SQL Code 1select name 2, value 3from …