everythingOracle.bizhat.com

 

'Everything you wanted
to know about Oracle'

Training References Syntax Tell A Friend Contact Us

 

 

OEM

01 02 03 04 05 06 07 08 09 10 11 12 13 14 15 16 17
<< Previous

Chapter # 10

Next >>


 

Obtaining a Database Information using OEM

Introduction

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

Covers:

Obtaining the �Disk space used by tables� report

Selecting a target database

Obtaining the �Instance� report

Obtaining �SGA� information

Obtaining the �Security� report

Obtaining user information

Obtaining profile information

Obtaining role information

Obtaining the �Storage� report

Obtaining tablespace information

Obtaining datafile information

Obtaining rollback segment information

Obtaining redo log and archive log information

 

Hands-on
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).

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
 

 

     Reviews and Templates for FrontPage
     

Copyright � everythingOracle.bizhat.com 2006 All Rights Reserved.