Query to check all the schemas and their sizes
select OWNER,sum(bytes)/1024/1024/1000 “SIZE_IN_GB” from dba_segments group by owner order by owner;
Related blogs
Database Blog
Query to Identify Initial and Latest Login Sessions in Oracle Database
Please use the query below to identify and provide the SID and Serial#. col first_seen for a30 col last_seen for a30 SELECT MIN(sample_time) AS first_see…
Database Blog
Steps to Renew Default OHS Keystore Wallet in Oracle Enterprise Manager (OEM)
Please follow the below steps. Prerequisites Take a backup of the existing wallet. Ensure you have appropriate Oracle user privileges. Verify OMS…
Database Blog
How to Unlock Locked SQL Server Logins
How to Unlock Locked SQL Server Logins Introduction / Issue During day-to-day SQL Server administration, users may report that they are unable to connect to the…