Fri Jan 09 03:11:17 2015
DIAG started with pid=19, OS id=6031
Dumping diagnostic data in directory=[cdmp_20150109031118], requested by (instance=1, osid=2456 (CJQ0)), summary=[incident=45657].
Mon Feb 09 01:51:09 2015
Adjusting the default value of parameter parallel_max_servers
from 160 to 120 due to the value of parameter processes (150) --->自动调整parallel_max_servers参数
Starting ORACLE instance (normal)
************************ Large Pages Information *******************
Per process system memlock (soft) limit = 64 KB
?
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)
Large Pages configured system wide = 0 (0 KB)
Large Page size = 2048 KB
?
RECOMMENDATION:--->推荐设置
? Total System Global Area size is 1026 MB. For optimal performance,
? prior to the next instance restart:
? 1. Increase the number of unused large pages by
?at least 513 (page size 2048 KB, total size 1026 MB) system wide to
? get 100% of the System Global Area allocated with large pages
? 2. Large pages are automatically locked into physical memory.
?Increase the per process memlock (soft) limit to at least 1034 MB to lock
?100% System Global Area's large pages into physical memory
********************************************************************
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Initial number of CPU is 4? --->启动时的cpu个数
CELL communication is configured to use 0 interface(s):
CELL IP affinity details:
? ? NUMA status: non-NUMA system--->启动时的NUMA信息
? ? cellaffinity.ora status: N/A
CELL communication will use 1 IP group(s):
? ? Grp 0:
Picked latch-free SCN scheme 3
Using LOG_ARCHIVE_DEST_1 parameter default value as /u02/app/oracle/product/11.2.0.4/db_1/dbs/arch
Autotune of undo retention is turned on.
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
ORACLE_HOME = /u02/app/oracle/product/11.2.0.4/db_1
System name:?Linux
Node name:?rhel63single
Release:?2.6.32-279.el6.x86_64 --->linux 的内核版本号
Version:?#1 SMP Wed Jun 13 18:24:36 EDT 2012
Machine:?x86_64
VM name:?VMWare Version: 6 --->主机是 vm虚拟机，vm虚拟机的版本
Using parameter settings in server-side spfile /u02/app/oracle/product/11.2.0.4/db_1/dbs/spfiletest.ora
System parameters with non-default values:--->上一行是启动时的所读取的spfile文件的位置
? processes? ? ? ? ? ? ? ? = 150
? sga_max_size? ? ? ? ? ? = 1G
? shared_pool_size? ? ? ? = 256M
? java_pool_size? ? ? ? ? = 256M
? sga_target? ? ? ? ? ? ? = 1G
? control_files? ? ? ? ? ? = "/u01/app/oracle/oradata/test/control01.ctl"
? control_files? ? ? ? ? ? = "/u01/app/oracle/oradata/test/control02.ctl"
? db_block_size? ? ? ? ? ? = 8192
? compatible? ? ? ? ? ? ? = "11.2.0.0.0"
? undo_tablespace? ? ? ? ? = "UNDOTBS1"
? remote_login_passwordfile= "EXCLUSIVE"
? db_domain? ? ? ? ? ? ? ? = ""
? dispatchers? ? ? ? ? ? ? = "(PROTOCOL=TCP) (SERVICE=testXDB)"
? audit_file_dest? ? ? ? ? = "/u01/app/oracle/admin/test/adump"
? audit_trail? ? ? ? ? ? ? = "DB"
? db_name? ? ? ? ? ? ? ? ? = "test"
? open_cursors? ? ? ? ? ? = 300
? pga_aggregate_target? ? = 96M
? diagnostic_dest? ? ? ? ? = "/u01/app/oracle"
Mon Feb 09 01:51:13 2015
PMON started with pid=2, OS id=2397
Mon Feb 09 01:51:13 2015
PSP0 started with pid=3, OS id=2399
Mon Feb 09 01:51:15 2015
VKTM started with pid=4, OS id=2401 at elevated priority
Mon Feb 09 01:51:15 2015
GEN0 started with pid=5, OS id=2405
VKTM running at