Saturday, December 5, 2009

Oracle Enterprise Manager Excercises


As we begin our journey through the world of Oracle and explore the Oracle database architecture and functionality, it might first be helpful to start becoming familiar with one of the Oracle tools that you have not yet had a chance to work with in some of your other database courses.
Oracle Enterprise Manager (OEM) is the Oracle database GUI tool that allows the DBA to do many of the administrative and analytical functions in the database without having to write code.  Although we will do much of our work in SQL*Plus for this course, it is always helpful to at least look at those other tools that are part of the Oracle architecture. 

I N D I V I D U A L     E X E R C I S E S

HANDS-ON #1: Using Schema Manager 
Using the Schema Manager, find the AQ$_QUEUES table in the SYSTEM schema.  These tables are part of the Oracle Data Dictionary.   Answer the following questions based on what you can find using the tabs on the right-hand side of the OEM screen.
  1. Who owns this table?
  2. What tablespace is it located in?
  3. How many columns does the table have?
  4. Which column is the Primary Key column?
  5. Are there any other constraints associated with this table?  If yes, what is the name of the constraint.
Place and save your answers in a Word document named week1_exercise.doc.
HANDS-ON #2: The Analyze Wizard tool
Run the Analyze Wizard on the AQ$_QUEUES table in the SYSTEM schema (while the table is highlighted, select Objects => Analyze from the top menu then follow the prompts).  Now, view the results under the Statistics tab and answer these questions:
  1. How many rows are in the table?
  2. What is the average length of a row?
  3. How many empty blocks are there for the table?
Place and save your answers in the Word document named week1_exercise.doc that you have started for this week’s exercises.
HANDS-ON #3: Finding Specific Objects
For the third part of the exercise you will look at some of the database files and settings in your database instance.  First you will look at the SYSTEM datafile.  Navigate to Storage =>Tablespaces => SYSTEM => Datafiles and highlight the datafile you find there.  Then, answer the following questions:
  • How large is the file?
  • What are the storage parameter settings for the file?
  • What is the full path to the file?
Now take a look at the file associated with the Redo Logs and answer the following questions:
  • How many log files do you currently have?
  • What is the full path to each?
  • What is storage unit for these files?
  • How large is each file?
Posted by at
Labels: ,

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)