Hands-On 10 (Obtaining a Database Information using OEM)

As a DBA, you are responsible for obtaining database information. The following is a summary of your task:

1. Obtaining the “Disk space used by tables” report

2. Selecting a target database

3. Obtaining the “Instance” report

4. Obtaining “SGA” information

5. Obtaining the “Security” report

6. Obtaining user information

7. Obtaining profile information

8. Obtaining role information

9. Obtaining the “Storage” report

10. Obtaining tablespace information

11. Obtaining datafile information

12. Obtaining rollback segment information

13. Obtaining redo log and archive log information

Hands-On 10 (Obtaining a Database Information using OEM )

Description:

In this exercise you will learn how to get more database information
such as the "Disk space used by tables" report, the "Instance" report,
the "Security" report, and the "Storage" report from using the Report
Definitions utility using the Oracle Enterprise Management tool (OEM).


==Start.
Click on the "Report Definitions" icon.

==
Let's get some information about "Disk space Used by tables."

==
Double click on it, and select the database that you want to run the 
report against.

==
Then, click on the "View Report" button.

==
Notice that the report will be generated in the HTML format.
Browse through the report.

==
Here, you can check all of the table space with their total space used
and number extents. Also, you can check who owns them and what
tablespace they are using.

==
Close the windows. Go back to the Report Definitions Window and 
run the "Instance" report by double clicking on it.

==
Select the database that you want to run the report against.

==
Then, click on the "View Report" button.

==
Notice that an HTML file was created.
Click on the Database and Instance link.

==
Here, you have information about the database, such as the database
name, version, host name, and whether or not it is in the archivelog
mode.

== 
You can also check the Option of installation,

==
The SGA information and Initialization parameter information.

==
The SGA information such as the Buffer Cache, Redo Buffer, 
And Shared Pool. Then close the windows and select the new report.

==
Let's select the Security report.

==
Select the target database and click on the View Report button.

==
Click on the General User Account Information link. Here we can
see all of the users, their profiles, temporary tablespace, 
and default tablespace.

==
In the user’s roles, we will find all of the roles with their
associated roles.

==
On the Tablespace Quota, we will find all of the quotas assigned to
a user. Now, close the windows and open another report.

==
Let's select the Storage Report.

==
Select the target database and click on the View Report button.

==
In the Storage report, we will find information about: Controlfiles,
Tablespaces, Datafiles, Rollback Segments, Redo log, and Archive logs.

==
Close the windows


For more information about the subject, you are encouraged
to read from a wide selection of available books.

Good Luck!