‘Always aim at
complete harmony of thought and word and deed. Always aim at
purifying your thoughts and everything will be well.’ Gandhi |
Navigate the Oracle
Enterprise Manager Grid Control in the Oracle 10g database
Creating an Oracle user
How to create an Oracle
user by using the EM Database Control
Go to the EM Database
Control home page as sysdba and
click on Administration > Users. On the Users page click on the
Create button. You should specify the Name, Enter Password, Confirm
Password, Default Tablespace, and Temporary Tablespace fields. Then
click on the Roles tab and click on the Modify button; select Resource
and DBA from the Available Roles list. Once done, click the Move link
and click the OK button. When you are returned to the Create User
page, click the OK button.
Using of the EXPORT utility
How to export tables from a
schema by using the EM Database Control
Go to the EM Database
Control home page as sysdba. Click on the Administration tab; click on
the Tables link in the Schema region; select your schema in the Schema
field in the Search region; and click the Go button. Select your
exported tables from the Results region; Select Show Dependencies from
the Actions drop-down list; and then click on the Go button in the
Results region. On the Export:Review page, click on the Submit Job
button.
Using of the IMPORT utility
How to import tables from a
schema by using the EM Database Control
Go to the EM Database
Control home page as sysdba. Click on the Maintenance link; click on
the Import from Files link; make sure that the Database Version of
Files to Import field is set to 10g or later; and click the Go button.
In the Files region, select your directory from where the Data Pump
Import job can retrieve your exported Dump File Set; in the Import
Type region, select the Tables option button and make sure the host
credentials are correct; then click on the Continue button. Click on
the Add button and in the Import:Add Tables page, enter your schema in
the Schema field in the Search region; then click on the Go button.
Select your tables; click on the Select button and On the Import:Re-Mapping
page, click the Add Another Row button in the Re-Map Schema region.
Then click the Next button. On the Import:Review page, click on the
Submit Job button; on the Status page, click the View Job button;
refresh your browser page until the Status field reads Succeeded; and
then click the Import link to look at the log file.
Determining the latest ADDM
How to retrieve the latest
ADDM and determine the cause of the problem by using the EM Database
Control
Go to the EM Database
Control home page as sysdba and click on the Advisor Central link on
the Related Links section; select ADDM in the Advisory Type drop-down
list; select Last 24 Hours in the Advisor Runs drop-down list; and
when it is done, click on the Go button. Then select the latest ADDM
task completed by the ADDM user; click the View Result button; it
brings you to the ADDM page and you can see the results for the
Performance Analysis; To investigate further, click on the SQL
Statements Consuming Significant Database Time Were Found link; it
will brings you to the Performance Finding Details page. To tune the
statement, click on the Run Advisor Now button; when the analysis
finished, you will be directed to the Recommendations for SQL ID: …
page.
Startup and Shutdown the
database
How to shutdown and startup
your databases using an initialization parameter file by using the EM
Database Control
Go to the EM Database
Control home page as sysdba; click the Shutdown button; you should
specify host and target database credential; save them and click on
the OK button. On the Startup/Shutdown: Confirmation page click the
Yes button; on your database page, click the Startup button. Click on
the Advanced Options button; make sure that you select your
initialization parameter file with its location and then click the OK
button.
Resizing the various SGA
Buffers
How to check or resize the
size of the various SGA buffers using the EM Database Control and how
to enable the Automatic Shared Memory Management by using the EM
Database Control
Go to the EM Database
Control home page as sysdba; click on the Administration tab; click on
the Memory Parameters link in the Instance region; and now you should
see the status Automatic Shared Memory Management (disable or enable),
Shared Pool size, Buffer Cache, Large Pool, Java Pool, Total SGA,
Maximum SGA size, etc. If the Automatic Shared Memory Management was
disabled on the Memory Parameters page, click on the Enable button to
enable it.
Checking the Metrics
Graphic
How to look at the
corresponding metrics graphic rate by using the EM Database Control
Go to the EM Database
Control home page as sysdba; click on the All Metrics link; expand the
Throughput link; under this link, click on the User Commits (per
second) link; make sure that the View Data field is set to very short
period of time (ex: Real Time: 10 Seconds Refresh). Now here,
depending on your workload, you should be able to see your graph.
Reading an ADDM report
How to find a high load SQL
statement and fix it by looking at an ADDM report analysis during the
problem by using the EM Database Control
Go to the EM Database
Control home page as sysdba.
If the time corresponding
to the problem corresponds with the latest ADDM, then you should find
the link corresponding to the correct performance analysis directly in
the Diagnostic Summary region of the EM Database Control home page. If
not, then go to the Advisor Central page and search for the correct
ADDM task. To fix your problem, click the finding with the highest
impact on the database time on the corresponding ADDM page. It should
correspond to a SQL Tuning recommendation. On the Performance Finding
Details page, you see the high-load SQL statement; click on the Run
Advisor Now button for the highest high-load SQL statement detected.
Once was done, you get the details of the corresponding
recommendations. You can also click on the Original Explain Plan
button to see the original plan. If you have a proposed SQL command,
click on the Implement button after selecting the appropriate SQL
command from the Recommendations table.
Checking the wait category
How to determine the most
important wait category from the Sessions: Waiting and Working graph
by using the EM Database Control
Go to the EM Database
Control home page as sysdba; click on the Performance tab; if the
period for which you want to observe your database is on the Sessions:
Waiting and Working graph use the current graph. If the period is no
there, select the Historical value from the View Data drop-down list.
On the Performance page click on the User I/O category in the graph’s
legend. Select the top SQL statement and you should see the SQL
Details page. Click on the Execution History tab to see what is going
on to the statement. Shorten the Seconds Per Execution option button
to get a better understanding of the graph.
Using the SQL Access
Advisor
How to use the SQL Access
Advisor to generate recommendations for a SQL tuning set by using the
EM Database Control
Go to the Database Control
home page as sysdba; click on the Advisor Central link; click on the
SQL Access Advisor link; then select the Import Workload from SQL
Repository option button; set the SQL Tuning Set field to your SQL
tuning set; and click the Next button. On this page, click on the Both
Indexes and Materialized Views and Comprehensive Mode buttons; click
on the Show Advanced Options link and make sure your options are set
and then click the Next button. On the SQL Access Advisor: Schedule
page, select Standard in the Schedule Type file; on the Review page,
click the Submit button. Refresh the page until you get the COMPLETED
status. Now, select your SQL Access Advisor task and click the View
Result button.
Creating a job and schedule
How to create a job and
schedule it to run by using the EM Database Control
Go to the Database Control
home page as sysdba; click on the Administration tab; in the Scheduler
section, click on the Jobs link; on this page, click on the Create
button; on the page, enter a job name the Name field; make sure the
set the Logging Level (RUNS), Job Class (DEFAULT_JOB_CLASS), Auto Drop
(FALSE), and the Restartable (FALSE). In the Command section, click
the Change Command Type button; on the Select Command Option, select
the In-line Program: Executable radio button; and the click the OK
button. On the Create Job page, enter your shell executable job in the
Executable Name field and click the Schedule tab. On this page, select
your schedule option and click OK.
Verifying a Schedule
How to verify that your
schedule was created by using the EM Database Control
Go to the Database Control
home page as sysdba; click on the Administration tab; click the
Schedules link on the Scheduler region.
Changing the space usage
threshold
How to change the
Tablespace Space Usage thresholds of a tablespace by using the EM
Database Control
Go to the Database Control
home page as sysdba; click on the Administration tab; click on the
Tablespaces link; select your tablespace; select Edit > Thresholds;
select Specify Thresholds, by percent used; now specify the Warning(%)
and Critical (%) fields; and then click the Apply button.
Running the Segment Advisor
How to run the Segment
Advisor for a tablespace by using the EM Database Control
Go to the Database Control
home page as sysdba; click on the Administration tab; click on the
Tablespace link; select your tablespace; select Run Segment Advisor
from the Action field; click the Go button; check that the
Comprehensive mode is selected; click the Continue button; check all
the options on the Segment Advisor: Schedule, and Options pages. On
the Review page, click the Submit button and click refresh until you
see COMPLETED. Select your task and click the View Result button to go
to the Segment Advisor Recommendations page. Accept all recommendation
and then click the Schedule Implementation button.
Using the UNDO Advisor
How to use the Undo Advisor
to get recommendations to size your UNDO tablespace by using the EM
Database Control
Go to the Database Control
home page as sysdba; click on the Administration tab; click on the
UNDO Management link; on this page change the Analysis Time Period
field to Last One Hour and click the Update Analysis button; on the
UNDO Management page, you should see Oracle 10g recommendation; click
the UNDO Advisor button to get more info. You can look at the Required
Tablespace Size by Undo Retention Length graph. If you change the New
Undo Retention field for example you will see the impact on your undo
tablespace size. On the UNDO Management page, click the Edit Undo
Tablespace button. Change the size or add datafile and click the
Continue button. After you are back to the Edit Tablespace page click
the Apply button.
Changing the Flash Recovery
size
How to change the size of
flash recovery area by using the EM Database Control
Go to the Database Control
home page as sysdba; click on the Maintenance tab; click on the
Configure Recovery Settings link; in the Flash Recovery Area Size
field, you can enter a value that you want to change and then click on
the Apply button.
Backing the whole database
How to backup your whole
database to tape by using the EM Database Control
Go to the Database Control
home page as sysdba; click on the Maintenance tab; click on the
Schedule backup link; select Customized from the Backup Strategy
drop-down list; select Whole Database; make sure that you enter your
host credentials and click the Next button; on the Options page, click
NEXT; on the Setting page, select Tape, then NEXT; on the Schedule
page, click NEXT; on the Review page, click Submit Job. Now you should
be able to view your job by clicking on the View Job button. Once the
job is done, click the Backup link on the Execution page. You see what
you want to see.
Using the Flashback to
recover
How to use the flashback
feature to recover a dropped table by using the EM Database Control
Let assume that still your
table is in the Recycle Bin area. Go to the Recycle Bin page; select
your object; and click the Flashback Drop button. You will be prompted
to the Perform Recovery: Rename page to change the original name if
you wish. Leave the original name, and click NEXT. On the Review page,
click the Submit button and click OK on the Confirmation page. Now you
should see the Recycle Bin page and your object should have been
disappeared.
Using the Sizing Advice
How to determine the Redo
Log File size using the Sizing Advice by using the EM Database Control
Go to the Database Control
home page as sysdba; click on the Administration tab; click on the
Redo Log Groups link; on this page you can see the redo log group
size; select Sizing Advice in the Actions drop-down list and click the
Go button. Now, you should see the recommended optimal redo log file
size in the Update Message region of the Redo Log Groups page.
“...And I've looked
over, and I've seen the promised land. I may not get there with
you, but I want you to know tonight that we as a people will get
to the promised land. So I'm happy tonight. I'm not worried
about anything. I'm not fearing any man.” Martin Luther King
Jr., Speech in Memphis, April 3, 1968, the day before King was
assassinated |
Questions:
Questions on
Navigate the
Oracle EM Grid Control in the Oracle 10g database
Q: How do you create an
Oracle user by using the EM Database Control?
Q: How do you export tables
from a schema by using the EM Database Control?
Q: How do you import tables
from a schema by using the EM Database Control?
Q: How do you retrieve the
latest ADDM and determine the cause of the problem by using the EM
Database Control?
Q: How do you shutdown and
startup your databases using an initialization parameter file by using
the EM Database Control?
Q: How do you check or
resize the size of the various SGA buffers using the EM Database
Control and how to enable the Automatic Shared Memory Management by
using the EM Database Control?
Q: How do you look at the
corresponding metrics graphic rate by using the EM Database Control?
Q: How do you find a high
load SQL statement and fix it by looking at an ADDM report analysis
during the problem by using the EM Database Control?
Q: How do you determine the
most important wait category from the Sessions: Waiting and Working
graph by using the EM Database Control?
Q: How do you use the SQL
Access Advisor to generate recommendations for a SQL tuning set by
using the EM Database Control?
Q: How do you create a job
and schedule it to run by using the EM Database Control?
Q: How do you verify that
your schedule was created by using the EM Database Control?
Q: How do you change the
Tablespace Space Usage thresholds of a tablespace by using the EM
Database Control?
Q: How do you run the
Segment Advisor for a tablespace by using the EM Database Control?
Q: How do you use the Undo
Advisor to get recommendations to size your UNDO tablespace by using
the EM Database Control?
Q: How do you change the
size of flash recovery area by using the EM Database Control?
Q: How do you backup your
whole database to tape by using the EM Database Control?
Q: How do you use the
flashback feature to recover a dropped table by using the EM Database
Control?
|