Database Administration (MOSC)

MOSC Banner

changing result_cache_max_size

edited Oct 2, 2023 11:30AM in Database Administration (MOSC) 15 commentsAnswered ✓

Hi,

on 11.2.0.4 on AIX,

How to modify result_cache_max_size              ?

Is it also for non RAC database?

Is the follwing correct?

ALTER SYSTEM set result_cache_max_size  =nnnnnnnn;

Should we restart database?

Thanks and regards.

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