|
|
|
#101. 1. Execute DBMS_MONITOR.CLIENT_ID_STAT_ENABLE procedure for the two clients.
2. Execute DBMS_MONITOR.CLIENT_ID_TRACE_ENABLE procedure for the two clients.
3. View the data in the V$CLIENT_STATS view.
4. View the data in the V$SERVICE_STATS view. Sam is a DBA of an OLTP system that has a large number of users. He receives a complaint from two users with client ids Richard and Hardy that the Application response time is poor. To understand the problem faced by Richard and Hardy better, Sam wants to gather the statistics for all active sessions of these clients for a particular instance. Which two of these steps should Sam perform and in which order to view the relevant information?
Показать комментарии к этому вопросу (1)
Добавить комментарии
Ссылка на этот вопрос
|
|
#104. In an online transaction processing (OLTP) environment, you find that the transaction tables get heavily fragmented during the week. You decide to defragment the transaction tables on every Friday at 9:30 p.m. to gain performance. Which two new features of the Oracle 10g database could you use to automate this task? (Choose two)
Показать комментарии к этому вопросу (1)
Добавить комментарии
Ссылка на этот вопрос
|
|
#106. You are working on a database that was created using Oracle Database 10g, the default tablespace type property was not changed. You execute the following statement to create a tablespace, mytbs: CREATE TABLESAPCE mythbs DATAFILE ‘/u1/data/mytbs.dbf’ SIZE 100M;
Which two statements are correct regarding the mytbs tablespace? (Choose two)
Показать комментарии к этому вопросу (1)
Добавить комментарии
Ссылка на этот вопрос
|
|
|
|
 ген. 0.074
|
Дата сервера 12:20 09-01-2009
|
Разработал Zip © 2006
|
|
|
|
|
Форум
Главный бреиндамп