解決Heap size *K exceeds notification threshold(2048K)
Memory Notification: Library Cache Object loaded into SGA
Heap size 3827K exceeds notification threshold (2048K)
原因:
Oracle 10.2.0.1,隱含引數_kgl_large_heap_warning_threshold預設值為2m,過小;在10.2.0.2中預設值修改為50m;
解決辦法:
將引數_kgl_large_heap_warning_threshold值修改為50m(或0以及其他較大值),過程如下
1、登入資料庫
$ sqlplus "/ as sysdba"
2、設定_kgl_large_heap_warning_threshold 引數
SQL> alter system set "_kgl_large_heap_warning_threshold"=52428800 scope=spfile;
3、重啟資料庫
SQL> shutdown immediate
SQL> startup
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/16978544/viewspace-692270/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Heap size 2498K exceeds notification threshold (2048K) 問題處理
- Library Cache Object loaded into SGA Heap size 2226K exceeds notification threshold (2048K)Object
- Memory Notification: Library Cache Object loaded into SGA Heap size 2098K exceeds notification thresObject
- ORA-27092: skgfofi: size of file exceeds file size limit of the processMIT
- Setting Tomcat Heap Size (JVM Heap) in EclipseTomcatJVMEclipse
- [LeetCode] 1343. Number of Sub-arrays of Size K and Average Greater than or Equal to ThresholdLeetCode
- 【Linux】bad geometry: block count 11796480 exceeds size of deviceLinuxBloCdev
- Archery 平臺執行DDL error:Threads_connected exceeds its critical thresholdErrorthread
- 解決"Could not reserve enough space for object heap"Object
- ERROR 1206 (HY000): The total number of locks exceeds the lock table sizeError
- java.lang.OutOfMemoryError: Java heap space的解決JavaError
- eclipse java.lang.OutOfMemoryError: Java heap space 解決方案EclipseJavaError
- Android Notification 詳解Android
- MySQL 5.7從庫報錯exceeds of slave_pending_jobs_size_max. Error_code: 1864MySqlError
- 解決yarn打包時出現“FATAL ERROR: Reached heap limit Allocation failed - JavaScript heap out of memory”的問題YarnErrorMITAIJavaScript
- 由node的批量requests引起的”heap out of memory”解決方案
- android錯誤unable to execute dex java heap space解決方案AndroidJava
- EM 12c 修改 EMGC_OMS1的 java heap size (JVM大小) - 2GCJavaJVM
- EM 12c 修改EMGC_OMS1的 java heap size (JVM大小) - 1GCJavaJVM
- oreo上的notification詳解
- Android Notification 通知詳解Android
- Mysql 報Row size too large 65535解決方法MySql
- Row size too large (> 8126)解決辦法
- 【BBED】使用bbed解決 the amount of space used is not equal to block sizeBloC
- linux 中的localhost kernel: CPU1: Temperature above threshold 錯誤解決Linuxlocalhost
- LeetCode-Maximum Size Subarray Sum Equals kLeetCode
- Allowed memory size of 134217728 bytes 錯誤解決心得
- 啟動Amoeba報The stack size specified is too small解決方法
- [轉]Android 通知Notification 詳解Android
- antd原始碼解讀(10)- notification原始碼
- MySQL資料庫index column size too large. the maximum column size is 767 bytes問題解決MySql資料庫Index
- iis 0x80070032 Cannot read configuration file because it exceeds the maximum file size
- [Windows無法連線到 System Event Notification Service服務]解決方案Windows
- Oracle ORA-01948:identifier's name length(%s)exceeds maximum(%s)報錯的解決OracleIDE
- 解決Eclipse和MyEclipsejava.lang.OutOfMemoryError Java heap space的錯誤EclipseJavaError
- Jmeter記憶體溢位:java.lang.OutOfMemoryError: Java heap space解決思路JMeter記憶體溢位JavaError
- 帝國CMSr的Fatal error:Allowed memory size of的解決辦法Error
- elasticsearch的Java Heap Size設定大於32G對效能的影響因素列舉ElasticsearchJava