Which three statements are true about Automatic Workload Repository (AWR)?
A.
All AWR tables belong to the SYSTEM schema.
B.
The AWR data is stored in memory and in the database.
C.
The snapshots collected by AWR are used by the self-tuning components in the database
D.
AWR computes time model statistics based on time usage for activities, which are displayed in
the v$SYS time model and V$SESS_TIME_MODEL views.
E.
AWR contains system wide tracing and logging information.
Explanation:
* A fundamental aspect of the workload repository is that it collects and persists
database performance data in a manner that enables historical performance analysis.
The mechanism for this is the AWR snapshot. On a periodic basis, AWR takes a
“snapshot” of the current statistic values stored in the database instance’s memory
and persists them to its tables residing in the SYSAUX tablespace.
* AWR is primarily designed to provide input to higherlevel components such as automatic tuning
algorithms and advisors, but can also provide a wealth of information for the manual tuning
process.
B, C, D.
The statistics collected and processed by AWR include: Time model statistics based on time usage for activities, displayed in the V$SYS_TIME_MODEL and V$SESS_TIME_MODEL views
http://docs.oracle.com/cd/B28359_01/server.111/b28274/autostat.htm
Agree B,C,D
It is CDE. AWR data is collected from snapshots and information gathered from the snapshots are stored in sysaux tablespace. So, AWR data is not stored from memory.
It is B,C,D
Check the link – http://docs.oracle.com/cd/E11882_01/server.112/e41573/autostat.htm#PFGRF02601
Section 5.2 Overview of AWR
The given answer, BCE is wrong.
The AWR tables are owned by SYS, not SYSTEM. Check:
select OCCUPANT_NAME,OCCUPANT_DESC, SCHEMA_NAME from v$sysaux_occupants where occupant_name = ‘SM/AWR’; So A is untrue.
The AWR data is held in memory before being written out to persistent disk storage in the form of a snapshot. So B is true.
The snapshots collected by AWR are used by the self-tuning components. So C is true.
AWR does have a relationship with V$SYS_TIME_MODEL and V$SESS_TIME_MODEL. Check the link provided by winner2001. So D is correct.
System wide tracing and logging is stored in the ADR, not the AWR. So E is untrue. Correct answer, BCD.
H*T*H
B,C AND D – is TRUE
B, C and D
Wow cuz this is really helpfulexcellent work! Congrats and keep it up
csgo skins http://hutcoinsexperts.ucoz.com/blog/buy_csgo_knives_almost_always_involve_guns/2016-06-18-27
Every when in a whilst we decide on blogs that we study. Listed beneath would be the most up-to-date internet sites that we choose.
Usually posts some very interesting stuff like this. If youre new to this site.
Sites of interest we’ve a link to
check below, are some totally unrelated web sites to ours, nonetheless, they may be most trustworthy sources that we use
Wonderful story, reckoned we could combine a number of unrelated data, nonetheless seriously worth taking a appear, whoa did one study about Mid East has got more problerms at the same time
please go to the sites we adhere to, like this 1, as it represents our picks from the web
below you will come across the link to some websites that we think you’ll want to visit
The data mentioned within the article are a few of the best obtainable
Here are a number of the web sites we advocate for our visitors
very handful of websites that take place to become comprehensive beneath, from our point of view are undoubtedly properly worth checking out
although internet websites we backlink to below are considerably not associated to ours, we feel they are really really worth a go by, so have a look
below youll uncover the link to some web-sites that we consider you’ll want to visit
BCD