# 44370
lx
|
|
To: eygle
10g中怎样捕获运行时间长的sql?是根据v$sqlarea判断吗?
From: lx 2009.05.07 19:28
|
|
|
|
To: lx
用AWR做报告出来最好了!
From: eygle 2009.05.07 20:17
|
|
|
|
# 44363
learner
|
|
To: eygle
eygle,你是否遇到这种问题:
从V$sqlarea中抓到的version_count很高,接近1000个,而且这种sql不是一条,有几十甚至上百条,我遇到的2个数据库都有此类问题,(oracle 9.2.0.6~08) 64位,cursor_sharing=SIMILAR,系统也没有收集柱状图信息
From: learner 2009.05.05 01:31
|
|
|
|
To: learner
这种纯霰冉掀毡椋绕涫巧柚昧薱ursor_sharing之后,不奇怪
From: eygle 2009.05.05 18:10
|
|
|
|
|