Databases Reference
In-Depth Information
and assign tables to be managed by the Assistant. You might also view partition simu‐
lation, a lifecycle summary, and storage costs, and define policy notes during setup of
the lifecycle.
ILM in Oracle Database 12
c
Oracle Database 12
c
introduces
Heat Maps
and
Automatic Data Optimization
(ADO)
for implementing ILM strategies. Oracle Database 12
c
tracks data access at the segment
level in the Heat Maps. Data modification is tracked using Heat Maps at the segment
and row level.
ADO provides the ability to automate the compression and movement of data among
different tiers of storage in the database. Heat Maps must be enabled to use this feature.
You can specify compression levels in the tiers and when data movement should take
place based on data access activity levels. Storage tier policies are usually set at the
segment level, though compression policies can also be set at the row level in combi‐
nation with segment level policies for finer control. For example, you might specify a
policy for compression of rows of data not modified in the past 45 days.
ADO is deeply integrated with the Oracle Database and, as with other ILM strategies,
disk savings and performance benefits can be significant. It is expected that organiza‐
tions will increasingly use the new automated capabilities as they deploy Oracle Data‐
base 12
c
and upgrade from older Oracle releases where the ILM Assistant was used.
Working with Oracle Support
Regardless of the extent of your training, there are bound to be some issues that you
can't resolve without help from Oracle. Part of the job of the DBA is to help resolve any
issues with the Oracle Database. Oracle offers several levels of support, including Pre‐
mier Support, Extended Support, and Sustaining Support. Given how critical the Oracle
Database is to the business, most organizations choose Premier Support.
Premier Support includes software updates, fixes, security alerts, critical patch updates,
and upgrade scripts. You have access to the web-based My Oracle Support system 24
hours a day and 7 days a week, including the ability to log Service Requests (SRs) online.
You also can get assistance with SRs 24/7.
If you have Premier Support and have deployed the Oracle Database on an Oracle-
engineered system such as the Exadata Database Machine, you have access to Platinum
Services at no extra cost. Oracle provides remote fault monitoring of the system and
Oracle Database 24/7 with response times of 5 minutes for fault notification, 15 minutes
for restoration or escalation to Oracle Development, and 30 minutes for joint debugging
with Oracle Development to begin. Full Stack Download Patches (QDPs) are provided
four times a year.
