select "INSTANCE_NUMBER","INSTANCE_NAME","HOST_NAME","VERSION","STARTUP_TIME","STATUS","PARALLEL","THREAD#","ARCHIVER","LOG_SWITCH_WAIT","LOGINS","SHUTDOWN_PENDING","DATABASE_STATUS","INSTANCE_ROLE","ACTIVE_STATE","BLOCKED","CON_ID","INSTANCE_MODE","EDITION","FAMILY" from v$instance
SELECT "INSTANCE_NUMBER"
, "INSTANCE_NAME"
, "HOST_NAME"
, "VERSION"
, "STARTUP_TIME"
, "STATUS"
, "PARALLEL"
, "THREAD#"
, "ARCHIVER"
, "LOG_SWITCH_WAIT"
, "LOGINS"
, "SHUTDOWN_PENDING"
, "DATABASE_STATUS"
, "INSTANCE_ROLE"
, "ACTIVE_STATE"
, "BLOCKED"
, "CON_ID"
, "INSTANCE_MODE"
, "EDITION"
, "FAMILY"
FROM V$INSTANCE
|
|
|