WIN XP ,ORACLE 9.2
1、P1TEXT
Description of first additional parameter
P1、P2、P3 看了解释也不明白是什么意思?还有这句话(Description of first additional parameter)是什么意思?
2、SECONDS_IN_WAIT
If WAIT_TIME > 0, then SECONDS_IN_WAIT is the seconds since the start of the last wait, and SECONDS_IN_WAIT -WAIT_TIME / 100 is the active seconds since the last wait ended.
这句话的意思:如果WAIT_TIME >0,则SECONDS_IN_WAIT的时间是从上次等待开始以来的时间,SECONDS_IN_WAIT -WAIT_TIME / 100(这个WAIT_TIME和v$session_event中的MAX_WAIT等一样是以百秒为单位?)是上次等待结束以来的时间,是这么理解嘛?
3、STATE
Wait state:
0 - WAITING (the session is currently waiting)
-2 - WAITED UNKNOWN TIME (duration of last wait is unknown)
-1 - WAITED SHORT TIME (last wait 0 - WAITED KNOWN TIME (WAIT_TIME = duration of last wait)
其中前面的0 -1 -2 >0 是否是wait_time 的值,如果是这样,为什么我的试图中显示:
Wait_time:-1而STATE:WAITED KNOWN TIME对应的值不一样啊
有那位朋友有中文的参数和数据字典说明的文档,能否提供一份,谢谢了。