Which has the higher priority in your organization: Deploying a new database or securing the ones you already have?
Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
Purpose
Internal support package for DBMS_HEAT_MAP_INTERNAL managing heat maps for Automatic Data Optimization (ADO) and Integrated Lifecycle Management (ILM).
Returns the block level ILM statistics for a table segment. It returns no information for segment types that are not data. The stat returned today is the latest modification time of the block.
dbms_heat_map_internal.block_heat_map( owner IN VARCHAR2,
segment_name IN VARCHAR2,
partition_name IN VARCHAR2 DEFAULT NULL,
sort_columnid IN NUMBER DEFAULT NULL,
sort_order IN VARCHAR2 DEFAULT NULL)
RETURN hm_bls_tabidx;
Returns the extent level ILM statistics for a table segment. It returns no information for segment types that are not data. Aggregates at extent level including minimum modification time and maximum modification time are returned.
dbms_heat_map_internal.extent_heat_map(
owner IN VARCHAR2,
segment_name IN VARCHAR2,
partition_name IN VARCHAR2 DEFAULT NULL)
RETURN hm_els_tabidx;
Returns the heatmap attributes for a named segment
dbms_heat_map_internal.segment_heat_map(
tablespace_id IN NUMBER,
header_file IN NUMBER,
header_block IN NUMBER,
segment_objd IN NUMBER,
min_writetime OUT DATE,
max_writetime OUT DATE,
avg_writetime OUT DATE,
min_readtime OUT DATE,
max_readtime OUT DATE,
avg_readtime OUT DATE,
min_ftstime OUT DATE,
max_ftstime OUT DATE,
avg_ftstime OUT DATE,
min_lookuptime OUT DATE,
max_lookuptime OUT DATE,
avg_lookuptime OUT DATE);
conn / as sysdba
SELECT ts#
FROM ts$
WHERE name = 'SYSTEM';
TS#
----
1
SELECT tablespace_name, header_file, header_block
FROM dba_segments
WHERE segment_name = 'SOURCE$';
TABLESPACE_NAME HEADER_FILE HEADER_BLOCK
---------------- ----------- ------------
SYSTEM 1 2760
SELECT data_object_id
FROM dba_objects
WHERE object_name = 'SOURCE$';