1. Getting Started with Oracle Enterprise Performance Management Cloud for Administrators
  2. Monitoring EPM Cloud
  3. Activity Report Contents
  4. Manual Database Access Information

Manual Database Access Information

Manual access to the relational database by running SQL commands is prohibited except under emergency situations, for example, when an environment becomes unresponsive. The general process for addressing such emergencies involves Oracle responding to a service request filed on behalf of the subscriber. The service request should give explicit permission to Oracle to manually access the relational database to address issues. Statistics on manual access of the database available in the Manual SQL Executions table of the Activity Report includes the following:

  • Time: The time at which SQL commands were executed against the database
  • SR #: The service request number based on which the database was manually accessed
  • SQL: The SQL statements that were executed

This section of the report allows you to audit manual database activities. If you identify an unauthorized manual database access, add the information from this section to a service request so that Oracle can immediately investigate the incident and take remedial actions if needed.