Query to find the queries executed by an user in Oracle
Query to find the queries executed by an user in Oracle SELECT VS.USERNAME , VS.MACHINE , VS.PROGRAM , VS.STATUS , …
Query to find database uptime in Oracle
Query to find database uptime
SELECT host_name
, instance_name
, TO_CHAR(startup_time, 'DD-MM-YYYY HH24:MI:SS') startup_time
, FLOOR(SYSDATE - startup_time) days
FROM sys.v_$instance;
Comments
Related Articles
Query to find service name
This article explains the steps to find the service name of a database running on your local windows machine. Open …