Which two statements are true about Active Session Hist…

Which two statements are true about Active Session History (ASH)?(Choose two.)

Which two statements are true about Active Session History (ASH)?(Choose two.)

A.
The Data Sample size available in an ASH report is dynamic and, at any given moment,
is directly related to the amount of work being performed.

B.
ASH contains sampled data from all sessions that are connected to a database instance at
any given moment.

C.
ASH samples data from V$SESSION every second.

D.
An ASH report can be used to identify the service that may be the cause of a transient
performance problem.



Leave a Reply 8

Your email address will not be published. Required fields are marked *


vasta

vasta

I don’t think that ASH samples v$session EVERY SECOND.
So C is not correct.

duong.ora

duong.ora

CD
Performance Management Tuning 12c – Student Guide (7-32):
It would be very expensive to record all activities of all sessions. The ASH extracts only samples of information from V$SESSION. One sample is extracted every second.

Fonx

Fonx

Yes I swear : every second in V$ACTIVE_SESSION_HISTORY and then sampled to 1/10 to DBA_HIST8ACTIVE_SESS_HISTORY

A may deal with the ASH buffer wich is circular and “fixed size”. So when it is full, it is sampled to DBA_HIST_ACTIVE_SESS_HISTORY.
So A would be typically wrong : sample size does not depend on workload

So CD