Blog / Database Blog

To check if tablespace is dictionary managed or locally managed

Doyensys 1 min read


select
tablespace_name, extent_management from dba_tablespaces
where
tablespace_name = <Tablespace_name> order by 1

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#. &nbsp; col first_seen for a30 col last_seen for a30 SELECT MIN(sample_time) AS first_see…

Venkatesh GK 1 min read
Database Blog

Steps to Renew Default OHS Keystore Wallet in Oracle Enterprise Manager (OEM)

Please follow the below steps. &nbsp; Prerequisites &nbsp; Take a backup of the existing wallet. Ensure you have appropriate Oracle user privileges. Verify OMS…

Venkatesh GK 1 min read
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…

SaiKumar 3 min read