#ctime oracle

[sandeep2363]

Find the blocking sessions, objects and sql in Oracle

Find the blocking sessions that were blocking shows objects and SQL SELECT S.SID, p.SPID, s.machine, s.username, CTIME/60 as minutes_locking , do.object_name as locked_object, q.sql_Text From v$lock l JOIN v$session s on l.sid=s.sid JOIN v$process p on p.addr=s.paddr JOIN v$locked_object lo on l.sid=lo.session_id JOIN dba_objects do on lo.object_id = do.object_id JOIN v$sqlarea q on…

[ocptechnology]

How to Check Last Password Change History?

How to Check Last Password Change History? #oracledba #oracle #shripaldba #ocptechnology

In this article, we are going to learn how to check past password change history in the oracle database. Using the below commands you can check the password change history step by step. Read: What is control file and datafile in Oracle? When was my Oracle password last changed? The below query will show you the timestamp of last password change. Here i’m checking SCOTT user password change…

[sandeep2363]

User creation details in user$ table

User creation details in user$ table

Check User creation date/Password change/Expire time in Oracle Check User Creation Date in Oracle SELECT NAME, type#, ctime FROM sys.user$ WHERE NAME IN ('SYS', 'SYSTEM') ORDER BY NAME; Check User last password change time in Oracle SELECT NAME, type#, ptime FROM sys.user$ WHERE NAME IN ('SYS', 'SYSTEM') ORDER BY NAME; Check User Password Expiry Date SELECT NAME, type#, EXPTIME FROM…