Database Tuning (MOSC)

MOSC Banner

db time

edited Nov 7, 2016 12:05AM in Database Tuning (MOSC) 5 commentsAnswered

Time Model Statistics

  • Total time in database user-calls (DB Time): 36880.7s
  • Statistics including the word "background" measure background process   time, and so do not contribute to the DB time statistic
  • Ordered by % or DB time desc, Statistic name
Statistic NameTime (s)% of DB Time
sql execute elapsed time27,671.8375.03
DB CPU16,725.0945.35
PL/SQL execution elapsed time3,266.648.86
inbound PL/SQL rpc elapsed time898.482.44
parse time elapsed262.920.71
hard parse elapsed time74.020.20
connection management call elapsed time37.410.10
hard parse (sharing criteria) elapsed time16.280.04
RMAN cpu time (backup/restore)7.800.02
failed parse elapsed time7.570.02
PL/SQL compilation elapsed time7.160.02
repeated bind elapsed time3.650.01
sequence load elapsed time

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center