Database Administration (MOSC)

MOSC Banner

SGA PGA

edited Mar 27, 2013 5:27PM in Database Administration (MOSC) 2 commentsAnswered
could you someone expain more details to me,

I want to adjust SGA and PGA.

1) what is different between following statement, with/without sid='*'

alter system set pga_aggregate_target=3g sid='*' scope=both;

alter system set pga_aggregate_target=3G scope=both;

2) what is different between following statement, scope = both or scope =spfile

alter system set pga_aggregate_target=3G scope=both;

alter system set pga_aggregate_target=3G scope=spfile;

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