System & Database Related Solutions

Execute the following query and find out the Database session SQL> select a.spid server, b.process client, b.username,b.status from v...

Following query find the user who is lock since last 120 second and locked by whom SELECT SUBSTR(TO_CHAR( w . session_id ), 1 , 5 ) WS...