Re: Long term AWR retention
Date: Thu, 10 Nov 2011 21:18:10 -0800 (PST)
My point was about how the AWR historical tables are created at install time even without the partitioning option enabled, not necessarily what are AWR's licensing requirements for use.
Phone - +1-650-743-6060
http://www.linkedin.com/in/gajakrishnavaidyanathaCo-author:Oracle Insights:Tales of the Oak Table - http://www.apress.com/book/bookDisplay.html?bID14 Co-author:Oracle Performance Tuning 101 - http://www.amazon.com/gp/reader/0072131454/ref=sib_dp_pt/102-6130796-4625766
From: "Allen, Brandon" <Brandon.Allen_at_OneNeck.com> To: Gaja Krishna Vaidyanatha <gajav_at_yahoo.com>; "sacrophyte_at_gmail.com" <sacrophyte_at_gmail.com>; "oracle-l_at_freelists.org" <oracle-l_at_freelists.org> Sent: Thursday, November 10, 2011 8:16 PM Subject: RE: Long term AWR retention
But if you’re only licensed for Standard Edition, then you can’t (legally) use AWR anyway since you can’t license the Diagnostics Pack with SE, right, or did they change that?
From:Gaja Krishna Vaidyanatha [mailto:gajav_at_yahoo.com]
It is also useful to note that EVEN if you are only licensed for Oracle Standard Edition (where database partitioning is not included), the relevant AWR tables and indexes are in fact partitioned. The script that creates the relevant WRH$ tables, sets an event for the session that is creating the tables/indexes to "disable the partition check". This enables the creation of partitioned tables/indexes for AWR.
Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor endorsed by it.Received on Thu Nov 10 2011 - 23:18:10 CST