# | DATA$EVENT_NAME | EVENT_TIME | EVENT_TYPE | SOURCE | DATA$IDENTITY$TENANT_ID | DATA$IDENTITY$PRINCIPAL_NAME | DATA$IDENTITY$PRINCIPAL_ID | DATA$IDENTITY$USER_AGENT | DATA$IDENTITY$IP_ADDRESS | DATA$RESPONSE$RESPONSE_TIME | DATA$COMPARTMENT_ID | DATA$COMPARTMENT | DATA$REQ | DATA | DATA$RESOURCE_NAME | DATA$RESOURCE_ID |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 2020-06-22/11:39:21 | com.oraclecloud.DatabaseService.ServiceAPI | DatabaseService | ocid1.tenancy.oc1..000000000000000000000000000000000000000000000000000000000686 | ocid1.saml2idp.oc1..000000000000000000000000000000000000000000000000000000000643/[email protected] | Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/83.0.4103.106 Safari/537.36 | 172.24.112.89 | 2020-06-22T14:39:24.165000+00:00 | PUT | 200 | ||||||
2 | 2020-06-03/10:53:56 | com.oraclecloud.DatabaseService.ServiceAPI | DatabaseService | ocid1.tenancy.oc1..000000000000000000000000000000000000000000000000000000000686 | ocid1.saml2idp.oc1..000000000000000000000000000000000000000000000000000000000643/[email protected] | Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/83.0.4103.61 Safari/537.36 | 172.24.80.107 | 2020-06-03T13:53:56.954000+00:00 | DELETE | 204 | ||||||
3 | TerminateDbSystem | 2020-06-03/10:53:56 | com.oraclecloud.DatabaseService.TerminateDbSystem.begin | DatabaseService | ocid1.tenancy.oc1..000000000000000000000000000000000000000000000000000000000686 | [email protected] | ocid1.saml2idp.oc1..000000000000000000000000000000000000000000000000000000000643/[email protected] | Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/83.0.4103.61 Safari/537.36 | 172.24.96.119 | 2020-06-03T13:53:56.953000+00:00 | ocid1.compartment.oc1..000000000000000000000000000000000000000000000000000000000229 | compt_dev_db | DELETE | 204 | ocidbsystemdemo | ocid1.dbsystem.oc1.iad.000000000000000000000000000000000000000000000000000000000232 |
4 | DbNodeAction | 2020-05-30/19:46:10 | com.oraclecloud.DatabaseService.DbNodeAction.begin | DatabaseService | ocid1.tenancy.oc1..000000000000000000000000000000000000000000000000000000000686 | [email protected] | ocid1.saml2idp.oc1..000000000000000000000000000000000000000000000000000000000643/[email protected] | Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:76.0) Gecko/20100101 Firefox/76.0 | 172.24.96.119 | 2020-05-30T22:46:11.381000+00:00 | ocid1.compartment.oc1..000000000000000000000000000000000000000000000000000000000229 | compt_dev_db | POST | 200 | ocidbsystemdemo | ocid1.dbnode.oc1.iad.000000000000000000000000000000000000000000000000000000000230 |
5 | 2020-05-30/19:46:10 | com.oraclecloud.DatabaseService.ServiceAPI | DatabaseService | ocid1.tenancy.oc1..000000000000000000000000000000000000000000000000000000000686 | ocid1.saml2idp.oc1..000000000000000000000000000000000000000000000000000000000643/[email protected] | Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:76.0) Gecko/20100101 Firefox/76.0 | 172.24.112.89 | 2020-05-30T22:46:11.381000+00:00 | POST | 200 | ||||||
6 | 2020-05-30/00:38:16 | com.oraclecloud.DatabaseService.ServiceAPI | DatabaseService | ocid1.tenancy.oc1..000000000000000000000000000000000000000000000000000000000686 | ocid1.saml2idp.oc1..000000000000000000000000000000000000000000000000000000000643/[email protected] | Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/83.0.4103.61 Safari/537.36 | 172.24.80.107 | 2020-05-30T03:38:16.780000+00:00 | POST | 200 | ||||||
7 | DbNodeAction | 2020-05-30/00:38:16 | com.oraclecloud.DatabaseService.DbNodeAction.begin | DatabaseService | ocid1.tenancy.oc1..000000000000000000000000000000000000000000000000000000000686 | [email protected] | ocid1.saml2idp.oc1..000000000000000000000000000000000000000000000000000000000643/[email protected] | Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/83.0.4103.61 Safari/537.36 | 172.24.96.119 | 2020-05-30T03:38:16.780000+00:00 | ocid1.compartment.oc1..000000000000000000000000000000000000000000000000000000000229 | compt_dev_db | POST | 200 | ocidbsystemdemo | ocid1.dbnode.oc1.iad.000000000000000000000000000000000000000000000000000000000230 |
8 | TerminateDbSystem | 2020-05-30/00:38:05 | com.oraclecloud.DatabaseService.TerminateDbSystem.begin | DatabaseService | ocid1.tenancy.oc1..000000000000000000000000000000000000000000000000000000000686 | [email protected] | ocid1.saml2idp.oc1..000000000000000000000000000000000000000000000000000000000643/[email protected] | Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/83.0.4103.61 Safari/537.36 | 172.24.96.119 | 2020-05-30T03:38:05.661000+00:00 | ocid1.compartment.oc1..000000000000000000000000000000000000000000000000000000000229 | compt_dev_db | DELETE | 204 | ocidbsystem | ocid1.dbsystem.oc1.iad.000000000000000000000000000000000000000000000000000000000231 |
9 | 2020-05-30/00:38:05 | com.oraclecloud.DatabaseService.ServiceAPI | DatabaseService | ocid1.tenancy.oc1..000000000000000000000000000000000000000000000000000000000686 | ocid1.saml2idp.oc1..000000000000000000000000000000000000000000000000000000000643/[email protected] | Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/83.0.4103.61 Safari/537.36 | 172.24.80.107 | 2020-05-30T03:38:05.663000+00:00 | DELETE | 204 |
#: click on a column heading to sort on it
Name Null? Type
----------------------------------------------------------------------------------- -------- --------------------------------------------------------
DATA$REQUEST$ID VARCHAR2(128)
DATA$REQUEST$PATH VARCHAR2(128)
DATA$REQUEST$ACTION VARCHAR2(8)
DATA$IDENTITY$AUTH_TYPE VARCHAR2(4)
DATA$IDENTITY$CALLER_ID VARCHAR2(4)
DATA$IDENTITY$TENANT_ID VARCHAR2(128)
DATA$IDENTITY$IP_ADDRESS VARCHAR2(64)
DATA$IDENTITY$USER_AGENT VARCHAR2(128)
DATA$IDENTITY$CALLER_NAME VARCHAR2(4)
DATA$IDENTITY$CREDENTIALS VARCHAR2(4096)
DATA$IDENTITY$PRINCIPAL_ID VARCHAR2(128)
DATA$IDENTITY$PRINCIPAL_NAME VARCHAR2(32)
DATA$IDENTITY$CONSOLE_SESSION_ID VARCHAR2(32)
DATA$RESPONSE$STATUS VARCHAR2(4)
DATA$RESPONSE$MESSAGE VARCHAR2(128)
DATA$RESPONSE$PAYLOAD$ID VARCHAR2(128)
DATA$RESPONSE$PAYLOAD$VOLUMEID VARCHAR2(128)
DATA$RESPONSE$PAYLOAD$INSTANCEID VARCHAR2(128)
DATA$RESPONSE$PAYLOAD$LOGIN_INPUT VARCHAR2(64)
DATA$RESPONSE$PAYLOAD$LOGIN_RESULT VARCHAR2(16)
DATA$RESPONSE$PAYLOAD$RESOURCENAME VARCHAR2(32)
DATA$RESPONSE$RESPONSE_TIME VARCHAR2(32)
DATA$EVENT_NAME VARCHAR2(64)
DATA$RESOURCE_ID VARCHAR2(128)
DATA$DEFINED_TAGS$ORACLE_TAGS$CREATEDBY VARCHAR2(64)
DATA$DEFINED_TAGS$ORACLE_TAGS$CREATEDON VARCHAR2(32)
DATA$STATE_CHANGE$CURRENT$ID VARCHAR2(128)
DATA$STATE_CHANGE$CURRENT$ETAG VARCHAR2(64)
DATA$STATE_CHANGE$CURRENT$NAME VARCHAR2(32)
DATA$STATE_CHANGE$CURRENT$EMAIL VARCHAR2(32)
DATA$STATE_CHANGE$CURRENT$USERID VARCHAR2(128)
DATA$STATE_CHANGE$CURRENT$GROUPID VARCHAR2(128)
DATA$STATE_CHANGE$CURRENT$INSTANCE$ID VARCHAR2(128)
DATA$STATE_CHANGE$CURRENT$INSTANCE$SHAPE VARCHAR2(16)
DATA$STATE_CHANGE$CURRENT$INSTANCE$REGION VARCHAR2(4)
DATA$STATE_CHANGE$CURRENT$INSTANCE$IMAGEID VARCHAR2(128)
DATA$STATE_CHANGE$CURRENT$INSTANCE$METADATA$SSH_AUTHORIZED_KEYS VARCHAR2(512)
DATA$STATE_CHANGE$CURRENT$INSTANCE$LAUNCHMODE VARCHAR2(16)
DATA$STATE_CHANGE$CURRENT$INSTANCE$AGENTCONFIG$ISMANAGEMENTDISABLED VARCHAR2(8)
DATA$STATE_CHANGE$CURRENT$INSTANCE$AGENTCONFIG$ISMONITORINGDISABLED VARCHAR2(8)
DATA$STATE_CHANGE$CURRENT$INSTANCE$DEFINEDTAGS$ORACLE_TAGS$CREATEDBY VARCHAR2(64)
DATA$STATE_CHANGE$CURRENT$INSTANCE$DEFINEDTAGS$ORACLE_TAGS$CREATEDON VARCHAR2(32)
DATA$STATE_CHANGE$CURRENT$INSTANCE$DISPLAYNAME VARCHAR2(8)
DATA$STATE_CHANGE$CURRENT$INSTANCE$FAULTDOMAIN VARCHAR2(16)
DATA$STATE_CHANGE$CURRENT$INSTANCE$SHAPECONFIG$GPUS NUMBER
DATA$STATE_CHANGE$CURRENT$INSTANCE$SHAPECONFIG$OCPUS NUMBER
DATA$STATE_CHANGE$CURRENT$INSTANCE$SHAPECONFIG$LOCALDISKS NUMBER
DATA$STATE_CHANGE$CURRENT$INSTANCE$SHAPECONFIG$MEMORYINGBS NUMBER
DATA$STATE_CHANGE$CURRENT$INSTANCE$SHAPECONFIG$MAXVNICATTACHMENTS NUMBER
DATA$STATE_CHANGE$CURRENT$INSTANCE$SHAPECONFIG$PROCESSORDESCRIPTION VARCHAR2(32)
DATA$STATE_CHANGE$CURRENT$INSTANCE$SHAPECONFIG$NETWORKINGBANDWIDTHINGBPS NUMBER
DATA$STATE_CHANGE$CURRENT$INSTANCE$TIMECREATED VARCHAR2(32)
DATA$STATE_CHANGE$CURRENT$INSTANCE$COMPARTMENTID VARCHAR2(128)
DATA$STATE_CHANGE$CURRENT$INSTANCE$LAUNCHOPTIONS$FIRMWARE VARCHAR2(8)
DATA$STATE_CHANGE$CURRENT$INSTANCE$LAUNCHOPTIONS$NETWORKTYPE VARCHAR2(16)
DATA$STATE_CHANGE$CURRENT$INSTANCE$LAUNCHOPTIONS$BOOTVOLUMETYPE VARCHAR2(16)
DATA$STATE_CHANGE$CURRENT$INSTANCE$LAUNCHOPTIONS$REMOTEDATAVOLUMETYPE VARCHAR2(16)
DATA$STATE_CHANGE$CURRENT$INSTANCE$LAUNCHOPTIONS$ISPVENCRYPTIONINTRANSITENABLED VARCHAR2(8)
DATA$STATE_CHANGE$CURRENT$INSTANCE$LAUNCHOPTIONS$ISCONSISTENTVOLUMENAMINGENABLED VARCHAR2(4)
DATA$STATE_CHANGE$CURRENT$INSTANCE$SOURCEDETAILS$IMAGEID VARCHAR2(128)
DATA$STATE_CHANGE$CURRENT$INSTANCE$SOURCEDETAILS$SOURCETYPE VARCHAR2(8)
DATA$STATE_CHANGE$CURRENT$INSTANCE$LIFECYCLESTATE VARCHAR2(16)
DATA$STATE_CHANGE$CURRENT$INSTANCE$INSTANCEOPTIONS$ARELEGACYIMDSENDPOINTSDISABLED VARCHAR2(8)
DATA$STATE_CHANGE$CURRENT$INSTANCE$AVAILABILITYDOMAIN VARCHAR2(32)
DATA$STATE_CHANGE$CURRENT$INSTANCE$PREFERREDMAINTENANCEACTION VARCHAR2(8)
DATA$STATE_CHANGE$CURRENT$DBHOSTID VARCHAR2(64)
DATA$STATE_CHANGE$CURRENT$PASSWORD VARCHAR2(32)
DATA$STATE_CHANGE$CURRENT$BUCKETNAME VARCHAR2(16)
DATA$STATE_CHANGE$CURRENT$DBHOSTNAME VARCHAR2(16)
DATA$STATE_CHANGE$CURRENT$DEFINEDTAGS$ORACLE_TAGS$CREATEDBY VARCHAR2(64)
DATA$STATE_CHANGE$CURRENT$DEFINEDTAGS$ORACLE_TAGS$CREATEDON VARCHAR2(32)
DATA$STATE_CHANGE$CURRENT$DESCRIPTION VARCHAR2(256)
DATA$STATE_CHANGE$CURRENT$DISPLAYNAME VARCHAR2(32)
DATA$STATE_CHANGE$CURRENT$LICENSETYPE VARCHAR2(16)
DATA$STATE_CHANGE$CURRENT$TIMECREATED VARCHAR2(32)
DATA$STATE_CHANGE$CURRENT$CAPABILITIES$CANUSEAPIKEYS VARCHAR2(4)
DATA$STATE_CHANGE$CURRENT$CAPABILITIES$CANUSEAUTHTOKENS VARCHAR2(4)
DATA$STATE_CHANGE$CURRENT$CAPABILITIES$CANUSECONSOLEPASSWORD VARCHAR2(4)
DATA$STATE_CHANGE$CURRENT$CAPABILITIES$CANUSESMTPCREDENTIALS VARCHAR2(4)
DATA$STATE_CHANGE$CURRENT$CAPABILITIES$CANUSECUSTOMERSECRETKEYS VARCHAR2(4)
DATA$STATE_CHANGE$CURRENT$CAPABILITIES$CANUSEOAUTH2CLIENTCREDENTIALS VARCHAR2(4)
DATA$STATE_CHANGE$CURRENT$CPUCORECOUNT NUMBER
DATA$STATE_CHANGE$CURRENT$TIMEMODIFIED VARCHAR2(32)
DATA$STATE_CHANGE$CURRENT$COMPARTMENTID VARCHAR2(128)
DATA$STATE_CHANGE$CURRENT$EMAILVERIFIED VARCHAR2(8)
DATA$STATE_CHANGE$CURRENT$SSHPUBLICKEYS VARCHAR2(4)
DATA$STATE_CHANGE$CURRENT$ISMFAACTIVATED VARCHAR2(8)
DATA$STATE_CHANGE$CURRENT$LIFECYCLESTATE VARCHAR2(16)
DATA$STATE_CHANGE$CURRENT$VOLUMEATTACHMENT$ID VARCHAR2(128)
DATA$STATE_CHANGE$CURRENT$VOLUMEATTACHMENT$IQN VARCHAR2(64)
DATA$STATE_CHANGE$CURRENT$VOLUMEATTACHMENT$IPV4 VARCHAR2(16)
DATA$STATE_CHANGE$CURRENT$VOLUMEATTACHMENT$PORT NUMBER
DATA$STATE_CHANGE$CURRENT$VOLUMEATTACHMENT$DEVICE VARCHAR2(32)
DATA$STATE_CHANGE$CURRENT$VOLUMEATTACHMENT$VOLUMEID VARCHAR2(128)
DATA$STATE_CHANGE$CURRENT$VOLUMEATTACHMENT$INSTANCEID VARCHAR2(128)
DATA$STATE_CHANGE$CURRENT$VOLUMEATTACHMENT$ISREADONLY VARCHAR2(8)
DATA$STATE_CHANGE$CURRENT$VOLUMEATTACHMENT$DISPLAYNAME VARCHAR2(32)
DATA$STATE_CHANGE$CURRENT$VOLUMEATTACHMENT$ISSHAREABLE VARCHAR2(8)
DATA$STATE_CHANGE$CURRENT$VOLUMEATTACHMENT$TIMECREATED VARCHAR2(32)
DATA$STATE_CHANGE$CURRENT$VOLUMEATTACHMENT$COMPARTMENTID VARCHAR2(128)
DATA$STATE_CHANGE$CURRENT$VOLUMEATTACHMENT$LIFECYCLESTATE VARCHAR2(16)
DATA$STATE_CHANGE$CURRENT$VOLUMEATTACHMENT$AVAILABILITYDOMAIN VARCHAR2(32)
DATA$STATE_CHANGE$CURRENT$VOLUMEATTACHMENT$ISPVENCRYPTIONINTRANSITENABLED VARCHAR2(8)
DATA$STATE_CHANGE$CURRENT$DATASTORAGESIZEINGBS NUMBER
DATA$STATE_CHANGE$CURRENT$DATASTORAGESIZEINTBS NUMBER
DATA$STATE_CHANGE$PREVIOUS$ID VARCHAR2(128)
DATA$STATE_CHANGE$PREVIOUS$NAME VARCHAR2(32)
DATA$STATE_CHANGE$PREVIOUS$EMAIL VARCHAR2(32)
DATA$STATE_CHANGE$PREVIOUS$DEFINEDTAGS$ORACLE_TAGS$CREATEDBY VARCHAR2(64)
DATA$STATE_CHANGE$PREVIOUS$DEFINEDTAGS$ORACLE_TAGS$CREATEDON VARCHAR2(32)
DATA$STATE_CHANGE$PREVIOUS$DESCRIPTION VARCHAR2(32)
DATA$STATE_CHANGE$PREVIOUS$TIMECREATED VARCHAR2(32)
DATA$STATE_CHANGE$PREVIOUS$CAPABILITIES$CANUSEAPIKEYS VARCHAR2(4)
DATA$STATE_CHANGE$PREVIOUS$CAPABILITIES$CANUSEAUTHTOKENS VARCHAR2(4)
DATA$STATE_CHANGE$PREVIOUS$CAPABILITIES$CANUSECONSOLEPASSWORD VARCHAR2(4)
DATA$STATE_CHANGE$PREVIOUS$CAPABILITIES$CANUSESMTPCREDENTIALS VARCHAR2(4)
DATA$STATE_CHANGE$PREVIOUS$CAPABILITIES$CANUSECUSTOMERSECRETKEYS VARCHAR2(4)
DATA$STATE_CHANGE$PREVIOUS$CAPABILITIES$CANUSEOAUTH2CLIENTCREDENTIALS VARCHAR2(4)
DATA$STATE_CHANGE$PREVIOUS$TIMEMODIFIED VARCHAR2(32)
DATA$STATE_CHANGE$PREVIOUS$COMPARTMENTID VARCHAR2(128)
DATA$STATE_CHANGE$PREVIOUS$EMAILVERIFIED VARCHAR2(8)
DATA$STATE_CHANGE$PREVIOUS$ISMFAACTIVATED VARCHAR2(8)
DATA$STATE_CHANGE$PREVIOUS$LIFECYCLESTATE VARCHAR2(8)
DATA$FREEFORM_TAGS$BACKUP VARCHAR2(16)
DATA$RESOURCE_NAME VARCHAR2(64)
DATA$COMPARTMENT_ID VARCHAR2(128)
DATA$COMPARTMENT_NAME VARCHAR2(16)
DATA$EVENT_GROUPING_ID VARCHAR2(128)
DATA$ADDITIONAL_DETAILS$ETAG VARCHAR2(64)
DATA$ADDITIONAL_DETAILS$TYPE VARCHAR2(16)
DATA$ADDITIONAL_DETAILS$NONCE VARCHAR2(64)
DATA$ADDITIONAL_DETAILS$SCOPE VARCHAR2(8)
DATA$ADDITIONAL_DETAILS$SHAPE VARCHAR2(16)
DATA$ADDITIONAL_DETAILS$STATE VARCHAR2(256)
DATA$ADDITIONAL_DETAILS$ACTION VARCHAR2(8)
DATA$ADDITIONAL_DETAILS$DBNAME VARCHAR2(8)
DATA$ADDITIONAL_DETAILS$NSGIDS VARCHAR2(4)
DATA$ADDITIONAL_DETAILS$TENANT VARCHAR2(8)
DATA$ADDITIONAL_DETAILS$USERID VARCHAR2(128)
DATA$ADDITIONAL_DETAILS$GROUPID VARCHAR2(128)
DATA$ADDITIONAL_DETAILS$IMAGEID VARCHAR2(128)
DATA$ADDITIONAL_DETAILS$REFERER VARCHAR2(1024)
DATA$ADDITIONAL_DETAILS$VERSION VARCHAR2(16)
DATA$ADDITIONAL_DETAILS$DBHOSTID VARCHAR2(64)
DATA$ADDITIONAL_DETAILS$HOSTNAME VARCHAR2(16)
DATA$ADDITIONAL_DETAILS$USERNAME VARCHAR2(32)
DATA$ADDITIONAL_DETAILS$VOLUMEID VARCHAR2(128)
DATA$ADDITIONAL_DETAILS$CLIENT_ID VARCHAR2(16)
DATA$ADDITIONAL_DETAILS$NAMESPACE VARCHAR2(16)
DATA$ADDITIONAL_DETAILS$PROVIDERS VARCHAR2(1024)
DATA$ADDITIONAL_DETAILS$BUCKETNAME VARCHAR2(16)
DATA$ADDITIONAL_DETAILS$DBSYSTEMID VARCHAR2(128)
DATA$ADDITIONAL_DETAILS$PUBLIC_KEY VARCHAR2(1024)
DATA$ADDITIONAL_DETAILS$SOURCETYPE VARCHAR2(8)
DATA$ADDITIONAL_DETAILS$VERSIONING VARCHAR2(8)
DATA$ADDITIONAL_DETAILS$VOLUMENAME VARCHAR2(8)
DATA$ADDITIONAL_DETAILS$X_REAL_PORT NUMBER
DATA$ADDITIONAL_DETAILS$LICENSETYPE VARCHAR2(16)
DATA$ADDITIONAL_DETAILS$POWERACTION VARCHAR2(8)
DATA$ADDITIONAL_DETAILS$TIMECREATED VARCHAR2(32)
DATA$ADDITIONAL_DETAILS$TIMEUPDATED VARCHAR2(32)
DATA$ADDITIONAL_DETAILS$CPUCORECOUNT NUMBER
DATA$ADDITIONAL_DETAILS$REDIRECT_URI VARCHAR2(256)
DATA$ADDITIONAL_DETAILS$RESOURCENAME VARCHAR2(128)
DATA$ADDITIONAL_DETAILS$WORKLOADTYPE VARCHAR2(32)
DATA$ADDITIONAL_DETAILS$RESPONSE_TYPE VARCHAR2(16)
DATA$ADDITIONAL_DETAILS$SSHPUBLICKEYS VARCHAR2(4)
DATA$ADDITIONAL_DETAILS$APP_PUBLIC_KEY VARCHAR2(1024)
DATA$ADDITIONAL_DETAILS$LIFECYCLESTATE VARCHAR2(16)
DATA$ADDITIONAL_DETAILS$SUPPORTPROVIDER VARCHAR2(4)
DATA$ADDITIONAL_DETAILS$PUBLICACCESSTYPE VARCHAR2(16)
DATA$ADDITIONAL_DETAILS$SUPPORT_PROVIDER VARCHAR2(4)
DATA$ADDITIONAL_DETAILS$EXADATAIORMCONFIG VARCHAR2(4)
DATA$ADDITIONAL_DETAILS$SERVICECONSOLEURL VARCHAR2(256)
DATA$ADDITIONAL_DETAILS$INSTANCEACTIONTYPE VARCHAR2(8)
DATA$ADDITIONAL_DETAILS$PATCHHISTORYENTRIES VARCHAR2(4)
DATA$ADDITIONAL_DETAILS$AUTONOMOUSDATABASEID VARCHAR2(128)
DATA$ADDITIONAL_DETAILS$DATASTORAGESIZEINGBS NUMBER
DATA$ADDITIONAL_DETAILS$DATASTORAGESIZEINTBS NUMBER
DATA$ADDITIONAL_DETAILS$DATASTORAGEPERCENTAGE NUMBER
DATA$ADDITIONAL_DETAILS$AUTONOMOUSDATABASETYPE VARCHAR2(32)
DATA$AVAILABILITY_DOMAIN VARCHAR2(32)
SOURCE VARCHAR2(32)
EVENT_ID VARCHAR2(64)
EVENT_TIME VARCHAR2(32)
EVENT_TYPE VARCHAR2(128)
CONTENT_TYPE VARCHAR2(16)
EVENT_TYPE_VERSION VARCHAR2(4)
CLOUD_EVENTS_VERSION VARCHAR2(4)
DATA$REQUEST$HEADERS$DNT VARCHAR2(1)
DATA$REQUEST$HEADERS$DATE VARCHAR2(32)
DATA$REQUEST$HEADERS$ACCEPT VARCHAR2(128)
DATA$REQUEST$HEADERS$COOKIE VARCHAR2(2048)
DATA$REQUEST$HEADERS$ORIGIN VARCHAR2(64)
DATA$REQUEST$HEADERS$X_DATE VARCHAR2(32)
DATA$REQUEST$HEADERS$REFERER VARCHAR2(2048)
DATA$REQUEST$HEADERS$INSTANCE VARCHAR2(128)
DATA$REQUEST$HEADERS$X_REAL_IP VARCHAR2(16)
DATA$REQUEST$HEADERS$CONNECTION VARCHAR2(16)
DATA$REQUEST$HEADERS$USER_AGENT VARCHAR2(128)
DATA$REQUEST$HEADERS$X_REAL_PORT VARCHAR2(8)
DATA$REQUEST$HEADERS$CONTENT_TYPE VARCHAR2(64)
data$request$headers$Authorization VARCHAR2(2048)
DATA$REQUEST$HEADERS$CACHE_CONTROL VARCHAR2(16)
data$request$headers$authorization VARCHAR2(2048)
DATA$REQUEST$HEADERS$OPC_PRINCIPAL VARCHAR2(8192)
DATA$REQUEST$HEADERS$CONTENT_LENGTH VARCHAR2(4)
DATA$REQUEST$HEADERS$SEC_FETCH_DEST VARCHAR2(8)
DATA$REQUEST$HEADERS$SEC_FETCH_MODE VARCHAR2(8)
DATA$REQUEST$HEADERS$SEC_FETCH_SITE VARCHAR2(16)
DATA$REQUEST$HEADERS$SEC_FETCH_USER VARCHAR2(2)
DATA$REQUEST$HEADERS$OPC_REQUEST_ID VARCHAR2(128)
DATA$REQUEST$HEADERS$ACCEPT_ENCODING VARCHAR2(32)
data$request$headers$Accept_Language VARCHAR2(32)
DATA$REQUEST$HEADERS$X_FORWARDED_FOR VARCHAR2(64)
data$request$headers$accept_language VARCHAR2(2)
DATA$REQUEST$HEADERS$X_FORWARDED_HOST VARCHAR2(64)
DATA$REQUEST$HEADERS$X_FORWARDED_PORT VARCHAR2(4)
DATA$REQUEST$HEADERS$OCI_ORIGINAL_URL VARCHAR2(256)
DATA$REQUEST$HEADERS$X_CONTENT_SHA256 VARCHAR2(64)
DATA$REQUEST$HEADERS$X_FORWARDED_PROTO VARCHAR2(8)
DATA$REQUEST$HEADERS$X_ORACLE_AUTH_CLIENT_CN VARCHAR2(64)
DATA$REQUEST$HEADERS$UPGRADE_INSECURE_REQUESTS VARCHAR2(1)
DATA$REQUEST$PARAMETERS$ACTION VARCHAR2(8)
DATA$REQUEST$PARAMETERS$PARAM0 VARCHAR2(16)
DATA$REQUEST$PARAMETERS$TENANTID VARCHAR2(128)
DATA$REQUEST$PARAMETERS$PRESERVEBOOTVOLUME VARCHAR2(8)
DATA$RESPONSE$HEADERS$DATE VARCHAR2(32)
data$response$headers$ETag VARCHAR2(64)
DATA$RESPONSE$HEADERS$VARY VARCHAR2(8)
data$response$headers$etag VARCHAR2(64)
DATA$RESPONSE$HEADERS$PRAGMA VARCHAR2(8)
data$response$headers$Location VARCHAR2(4096)
data$response$headers$location VARCHAR2(128)
DATA$RESPONSE$HEADERS$X_API_ID VARCHAR2(8)
DATA$RESPONSE$HEADERS$CONNECTION VARCHAR2(8)
DATA$RESPONSE$HEADERS$CONTENT_TYPE VARCHAR2(32)
DATA$RESPONSE$HEADERS$CACHE_CONTROL VARCHAR2(64)
DATA$RESPONSE$HEADERS$CONTENT_LENGTH VARCHAR2(4)
DATA$RESPONSE$HEADERS$OPC_REQUEST_ID VARCHAR2(128)
DATA$RESPONSE$HEADERS$X_FRAME_OPTIONS VARCHAR2(4)
DATA$RESPONSE$HEADERS$OPC_WORK_REQUEST_ID VARCHAR2(128)
DATA$RESPONSE$HEADERS$X_CONTENT_TYPE_OPTIONS VARCHAR2(8)
data$response$headers$Access_Control_Allow_Origin VARCHAR2(64)
data$response$headers$access_control_allow_origin VARCHAR2(1)
DATA$RESPONSE$HEADERS$ACCESS_CONTROL_ALLOW_METHODS VARCHAR2(32)
data$response$headers$Access_Control_Expose_Headers VARCHAR2(128)
data$response$headers$access_control_expose_headers VARCHAR2(256)
data$response$headers$Access_Control_Allow_Credentials VARCHAR2(4)
data$response$headers$access_control_allow_credentials VARCHAR2(4)
DATA$STATE_CHANGE$CURRENT$STATEMENTS VARCHAR2(128)
DATA$STATE_CHANGE$PREVIOUS$STATEMENTS VARCHAR2(128)
select DISTINCT
DATA$EVENT_NAME,
cast(TO_TIMESTAMP_TZ(EVENT_TIME,'YYYY-MM-DD"T"HH24:MI:SS.FF6TZH:TZM') AT LOCAL AS DATE) EVENT_TIME,
EVENT_TYPE,
SOURCE,
/* CREDENTIAL_ID, */
DATA$IDENTITY$TENANT_ID,
DATA$IDENTITY$PRINCIPAL_NAME,
DATA$IDENTITY$PRINCIPAL_ID,
DATA$IDENTITY$USER_AGENT,
DATA$IDENTITY$IP_ADDRESS,
DATA$RESPONSE$RESPONSE_TIME,
DATA$COMPARTMENT_ID,
DATA$COMPARTMENT_NAME,
DATA$REQUEST$ACTION,
DATA$RESPONSE$STATUS,
DATA$RESOURCE_NAME,
DATA$RESOURCE_ID
/* NVL("response_payload$id","response_payload$id") response_payload$id, */
/* NVL("response_payload$ResourceName","response_payload$resourceName") response_payload$resourceName */
FROM OCI360_AUDIT_EVENTS
WHERE SOURCE='DatabaseService'
AND DATA$REQUEST$ACTION not in ('GET','HEAD')
ORDER BY EVENT_TIME DESC;
9 rows selected.