|
|
Authorized user can see question and answers.
Please log in or sign up. 
|
#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?
Show comments for this question (1)
Add comments
Link to this question
|
|
#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)
Show comments for this question (1)
Add comments
Link to this question
|
|
#105. You have the following requirements with respect to optimizer statistics: The statistics should be generated automatically during weekdays (Monday to Friday) between 10:00 p.m. and 7:00 a.m. The objects that need updated statistics the most should be processed first. What should you do?
Show comments for this question (0)
Add comments
Link to this question
|
|
#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)
Show comments for this question (1)
Add comments
Link to this question
|
|
#109. You work as a database administrator for Company.com. You have been asked to use a centralized administrative tool to administer your database servers and application servers. In order to achieve the objective, which component would you configure on each database server?
Show comments for this question (0)
Add comments
Link to this question
|
|
|
|
 gen. 0.091
|
Server date 06:38 02-12-2008
|
Developed by Zip © 2006
|
|
|
|
|
Forum
Master braindump