You notice that the performance of your production 24/7 Oracle database significantly degraded.
Sometimes you are not able to connect to the instance because it hangs. You do not want to
restart the database instance.
How can you detect the cause of the degraded performance?
A.
Enable Memory Access Mode, which reads performance data from SGA.
B.
Use emergency monitoring to fetch data directly from SGA analysis.
C.
Run Automatic Database Diagnostic Monitor (ADDM) to fetch information from the latest
Automatic Workload Repository (AWR) snapshots.
D.
Use Active Session History (ASH) data and hang analysis in regular performance monitoring.
E.
Run ADDM in diagnostic mode.
Explanation:
* In most cases, ADDM output should be the first place that a DBA looks when
notified of a performance problem.
* Performance degradation of the database occurs when your database was performing optimally
in the past, such as 6 months ago, but has gradually degraded to a point where it becomes
noticeable to the users. The Automatic Workload Repository (AWR) Compare Periods report
enables you to compare database performance between two periods of time.
While an AWR report shows AWR data between two snapshots (or two points in time), the AWR
Compare Periods report shows the difference between two periods (or two AWR reports with a
total of four snapshots). Using the AWR Compare Periods report helps you to identify detailed
performance attributes and configuration settings that differ between two time periods.
Reference: Resolving Performance Degradation Over Time
Answer should be B. Once user is not able to connect, he cant generate a ADDM report. Also normal ADDM report will not give the latest data as the AWR might be very old.
The other alternate would be to run Real-time ADDM which uses ASH for latest data. But as Real time ADDM is not in option, the answer should be “Emergency Monitoring”
“SOMETIMES you are not able to connect”. so it is possible )
May be E because we can connect ADDM in diagnostic mode while normal system is very slow or while some time you are not unable to connect.
B:
Emergency Monitoring allows DBAs with SYSDBA credentials to connect in diagnostic mode and have a quick, lightweight analysis to check who is blocking the database, why it is hanging. This type of connection does not require I/O nor global resources.
[B]
“Emergency Monitoring
The Emergency Monitoring feature enables the database administrator to connect to an unresponsive database through a special proprietary mechanism and diagnose performance issues when normal mode connection is not possible. It has an in-built hang analysis capability that enables you to identify blocking sessions and kill these blockers with a click of a button.”
Source: http://docs.oracle.com/cd/E36909_01/doc.1111/e25353/whats_new.htm
I believe it’s E
There has no tool called emergency monitoring. It just another mode for ADDM.
Real-Time ADDM uses two types of connections
Normal mode: A normal JDBC connection is intended to perform extensive performance analysis when some connectivity is available.
Emergency mode: The diagnostic mode which makes a latch-less connection is useful for extreme hang situations when normal connection is not possible.
I read in the “Oracle Database 12c: New Features for Administrators” guide that Emergency Monitoring is the first action to perform in case database is hanging. Real Time ADDM helps to go deeper if Emergency Monitoring doesn’t help, but this is not an option here as said by Sunil.
Concerning E, Real Time ADDM has a diagnostic mode, but not regular ADDM. Real Time ADDM and ADDM are not similar. So I would not select E as a good response here…
If we really can’t login to the database I would say B is correct.
Emergency Monitoring
The Emergency Monitoring feature enables the database administrator to connect to an unresponsive database through a special proprietary mechanism and diagnose performance issues when normal mode connection is not possible. It has an in-built hang analysis capability that enables you to identify blocking sessions and kill these blockers with a click of a button.
http://docs.oracle.com/cd/E36909_01/doc.1111/e25353/whats_new.htm
I think that is “E”
This is not about “Oracle Enterprise Manager Cloud Control 12c”
http://learncertification.com/study-materials/Upgrade-to-Oracle-Database-12c–1Z0-060-/47/Perform-emergency-monitoring-and-real-time-ADDM/1231
Please take a look at the web-sites we comply with, including this a single, as it represents our picks in the web.
usually posts some pretty interesting stuff like this. If youre new to this site
one of our guests a short while ago encouraged the following website
The info mentioned in the post are several of the ideal offered
We came across a cool site that you just could possibly appreciate. Take a appear if you want.
usually posts some very fascinating stuff like this. If you are new to this site
Great web sitewebsite! It looks extremely professional! Maintain the great work!
nfl 17 coins http://www.xueliangyy.com/comment/html/index.php?page=1&id=136413
very few websites that happen to be comprehensive beneath, from our point of view are undoubtedly well really worth checking out
Here is an excellent Blog You may Locate Exciting that we Encourage You
The information mentioned within the post are a number of the most beneficial out there
we like to honor quite a few other web web-sites on the net, even though they arent linked to us, by linking to them. Underneath are some webpages worth checking out
Wonderful story, reckoned we could combine a couple of unrelated information, nonetheless really worth taking a appear, whoa did one learn about Mid East has got far more problerms too
always a large fan of linking to bloggers that I appreciate but do not get a good deal of link adore from
B
B as the question says not able to connect to database
B