Get database status
get
/database/status
Returns records from GV$INSTANCE and GV$DATABASE. A client requires SQL Administrator role to invoke this service.
Request
There are no request parameters for this operation.
There's no request body for this operation.
Back to TopResponse
Supported Media Types
- application/json
200 Response
Description of the database state.
Root Schema : DatabaseStatusItem
Type:
object
Relying on GV$INSTANCE and GV$DATABASE views this object provides information on the status of the database.
Show Source
-
active_state: string
Quiesce state of the instance.
-
archiver: string
Automatic archiving status.
-
blocked: string
Indicates whether all services are blocked (YES) or not (NO).
-
con_id: integer
The ID of the container to which the data pertains.
-
database_status: string
Status of the database.
-
database_type: string
Database type.
-
db_unique_name: string
Unique database name.
-
edition: string
The edition of the database.
-
host_name: string
Name of the host machine.
-
inst_id: integer
Instance number from which the associated GV$INSTANCE view information was obtained.
-
instance_mode: string
Shows the instance mode of the current instance.
-
instance_name: string
Name of the instance.
-
instance_number: integer
Instance number used for instance registration (corresponds to the INSTANCE_NUMBER initialization parameter).
-
instance_role: string
Indicates whether the instance is an active instance (PRIMARY_INSTANCE) or an inactive secondary instance (SECONDARY_INSTANCE), or UNKNOWN if the instance has been started but not mounted.
-
links: array
links
-
log_switch_wait: string
Event that log switching is waiting for.
-
logins: string
Indicates whether the instance is in unrestricted mode, allowing logins by all users (ALLOWED, or in restricted mode, allowing logins by database administrators only (RESTRICTED).
-
name: string
Name of the database.
-
open_mode: string
Open mode information.
-
parallel: string
Indicates whether the instance is mounted in cluster database mode (YES) or not (NO).
-
shutdown_pending: string
Indicates whether a shutdown is pending (YES) or not (NO).
-
startup_time: string
Time when the instance was started.
-
status: string
Status of the instance.
-
thread#: integer
Redo thread opened by the instance.
-
version: string
Database version.
-
version_full: string
The version string with the new Oracle Database version scheme introduced in Oracle Database 18c.
-
version_legacy: string
The legacy database version used before Oracle Database 18c. This column displays the same value as the VERSION column.