Monday, May 4, 2020

DB TIME

https://www.oracle.com/technetwork/oem/db-mgmt/s317294-db-perf-tuning-with-db-time-181631.pdf


DB TIME REPRESENTS THE TOTAL TIME :


DB TIME= DB WAIT TIME + DB CPU TIME 



Time Model


The time model is a set of statistics that give an overview of where time is spent inside the Oracle Database: 

We can check below two views for time model statistics:
V$SYS_TIME_MODEL
V$SESS_TIME_MODEL


  • DB Time represents the total time.
  • Spent in database calls by user sessions.
  • A tuning goal is to reduce DB time.
  • Using DB time, you can gauge the performance impact of any entity of the database.



Sessions:

V$SESSTAT ==>  All sessions
V$MYSTAT ==> Current session

Services:

V$SERVICE_STATS

SYSTEM:


V$SESSTAT








No comments:

Post a Comment

student guide Dataguard: GLOBAL_DBNAME = <dbuniquename>_DGMGRL.example.com  Example: listener.ora on Primary Hosts Static listener ent...