Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Can the information contained in Automatic Workload Repository (AWR) be used for charge back purposes?

April 26, 2017automatic awr charge purposes Repository Used workload

0

Posted

Can the information contained in Automatic Workload Repository (AWR) be used for charge back purposes?

1 Answer

0

Posted

The Automatic Workload Repository (AWR) in Oracle Database 10g does contain the resource consumption statistics rolled up at the Service Level. Services are logical abstractions for managing workloads in 10g and are used to divide workloads into mutually dijoint groupings. Out-of-the-box, the Service Stats are captured by AWR once an hour and can be queried through the DBA_HIST_SERVICE_STAT view. Also, we provide a report to view the AWR information. To run the AWR report, run the following from a SQL/Plus session: @?/rdbms/admin/awrrpt.sql The script will prompt you for a set of IDs that correspond to the relevant time periods. The report will display the DB Time, DB CPU, Physical Reads, and Logical Reads for each Service.