ORA-00823: Specified value of sga_target greater than
sga_max_size



ORA-00823: Specified value of sga_target greater than sga_max_size..

Answer / guest

Cause: The specified value of sga_target is greater than
sga_max_size.

Action: Increase sga_max_size to match up with sga_target or
decrease sga_target to match up with sga_maxsize.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

RMAN-06466: error parsing configuration string (string)

1 Answers  


TNS-01306: nt secondary err code: number

1 Answers  


AUD-00808: ORDSpeechIndex: unable to CREATE internal Text index

1 Answers  


NZE-28793: variable bind failure

1 Answers  


ORA-24150: evaluation context string.string does not exist

1 Answers  






DRG-11813: Moved Temporarily

1 Answers  


ORA-22869: depth of type dependency hierarchy exceeds maximum limit

1 Answers  


NID-00111: Oracle error reported from target database while executing string string

1 Answers  


ORA-13347: the coordinates defining an arc are not distinct

1 Answers  


ORA-12323: unable to open database (link name string)

1 Answers  


ORA-06316: IPA: Invalid database SID

1 Answers  


ORA-36378: (XSAGTHRWEIGHT) While running AGGREGATE with multiple threads, the weight variable workspace object specified by your ARGS variable workspace object must exist in the same analytic workspace as your AGGMAP workspace object.

1 Answers  


Categories