Oracle 19c SQL query to get all details of instance from gv$instance
Oracle 19c SQL query to get all details of instance from gv$instance
-- Instance Detail (Standalone/ RAC/ Container DB)
SET LINES 300
COLUMN host_name FORMAT A30
ALTER SESSION SET nls_date_format='DD-MON-YYYY HH24:MI:SS';
select inst_id, instance_name, host_name, status, startup_time from gv$instance;