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 AWR functionality.
AUTHID
DEFINER
Dependencies
ALL_TABLES
DBMS_DATAPUMP
KU$_JOBSTATUS
ALL_TAB_COLUMNS
DBMS_LOB
KU$_LOGENTRY
AWRRPT_VARCHAR256_LIST_TYPE
DBMS_LOCK
KU$_LOGLINE
AWR_EXPORT_DUMP_ID_TYPE
DBMS_MANAGEMENT_PACKS
KU$_LOGLINE1010
AWR_OBJECT_INFO_TYPE
DBMS_OUTPUT
KU$_STATUS
DBA_ADVISOR_PARAMETERS
DBMS_SCHEDULER
PLITBLM
DBA_ADVISOR_TASKS
DBMS_STANDARD
UTL_FILE
DBA_CONSTRAINTS
DBMS_STATS
V$INSTANCE
DBA_CONS_COLUMNS
DBMS_SWRF_LIB
V$TIMER
DBA_DIRECTORIES
DBMS_SWRF_REPORT_INTERNAL
WRM$_DATABASE_INSTANCE
DBA_HIST_WR_SETTINGS
DBMS_SYSTEM
WRM$_SNAPSHOT
DBA_TABLES
DBMS_SYS_ERROR
WRM$_WR_CONTROL
DBA_TAB_COLUMNS
DBMS_UTILITY
WRM$_WR_SETTINGS
DBA_USERS
DBMS_WORKLOAD_REPOSITORY
X$KEWRTB
DBMS_ADDM
DBMS_XPLAN
XMLTYPE
DBA_ASSERT
DUAL
XQSEQUENCE
DBMS_AWRWH_LIB
KU$_JOBDESC
First Available
Not known
Security Model
Owned by SYS with EXECUTE granted to the SYSUMF role.
dbms_swrf_internal.awr_exp(
dmpfile IN VARCHAR2
dmpdir IN VARCHAR2
dbid IN NUMBER
bid IN NUMBER
eid IN NUMBER
mbtype IN NUMBER
mbcred IN VARCHAR2
dop IN NUMBER);
dbms_swrf_internal.awr_extract(
dmpfile IN VARCHAR2,
dmpdir IN
VARCHAR2,
bid
IN NUMBER,
eid
IN NUMBER,
dbid
IN NUMBER,
from_source_name IN VARCHAR2,
to_source_name IN VARCHAR2,
logdir IN
VARCHAR2);
dbms_swrf_internal.awr_flush_t2ss_snap(
dbid
IN NUMBER,
snap_id IN NUMBER,
srcdbid IN NUMBER,
flush_level IN VARCHAR2,
topology_name IN VARCHAR2,
topology_version IN NUMBER);
dbms_swrf_internal.awr_get_object_info(
con_dbid IN NUMBER,
tsid IN NUMBER,
objid IN NUMBER,
dataobjid IN NUMBER,
current IN sys.awr_object_info_type)
RETURN sys.awr_object_info_type;
dbms_swrf_internal.awr_load2(
schname IN VARCHAR2,
dmpfile IN VARCHAR2,
dmpdir IN VARCHAR2,
logdir IN VARCHAR2,
dumpid OUT sys.awr_export_dump_id_type);
dbms_swrf_internal.cleanup_databasecleanup_local IN BOOLEAN);
exec dbms_swrf_internal.cleanup_database(FALSE);
PL/SQL procedure successfully completed.
exec dbms_swrf_internal.cleanup_database(TRUE);
BEGIN dbms_swrf_internal.cleanup_database(TRUE); END;
*
ERROR at line 1:
ORA-13521: Unregister operation on local Database id (1863203691) not allowed
ORA-06512: at "SYS.DBMS_SWRF_INTERNAL", line 414
ORA-06512: at "SYS.DBMS_SWRF_INTERNAL", line 447
ORA-06512: at line 1
dbms_swrf_internal.create_import_partitions(
dbid IN NUMBER,
low_snap_id IN NUMBER,
high_snap_id IN NUMBER,
low_snap_time IN DATE,
high_snap_time IN DATE);
Returns TRUE if the string parameter corresponds with the AWR's location
dbms_swrf_internal.validate_awr_location(awr_location IN VARCHAR2) RETURN BOOLEAN;
DECLARE
awrloc VARCHAR2(30) := 'SYSAUX';
BEGIN
IF dbms_swrf_internal.validate_awr_location(awrloc) THEN
dbms_output.put_line('The AWR location is ' || awrloc);
ELSE
dbms_output.put_line('The AWR is not located in ' || awrloc);
END IF;
END;
/ The AWR is not located in SYSAUX