Oracle alter session set nls_date_format='yyyy/mm/dd hh24:mi:ss'; selectSID,SERIAL#,STATUS,SQL_ID,SQL_EXEC_START,PREV_SQL_ID,PREV_EXEC_START,LOGON_TIMEfrom v$sessionorder by LOGON_TIME; MySQL select * from information_schema.INNODB_TRX ord…