ITPub博客

首页 > 数据库 > Oracle > db time and db cpu

db time and db cpu

原创 Oracle 作者:xychong123 时间:2017-09-04 09:22:26 0 删除 编辑
详细描述信息可以参考官方手册:(V$SESS_TIME_MODEL)

 

DB Time
Amount of elapsed time (in microseconds) spent performing Database user-level calls. This does not include the elapsed time spent on instance background processes such as PMON.
DB CPU
Amount of CPU time (in microseconds) spent on database user-level calls. This does not include the CPU time spent on instance background processes such as PMON.



-----------------
1) background elapsed time
    2) background cpu time
          3) RMAN cpu time (backup/restore)
1) DB time
    2) DB CPU
    2) connection management call elapsed time
    2) sequence load elapsed time
    2) sql execute elapsed time
    2) parse time elapsed
          3) hard parse elapsed time
                4) hard parse (sharing criteria) elapsed time
                    5) hard parse (bind mismatch) elapsed time
          3) failed parse elapsed time
                4) failed parse (out of shared memory) elapsed time
    2) PL/SQL execution elapsed time
    2) inbound PL/SQL rpc elapsed time
    2) PL/SQL compilation elapsed time
    2) Java execution elapsed time
    2) repeated bind elapsed time

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/20747382/viewspace-2144456/ ,如需转载,请注明出处,否则将追究法律责任。

下一篇: redo log 恢复
请登录后发表评论 登录
全部评论

注册时间:2015-06-10

  • 博文量
    118
  • 访问量
    120448