Database Administration (MOSC)

MOSC Banner

DBIO_EXPECTED initialization parameter

edited May 7, 2014 5:22AM in Database Administration (MOSC) 4 commentsAnswered ✓

Hi,

on 12c or 11 g

it seems that <span class="codeinlinebold">DBIO_EXPECTED</span> is it an  initialization parameter ?

SQL> show parameter DBIO

SQL> show parameter DBIO_EXPECTED

SQL>

They give nothing.

Then I set it :

SQL>       EXECUTE DBMS_ADVISOR.SET_DEFAULT_TASK_PARAMETER('ADDM', 'DBIO_EXPECTED', 8000);

PL/SQL procedure successfully completed.

Ok. Now how to get or verify this value ?

The subprograms :

GET_REC_ATTRIBUTES Procedure

GET_TASK_REPORT Function

GET_TASK_SCRIPT Function

seems do not help.

Then how to verify the new value : 8000 ?

Thank you.

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