AWR Warehouse is a central repository configured for long term AWR data retention. It stores AWR snapshots from multiple database sources. Increasing AWR retention in the production systems would typically increase overhead and cost of mission critical databases. Hence, offloading the AWR snapshots to a central repository is a better idea. Unlike AWR retention period of default 8 days, the AWR Warehouse default retention period is "forever". However, it is configurable for weeks, months, or years.
For more information on AWR Warehouse click on the following link for a video tutorial.
http://www.youtube.com/watch?v=StydMitHtuI&feature=youtu.be
Views expressed here are solely that of my own. Please make sure that you test the code/queries that appear on my blog before applying them to the production environment.
Thursday, July 24, 2014
Monday, July 07, 2014
Benefits of Single Tenant Deployments
While presenting at a database event, I had a question from one of
the attendees on benefits of running Oracle databases in Single Tenant
Configuration. I thought this would be a
nice if I post it on my blog as it would benefit others too.
From Oracle documentation, “The multitenant architecture
enables an Oracle database to function as a multitenant container database
(CDB) that includes zero, one, or many customer-created pluggable databases
(PDBs). A PDB is a portable collection of schemas, schema objects, and non-schema
objects that appears to an Oracle Net client as a non-CDB. All Oracle databases
before Oracle Database 12c were non-CDBs”.
Following are the benefits of running databases in Single
Tenant Configuration:
- Alignment with Oracle’s new multi-tenant architecture
- Cost saving. You save on license fee as single tenant deployments do not attract Multi-tenant option license fee. License is applicable should you have two or more PDBs.
- Upgrade/patch your single PDB from 12.1.0.1 to 12.x easily with reduced downtime
- Secure separation of duties (between CDBA & DBA)
- Easier PDB cloning
I would recommend running all your production and
non-production databases in single-tenant configuration (if you are not
planning for consolidation using multi-tenant option) once you upgrade them to
Oracle Database 12c. I expect to see single tenant deployments become the
default deployment model for the customers.