ORA-00821: Specified value of sga_target stringM is too small, needs to be at least stringM

Friday, March 28th, 2008

Cause : The specified value of sga_target is too small for the SGA to accommodate all of the necessary SGA components such as the log buffer, buffer pools, shared pool, etc.
Action : Set sga_target to the recommended value or reduce the values of any SGA component size parameters you have specified.

Popularity: 8% [?]

ORA-00820: Specified value of sga_max_size is too small, needs to be at least stringM

Friday, March 28th, 2008

Cause : The specified value of sga_max_size is too small for the SGA to accommodate all of the necessary SGA components such as the log buffer, buffer pools, shared pool, etc.
Action : Set sga_max_size to the recommended value or reduce the values of any SGA component size parameters you have specified.

Popularity: 14% [?]

ORA-00378 : buffer pools cannot be created as specified

Sunday, March 23rd, 2008

Cause: The number of buffers or the number of LRU latches is too small to satisfy the specified buffer pool configuration.
Action : Either increase the number of buffers and/or number of LRU latches or configure smaller buffer pools.

Popularity: 11% [?]

Close
E-mail It