1. Database Reference
  2. Static Data Dictionary Views
  3. Static Data Dictionary Views: DBA_HIST_LATCH to DBA_STORED_SETTINGS
  4. DBA_SQL_FIREWALL_STATUS

6.421 DBA_SQL_FIREWALL_STATUS

DBA_SQL_FIREWALL_STATUS displays the status of SQL Firewall.

Column Datatype NULL Description

STATUS

VARCHAR2(8)

SQL Firewall status (ENABLED or DISABLED)

STATUS_UPDATED_ON

TIMESTAMP(6) WITH TIME ZONE

NOT NULL

Date and time of the most recent SQL Firewall status change

EXCLUDE_JOBS

VARCHAR2(12)

Indicates whether the SQL Firewall will capture or enforce allow-lists for database connections and SQL executions of Oracle scheduler job sessions (Y) or not (N)

Note:

This view is available starting with Oracle Database 23ai.