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.

Why does AWR exist in the Oracle Database SE/SE1?

April 26, 2017awr exist oracle database SE

0

Posted

Why does AWR exist in the Oracle Database SE/SE1?

1 Answer

0

Posted

The entire AWR is indeed installed in Oracle Database 10g in SE/SE1. The reason behind it is that the AWR is also used by some base SE/SE1 features like Automatic Segment Advisor, Undo Advisor, etc. Starting with Oracle Database 11g, there is a new init.ora parameter, CONTROL_MANAGEMENT_PACK_ACCESS, that enables/disables Diagnostic and Tuning packs in the database server. In SE/SE1, this parameter is set to ‘NONE’ which disables all pack specific functionality. Users are then free to access AWR as it should only have non-pack data in it. All pack specific views will be empty.