Shulou(Shulou.com)05/31 Report--

This article mainly explains "how to solve the ORACLE 18C startup database error ORA-04031", the content of the article is simple and clear, easy to learn and understand, the following please follow the editor's ideas slowly in depth, together to study and learn "how to solve the ORACLE 18C startup database error ORA-04031" bar!

Database version: single instance 18.5.0.0.190115

Operating system version: Centos 7.5

Newly installed database software, newly created database, 16G host memory, allocated SGA:6G PGA:2G, started OEM, did not deliver to the business, began to report that there was insufficient memory. It's very strange:

Find on MOS: ID:2247789.1

New 12.2.0.1.0 release database running EM Express 12c Database Administration Page

Solution:

Increasing the database granule size resolved the error in this case.

1. Connect to the database as SYSDBA.

2. Issue command:

SQL > alter system set "_ ksmg_granule_size" = 33554432 scope=spfile

3. Re-start the instance so the change takes effect

Thank you for your reading, the above is the content of "how to solve ORACLE 18C startup database error ORA-04031". After the study of this article, I believe you have a deeper understanding of how to solve the problem of ORACLE 18C startup database error ORA-04031. The specific use of the situation also needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.