# 45806
heye
|
|
To:
盖老师,请教下面的问题怎么解决,谢谢啊
警告日志报错如下:
Sun Aug7 22:49:30 2011
Errors in file /oracle/products/admin/bistore1/bdump/bistore1_m000_467058.trc:
ORA-00600: internal error code, arguments: [kdappurgeostat1], [365002], [], [], [], [], [], []
bistore1_m000_467058.trc 文件如下:
Dump file /oracle/products/admin/bistore1/bdump/bistore1_m000_467058.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining Scoring Engine and Real Application Testing options
ORACLE_HOME = /oracle/products/10.2/db
System name:AIX
*** ACTION NAMEAuto-Purge Slave Action) 2011-08-07 22:49:30.406
*** MODULE NAMEMMON_SLAVE) 2011-08-07 22:49:30.406
*** SERVICE NAMESYS$BACKGROUND) 2011-08-07 22:49:30.406
*** SESSION ID1082.532) 2011-08-07 22:49:30.406
*** 2011-08-07 22:49:30.406
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [kdappurgeostat1], [365002], [], [], [], [], [], []
From: heye 2011.08.11 20:28
|
|
|
|
# 45803
zyl
|
|
To: eygle
盖老师,你好。看了你写的orastress压力测试文章,你写到:
这里我建议对单节点数据库分别采用1,2,3,5,10个Warehouses进行1,2,4,6,10个并发的50000个事务的测试.
对于多节点RAC建议采用1,2,3,5,10个Warehouses进行1,3,4,7,10个并发的50000个事务的测试.
那我现在想对一个40C的机器进行测试的话,50个会话,或者100个会话进行并发压力测试,是否就要安装50或者100个Warehouses?
还想问一下,40C的机器,多少并发会话才合适了?
From: zyl 2011.08.04 01:57
|
|
|
|
# 45798
N神
|
|
To:
egyle帅哥
您好
请教一下两个关于library cache latches两个问题
一、在什么时候需要获得library cache latches,在什么时候会释放library cache latches呢?
二、硬解析过程会一直持着library cache latches吗?
From: N神 2011.07.27 23:00
|
|
|
|
To: N神
在SQL解析过程中,会多次持有和释放Library Cache Latch,而且是不同的级别。
硬解析过程当然不会一直持有,那样数据库就锁死了。在判断SQL能否软解析时,需要持有,然后释放。在保存SQL到SGA中,也要获得。
From: eygle 2011.08.03 19:51
|
|
|
|
|