ORA-00827: could not shrink sga_target to specified value



ORA-00827: could not shrink sga_target to specified value..

Answer / guest

Cause: Attempted to shrink the SGA to the specified value
but did not succeed because the SGA components could not be
shrunk as they were already at their minimum sizes.

Action: Do not set sga_target to a value below the current
value without first shrinking the individual SGA components.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

DRG-12202: error while creating section group

1 Answers  


ORA-34481: (MXMAINT07) You cannot string values of PARTITION TEMPLATE workspace object.

1 Answers  


PROC-00017: Unimplemented feature

1 Answers  


ORA-25307: Enqueue rate too high. Enable flow control

3 Answers  


NZE-29223: Cannot create certificate chain.

1 Answers  


TNS-01441: Number of filtering rules currently in effect: number

1 Answers  


ORA-14609: Tablespace was not specified for the previous lob segments of column string in template but is specified for string

1 Answers  


NNL-00225: Currently managing name server "string"

1 Answers  


QSM-02121: set operator in a context not supported for fast refresh

1 Answers  


PLS-00374: illegal EXIT statement; it must appear inside the loop labeled 'string'

1 Answers  


ORA-02840: Open of log file by client failed

1 Answers  


ORA-29263: HTTP protocol error

1 Answers  


Categories