Database Administration (MOSC)

MOSC Banner

DBMS_HM Findings And Recommendations

edited Feb 20, 2015 7:55AM in Database Administration (MOSC) 1 commentAnswered ✓

Hi all,

on 11.2 R2 on Win 2008 64 bit

I  ran the following :

execut DBMS_HM.RUN_CHECK('DB Structure Integrity Check', 'my_run');

And then :

SQL> SET LONG 100000

SQL> SET LONGCHUNKSIZE 1000

SQL> SET PAGESIZE 1000

SQL> SET LINESIZE 512

SQL> SELECT DBMS_HM.GET_RUN_REPORT('my_run') FROM DUAL;

DBMS_HM.GET_RUN_REPORT('MY_RUN')

--------------------------------------------------------------------

--------------------------------------------------------------------

--------------------------------------------------------------------

--------------------------------------------------------------------

Basic Run Information

Run Name                     : my_run

Run Id                       : 541

Check Name                   : DB Structure Integrity Check

Mode                         : MANUAL

Status                       : COMPLETED

Start Time                   : 2015-02-18 11:48:30.423000 +01:00

End Time                     : 2015-02-18 11:48:30.735000 +01:00

Error Encountered            : 0

Source Incident Id           : 0

Number of Incidents Created  : 0

Input Paramters for the Run

Run Findings And Recommendations

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center