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-10823: invalid query name

1 Answers  


ORA-24355: attempt to store a negative number in an Unsigned Display type.

1 Answers  


SQL-02108: Invalid descriptor passed to run-time library

1 Answers  


ORA-30035: Undo tablespace cannot be specified as default temporary tablespace

1 Answers  


ORA-19811: cannot have files in DB_RECOVERY_FILE_DEST with keep attributes

2 Answers  






EXP-00071: QUERY parameter not compatible with Direct Path export

1 Answers  


ORA-02290: check constraint (string.string) violated

1 Answers  


PCB-00580: Previous use of host variable "string" uses different indicator

1 Answers  


NNL-00256: Server-generated requests now do not request forwarding

1 Answers  


ORA-12838: cannot read/modify an object after modifying it in parallel

1 Answers  


DRG-11535: error writing phrase or qualifier: string on line string to memory

1 Answers  


ORA-03001: unimplemented feature

1 Answers  


Categories