Query the Autonomous Data Warehouse System Tables as ADMIN

Verify proper configuration of your Autonomous Data Warehouse connection by running a sample query.

  1. Sign in to Database Actions as ADMIN.
  2. On the Development tab, click the SQL label to open SQL Developer Web.
  3. Run this query to verify proper configuration:
    select sum(bytes)/1024/1024/1024/1024 as USED_STORAGE_TB from dba_segments
      where owner not in ('SSB', 'SH');