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

KUP-02005: token too big

1 Answers  


ORA-38201: assert if pin during flush

1 Answers  


PLS-00598: comparison of object with NULL using "string" is not allowed

1 Answers  


PCC-02081: CMD-LINE: Unterminated option value list or value list was truncated.

1 Answers  


ORA-24405: error occured while trying to create connections in the pool

1 Answers  






ORA-00377: Frequent backups of file string causing write operation to stall

1 Answers  


ORA-07250: spcre: semget error, unable to get first semaphore set.

1 Answers  


TNS-00142: Community mismatch in TNSNAV.ORA

1 Answers  


NNO-00852: failed to get LDAP entry: error = number

1 Answers  


ORA-13003: the specified range for a dimension is invalid

1 Answers  


ORA-12508: TNS:listener could not resolve the COMMAND given

1 Answers  


DRG-10533: invalid user name: string

1 Answers  


Categories