Oracle Error ORA-36406: (VCACHE00) ‘number’ is an invalid value for the VARCACHE option. The only permissible values are ‘SESSION’, ‘VARIABLE’, and ‘NONE’.

Oracle Error Message

ORA-36406: (VCACHE00) ‘number’ is an invalid value for the VARCACHE option. The only permissible values are ‘SESSION’, ‘VARIABLE’, and ‘NONE’.

Reason for the Error

The user tried to assign an invalid value to the VARCACHE option

Solution

Assign one of the valid values