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

ORA-12162: TNS:net service name is incorrectly specified

1 Answers  


KUP-04032: internal error string while parsing field string:

1 Answers  


ORA-09836: addCallback: could not add a port to the callback set.

1 Answers  


QSM-02128: does not meet the requirements of a primary key mv

1 Answers  


ORA-06747: TLI Driver: error in listen

1 Answers  






ORA-12709: error while loading create database character set

2 Answers  


ORA-01489: result of string concatenation is too long

1 Answers  


ORA-01921: role name 'string' conflicts with another user or role name

1 Answers  


ORA-38487: FUNCTION/PACKAGE/TYPE "string" not allowed in the expression

1 Answers  


ORA-13049: unable to determine tolerance value from table <layer>_SDODIM

1 Answers  


DRG-10550: illegal syntax for index, preference, source or section name

1 Answers  


TNS-00141: Failed to get file stream information

1 Answers  


Categories