• Arun Kumar

Check last user login

While performing database audits, you might need to check who logged in last into the database. The query will help you find out last user who logged in to database.


select username, timestamp, action_name from dba_audit_session 
where action_name='LOGON' and 
rownum<10 and username not in ('SYS','DBSNMP','DUMMY','SYSTEM','RMAN');


257 views

Recent Posts

See All

Generate Table DDL Command

The DBMS_METADATA package allows you to generate DDL commands for any of the database objects inside Oracle database. Generate Table DDL Command Generate View DDL Command Generate Materialized View DD

Temp Tablespace Utilization

It is very common that as a DBA you will encounter ‘ORA-1652: unable to extend temp segment’. Handling temporary tablespace is different than permanent tablespaces inside Oracle. On a high level, temp