In this lab we will focus on several common performance tuning issues that one might encounter while working with a database. You will need to refer to both your text book and the lecture material for this week for examples and direction to complete this lab.
To record your work for this lab use the LAB2_Report.doc found in Doc Sharing. As in your first lab you will need to copy/paste your SQL statements and results from SQL*Plus into this document. This will be the main document you submit to the Drop Box for Week 2.
L A B S T E P S
STEP 1: Examine Query Optimization using OEM
Oracle Enterprise Manager (OEM) provides a graphical tool for query optimization. The tables that you will be using in this lab are the same ones that were created in the first lab in the DBM449_USER schema.
STEP 2: Examine Query Optimization using SQL*Plus
In this portion of the lab we are going to use SQL*Plus to replicate what we did in Step one using OEM. At the end of this part of the lab you will be asked to compare the results between the processes.
Plan hash value: 1263998123
Id Operation Name Rows Bytes Cost (%CPU) Time
0 SELECT STATEMENT 5 345 3 (0) 00:00:01
1 TABLE ACCESSFULL COURSE 5 345 3 (0) 00:00:01
– dynamic spamling used for this statement
STEP 3: Dealing With Chained Rows
In this portion of the lab we are going to create a new table and then manipulate some data to generate a series of chained rows within the table. After you have generated this problem then we are going to go through the process of correcting the problem and tuning the table so that the chained rows are gone. The process is a little tricky and is going to require you to think through your approach to some of the SQL. Remember that every table has a hidden column named ROWID that is created implicitly by the system when the table is created. This column can be queried just like any other column. You will need this information in step 6 of this part of the lab.
Table name: NEWTAB
Columns: Prod_id NUMBER
Initial and Next extents: 1K
Be sure that you copy/paste all of the above SQL code and returned results sets and messages into the appropriate place in the Lab Report for this week.
What is Due
Submit your completed Lab 2 Report to the Dropbox as stated below. Your report should contain copies of each query and result set outlined in the lab along with the requested explanation of whether or not it satisfied the business requirement outlined for that particular section of the lab.
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.Read more
Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.Read more
Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.Read more
Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.Read more
By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.Read more