Fri Jun 14 03:20:03 2013
Memory Notification: Library Cache Object loaded into SGA
Heap size 2322K exceeds notification threshold (2048K)
KGL object name :XDB.XDbD/PLZ01TcHgNAgAIIegtw== Fri Jun 14 13:06:46 2013
Thread 1 advanced to log sequence 824
Current log# 1 seq# 824 mem# 0: E:\ORACLE\PRODUCT\10.2.0\ORADATA\CONCRETE\REDO01.LOG
Dump file e:\oracle\product\10.2.0/admin/concrete/bdump\alert_concrete.log
Fri Jun 14 21:09:55 2013
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows Server 2003 Version V5.2 Service Pack 2
CPU : 4 - type 586, 1 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:3568M/3920M, Ph+PgF:5620M/5796M, VA:1937M/2047M
Fri Jun 14 21:09:55 2013
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
processes = 150
__shared_pool_size = 88080384
__large_pool_size = 4194304
__java_pool_size = 4194304
__streams_pool_size = 0
spfile = E:\ORACLE\PRODUCT\10.2.0\DB_1\DBS\SPFILECONCRETE.ORA
sga_target = 612368384
control_files = E:\ORACLE\PRODUCT\10.2.0\ORADATA\CONCRETE\CONTROL01.CTL, E:\ORACLE\PRODUCT\10.2.0\ORADATA\CONCRETE\CONTROL02.CTL, E:\ORACLE\PRODUCT\10.2.0\ORADATA\CONCRETE\CONTROL03.CTL
db_block_size = 8192
__db_cache_size = 507510784
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 16
db_recovery_file_dest = E:\oracle\product\10.2.0/flash_recovery_area
db_recovery_file_dest_size= 2147483648
undo_management = AUTO
undo_tablespace = UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain =
dispatchers = (PROTOCOL=TCP) (SERVICE=CONCRETEXDB)
job_queue_processes = 10
audit_file_dest = E:\ORACLE\PRODUCT\10.2.0\ADMIN\CONCRETE\ADUMP
background_dump_dest = E:\ORACLE\PRODUCT\10.2.0\ADMIN\CONCRETE\BDUMP
user_dump_dest = E:\ORACLE\PRODUCT\10.2.0\ADMIN\CONCRETE\UDUMP
core_dump_dest = E:\ORACLE\PRODUCT\10.2.0\ADMIN\CONCRETE\CDUMP
db_name = CONCRETE
open_cursors = 300
pga_aggregate_target = 203423744
PSP0 started with pid=3, OS id=1028
MMAN started with pid=4, OS id=628
DBW0 started with pid=5, OS id=984
LGWR started with pid=6, OS id=1040
CKPT started with pid=7, OS id=1092
SMON started with pid=8, OS id=1116
RECO started with pid=9, OS id=1120
CJQ0 started with pid=10, OS id=1108
MMON started with pid=11, OS id=736
MMNL started with pid=12, OS id=1128
数据库是在这段时间内down的机,帮忙看一下是哪里出了问题,是不是这一段:
Heap size 2322K exceeds notification threshold (2048K)超过了默认值2M导致down机的???
Memory Notification: Library Cache Object loaded into SGA
Heap size 2322K exceeds notification threshold (2048K)
KGL object name :XDB.XDbD/PLZ01TcHgNAgAIIegtw== Fri Jun 14 13:06:46 2013
Thread 1 advanced to log sequence 824
Current log# 1 seq# 824 mem# 0: E:\ORACLE\PRODUCT\10.2.0\ORADATA\CONCRETE\REDO01.LOG
Dump file e:\oracle\product\10.2.0/admin/concrete/bdump\alert_concrete.log
Fri Jun 14 21:09:55 2013
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows Server 2003 Version V5.2 Service Pack 2
CPU : 4 - type 586, 1 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:3568M/3920M, Ph+PgF:5620M/5796M, VA:1937M/2047M
Fri Jun 14 21:09:55 2013
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
processes = 150
__shared_pool_size = 88080384
__large_pool_size = 4194304
__java_pool_size = 4194304
__streams_pool_size = 0
spfile = E:\ORACLE\PRODUCT\10.2.0\DB_1\DBS\SPFILECONCRETE.ORA
sga_target = 612368384
control_files = E:\ORACLE\PRODUCT\10.2.0\ORADATA\CONCRETE\CONTROL01.CTL, E:\ORACLE\PRODUCT\10.2.0\ORADATA\CONCRETE\CONTROL02.CTL, E:\ORACLE\PRODUCT\10.2.0\ORADATA\CONCRETE\CONTROL03.CTL
db_block_size = 8192
__db_cache_size = 507510784
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 16
db_recovery_file_dest = E:\oracle\product\10.2.0/flash_recovery_area
db_recovery_file_dest_size= 2147483648
undo_management = AUTO
undo_tablespace = UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain =
dispatchers = (PROTOCOL=TCP) (SERVICE=CONCRETEXDB)
job_queue_processes = 10
audit_file_dest = E:\ORACLE\PRODUCT\10.2.0\ADMIN\CONCRETE\ADUMP
background_dump_dest = E:\ORACLE\PRODUCT\10.2.0\ADMIN\CONCRETE\BDUMP
user_dump_dest = E:\ORACLE\PRODUCT\10.2.0\ADMIN\CONCRETE\UDUMP
core_dump_dest = E:\ORACLE\PRODUCT\10.2.0\ADMIN\CONCRETE\CDUMP
db_name = CONCRETE
open_cursors = 300
pga_aggregate_target = 203423744
PSP0 started with pid=3, OS id=1028
MMAN started with pid=4, OS id=628
DBW0 started with pid=5, OS id=984
LGWR started with pid=6, OS id=1040
CKPT started with pid=7, OS id=1092
SMON started with pid=8, OS id=1116
RECO started with pid=9, OS id=1120
CJQ0 started with pid=10, OS id=1108
MMON started with pid=11, OS id=736
MMNL started with pid=12, OS id=1128
数据库是在这段时间内down的机,帮忙看一下是哪里出了问题,是不是这一段:
Heap size 2322K exceeds notification threshold (2048K)超过了默认值2M导致down机的???
解决方案 »
- Oracle Berkely DB 模糊搜索的问题
- Oracle高手进啊
- SQL防注入
- Orcale存储过程加工资sql?
- 问一个很怪的问题
- 求助!这语句那里错了 ORACLE 语法不熟啊 T_T
- 通过jdbc访问Oracle出现错误,请指点:
- 监听服务无法启动问题高分求解
- 各位有沒有PL/SQL的電子檔教程或參考資料.必感激!
- 新手求教Oracle嵌套查询的问题
- oracle 11g的SQLDevelop报12505错误,但是使用SQL*PLUS可以正常连接?
- illegal lob length marker 54485 IMP-00098: INTERNAL ERROR: impgst2
这个错误可以忽略