1z0-033 Oracle - Braindumps.com.ua: список вопросов для "Oracle9i:Performance Tuning", страница: 10

Профиль

Бреиндампы

Получить последний дамп

Форумы

Продавец

Linux Prof Institute (LPI) (2)

Lotus (11)

Microsoft (2462)

Network Appliance (2)

Авторизация

Логин:
Пароль:
запомнить меня:

Контакты
Сайты по тематике
Cсылки

Авторизированые пользователи могут видеть ответы к вопросам.
Пожалуйста, авторизируйтесь или зарегистрируйтесь.

Список вопросов к экзамену:
Показать все комментарии

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]

ген. 0.066

Дата сервера 12:02 09-01-2009

Oracle 1z0-033