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

RMAN-06000: could not open recovery manager library file: string

1 Answers  


PLS-00125: type name expected

1 Answers  


ORA-17506: I/O Error Simulation

1 Answers  


TNS-01172: Listener has shut down since all listen addresses have been deallocated

1 Answers  


ORA-25120: MINIMUM EXTENT option already specified

1 Answers  


ORA-23345: table "string"."string" not registered to collect statistics

1 Answers  


PCC-00007: Invalid WHENEVER condition at column number in line number of file string

1 Answers  


ORA-25298: The memory threshold for a queue cannot be negative

1 Answers  


IMG-00561: input format does not support channel selection

1 Answers  


TNS-04021: The SET command is unsuccessful for parameter string.

1 Answers  


O2F-00338: Illegal or missing package name

1 Answers  


ORA-13482: GeoRaster object is not initialized for the image

1 Answers  


Categories