1z0-033 Oracle - Braindumps.com.ua: question list for "Oracle9i:Performance Tuning", page: 10

Add to favorites

Profile

Registration

Braindumps

Master braindump list

Forums

Vendor

Linux Prof Institute (LPI) (2)

Lotus (11)

Microsoft (2461)

Network Appliance (2)

Authorization

Login:
Password:
remember me:

Contacts
Certification links
Links

Authorized user can see question and answers.
Please log in or sign up.

Exam question list:
Show all comments

Oracle 1z0-033: Oracle9i:Performance Tuning

#91. In the parameter file, you set the DB_CACHE_ADVICE parameter to READY. What is the effect of the parameter when starting the database instance?

#92. You need to size the KEEP pool. Which calculation would you use to determine the initial size of the KEEP pool?

#93. View the Exhibit and examine the parameters.
Why would the DBA specify different values for the SESSIONS and SHARED_SERVER_SESSIONS parameters?

#94. You decide to create an index-organized table in your database. The table would hold a large number of rows and different departments would work only with the relevant rows in the table concurrently. Which statement regarding the above table can enhance performance?

#95. You are working on the performance tuning of your database. Which two types of performance tuning-related information would an alert log file provide? (Choose two.)

#96. Which three statements are true regarding STATSPACK? (Choose three.)

#97. You increased the value of the OPTIMIZER_MAX_PERMUTATIONS parameter from 4000 to 8000. What would be the impact of this increment on the queries that are being executed? (Choose all that apply.)

#98. You have a trace file with you for analysis. How can you analyze the trace file and get most resource-intensive statements, aggregation of statistics, and inclusion or exclusion details of recursive calls?

#99. View the Exhibit and examine the value set for initialization parameters.

The customer had collected baseline statistics by using statspack six months ago. The current statistics indicate that workarea multipass executions have gone up substantially when compared with baseline statistics. Which recommendation would you make?

#100. You execute the following query to diagnose the performance of the shared servers:

 SQL> SELECT name “NAME”, paddr, requests, 
 (busy / (busy+idle)) * 100 “%TIME BUSY”, status 
 FROM V$SHARED_SERVER;

 NAME      PADDR   REQUESTS   %TIME BUSY    STATUS 
 S000   709E64BC       8077   .018732129    WAIT(ENQ) 
 S001   709E73BC       2953   .009255781    WAIT(COMMON) 
 S002   709E777C       1079   .158928369    WAIT(RECEIVE) 
 S003   709E7B3C       7617   .022872827    WAIT(COMMON)

What can you deduce from this result?

[1] [2] [3] [4] [5] [6] [7] [8] [9] [10] [11] ... [17]

gen. 0.079

Server date 06:18 02-12-2008

Oracle 1z0-033

Forum

Start online exam simulation

Master braindump

User braindumps