11.2.0.3 例項啟動報大記憶體頁資訊
資料庫啟動日誌資訊:
Instance terminTue Apr 29 06:40:21 2014
Adjusting the default value of parameter parallel_max_servers
from 640 to 485 due to the value of parameter processes (500)
Starting ORACLE instance (normal)
****************** Large Pages Information *****************
Total Shared Global Region in Large Pages = 0 KB (0%)
Large Pages used by this instance: 0 (0 KB)
Large Pages unused system wide = 0 (0 KB) (alloc incr 16 MB)
Large Pages configured system wide = 0 (0 KB)
Large Page size = 2048 KB
RECOMMENDATION:
Total Shared Global Region size is 7586 MB. For optimal performance,
prior to the next instance restart increase the number
of unused Large Pages by atleast 3793 2048 KB Large Pages (7586 MB)
system wide to get 100% of the Shared
Global Region allocated with Large pages
***********************************************************
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =86
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
ORACLE_HOME = /home/oracle/app/oracle/product/11.2.0/dbhome_1
System name: Linux
Node name: *****
Release: 2.6.32-358.2.1.el6.x86_64
Version: #1 SMP Wed Mar 13 00:26:49 UTC 2013
Machine: x86_64
Using parameter settings in server-side spfile /home/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/spfileictmap2.ora
System parameters with non-default values:
最近雙機自動切換,不知道跟這個有沒有關係?
Instance terminTue Apr 29 06:40:21 2014
Adjusting the default value of parameter parallel_max_servers
from 640 to 485 due to the value of parameter processes (500)
Starting ORACLE instance (normal)
****************** Large Pages Information *****************
Total Shared Global Region in Large Pages = 0 KB (0%)
Large Pages used by this instance: 0 (0 KB)
Large Pages unused system wide = 0 (0 KB) (alloc incr 16 MB)
Large Pages configured system wide = 0 (0 KB)
Large Page size = 2048 KB
RECOMMENDATION:
Total Shared Global Region size is 7586 MB. For optimal performance,
prior to the next instance restart increase the number
of unused Large Pages by atleast 3793 2048 KB Large Pages (7586 MB)
system wide to get 100% of the Shared
Global Region allocated with Large pages
***********************************************************
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =86
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
ORACLE_HOME = /home/oracle/app/oracle/product/11.2.0/dbhome_1
System name: Linux
Node name: *****
Release: 2.6.32-358.2.1.el6.x86_64
Version: #1 SMP Wed Mar 13 00:26:49 UTC 2013
Machine: x86_64
Using parameter settings in server-side spfile /home/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/spfileictmap2.ora
System parameters with non-default values:
最近雙機自動切換,不知道跟這個有沒有關係?
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/22969361/viewspace-1151343/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- centos 開啟大頁記憶體CentOS記憶體
- 記憶體_大頁記憶體記憶體
- 探索MYSQL開啟大頁記憶體MySql記憶體
- 【大頁記憶體】Oracle資料庫配置大頁記憶體記憶體Oracle資料庫
- 啟動ASM 例項報錯ASM
- 解決記憶體設定過大導致例項無法啟動ORA-27100記憶體
- oracle 例項記憶體結構Oracle記憶體
- 2 Day DBA-管理Oracle例項-管理記憶體-修改記憶體設定-自動記憶體管理Oracle記憶體
- Oracle資料庫例項在AIX 平臺下使用大頁記憶體(Large Page Memory)Oracle資料庫AI記憶體
- JS記憶體洩漏例項解析JS記憶體
- openGauss-大頁記憶體記憶體
- App啟動頁設計例項和技巧,啟動即讓人心動APP
- 記憶體洩露例項分析 -- Android記憶體優化第四彈記憶體洩露Android優化
- 2 Day DBA-管理Oracle例項-管理記憶體-關於記憶體管理Oracle記憶體
- oracle例項記憶體(SGA和PGA)調整Oracle記憶體
- C++記憶體池的實現例項C++記憶體
- Oracle 11.2.0.3 管理ASM例項OracleASM
- Oracle 11.2.0.3管理ASM例項OracleASM
- 2 Day DBA-管理Oracle例項-關於例項記憶體結構Oracle記憶體
- Oracle 11g RAC的ASM例項記憶體引數被修改導致無法啟動OracleASM記憶體
- oracle 10203啟動例項報警Oracle
- dubbo啟動報錯,反射例項化問題反射
- Oracle 11gR2 ASM例項記憶體管理OracleASM記憶體
- 基礎知識1——例項記憶體結構記憶體
- Pooled Allocation(池式分配)例項——Keil 記憶體管理記憶體
- 如何在redhat5為oracle啟用及配置hugepage大頁記憶體RedhatOracle記憶體
- 適用於大型記憶體資料庫的 Amazon EC2 大記憶體 U7i 例項簡介記憶體資料庫
- 用例項帶你深入理解Java記憶體模型Java記憶體模型
- Java 中 ThreadLocal 記憶體洩露的例項分析Javathread記憶體洩露
- Oracle例項的程式結構和記憶體結構Oracle記憶體
- (譯) 記憶體補丁的製作例項-修改WDASM記憶體ASM
- 開啟oracle記憶體自動化管理Oracle記憶體
- 自動共享記憶體管理 自動記憶體管理 手工記憶體管理記憶體
- 【JVM之記憶體與垃圾回收篇】物件例項化記憶體佈局與訪問定位JVM記憶體物件
- 使用SRVCTL啟動例項與使用sqlplus啟動例項的區別SQL
- linux報告虛擬記憶體統計資訊-vmstatLinux記憶體
- 2 Day DBA-管理Oracle例項-關於例項的啟動和關閉-關於例項啟動Oracle
- 物件的例項化、記憶體佈局以及訪問定位物件記憶體