Re: Long term AWR retention
- From: Gaja Krishna Vaidyanatha <gajav@xxxxxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 10 Nov 2011 21:18:10 -0800 (PST)
Hi Brandon,
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.
Cheers,
Gaja
Â
Â
Gaja Krishna Vaidyanatha,
CEO & Founder, DBPerfMan LLC
http://www.dbperfman.com
http://www.dbcloudman.com
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@xxxxxxxxxxx>
To: Gaja Krishna Vaidyanatha <gajav@xxxxxxxxx>; "sacrophyte@xxxxxxxxx"
<sacrophyte@xxxxxxxxx>; "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
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@xxxxxxxxx]
Â
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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
