There are numerous changes in Database Control pertaining to databaseperformance. Since Oracle Database 11g has introduced several newperformance features, Database Control will,of course,support those newfeatures.Our focus is on the main changes to the Performance page in Database Control.
Customized Performance Page
You can now set up a customized Database Performance page in Database Control to suit your purposes.Database Control stores the customized settings in its repository and retrieves them for your session’s use when you log in again.You can customize things such as which charts appear on the Performance page in the Active Sessions section.You can also configure whether baseline values should appear in the Throughput and Services charts.
Click the Settings link to go to the Performance Page Settings page.ThePerformance Page Settings page has two sections.The Detailed Chart Settings section lets you choose defaults for displaying the instance activity charts.The Baseline Display Settings section lets you select if and how the AWR baseline values are displayed in the Performance page charts.
The Detailed Chart Settings section on the Performance Page Settings page lets you make the following display choices for the Performance page:
Here are the steps to follow to change the display of the instance activitycharts:
The Performance Page Settings page that appears now will reflect the new display choices you made,as shown in Figure
The Performance Page Settings page
Average Active Sessions
The average active sessions section on the Performance page offers a window into the performance of the database by showing, in graphical form, what proportion of time users are waiting and the time they spend actually doing something, such as IO.Monitoring user activity and probing further when there are spikes in CPU usage, for example, helps you identify the causes of poor performance.
ADDM Performance Analysis
On the Database Control Database home page, you can now see an ADDM performance analysis summary table, which provides you a quick overview of current ADDM findings.This is the same table as the one you’d get if you clicked ADDM Findings in the Diagnostic Summary section on the Database home page. Figure shows the ADDM Performance Analysis table.
The ADDM Performance Analysis table
Oracle 11g Related Interview Questions
|Oracle 10g Interview Questions||Oracle 9i Interview Questions|
|Oracle 8i Interview Questions||Informatica Interview Questions|
|PL/SQL Interview Questions||Oracle 11g Interview Questions|
|SQL Interview Questions||Oracle apps Interview Questions|
|Sybase Interview Questions||Oracle Apps ERP Interview Questions|
|Oracle 7.3 Interview Questions||Oracle Access Manager Interview Questions|
|Oracle Application Framework Interview Questions||Oracle Apps DBA Interview Questions|
Oracle 11g Related Practice Tests
|Oracle 10g Practice Tests||Oracle 9i Practice Tests|
|Oracle 8i Practice Tests||Informatica Practice Tests|
|PL/SQL Practice Tests||Oracle 11g Practice Tests|
|SQL Practice Tests||Oracle apps Practice Tests|
|Sybase Practice Tests||Oracle Apps ERP Practice Tests|
|Oracle 7.3 Practice Tests|
Oracle 11g Tutorial
Installing, Upgrading, And Managing Change
Database Diagnosability And Failure Repair
Backup And Recovery
All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd
Wisdomjobs.com is one of the best job search sites in India.