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

Add to favorites

Profile

Registration

Braindumps

Master braindump list

Forums

Vendor

car insurance quotes (1)

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

#1. Which statements are true regarding configuring multiple buffer pools in the Database Buffer Cache that is using only the standard block size? (Choose all that apply.)

#2. Smith is a DBA with ABC Corp. He is in the process of tuning the database. He has received various problem statements from the customers. Identify three appropriately defined problem statements that Smith can use to tune the database correctly. (Choose three.)

#3. You execute the following query to check resource consumption in the current plan used by the database:

 SQL> SELECT name, active_sessions, requests, queue_Iength, current_undo_consumption 
“UNDO CONSUMPTION” FROM V$rsrc_consumer_group;

 NAME          ACTIVE_SESSIONS      REQUESTS      QUEUE_LENGTH     UNDO CONSUMPTION 
 OTHER_GROUPS                1             1                 0                    0 
 GROUP1                      2             4                 2                    0

Which statement is correct when a user belonging to GROUP1 tries to start a session?

#4. You require that a warning is written to a trace file without impacting the application when the session’s Java state exceeds 2GB. Which parameter would you modify?

#5. You use the following query to monitor the Shared Servers:

 SQL>SELECT maximum_connections “MAX CONN”, servers_started “STARTED”, servers_terminated 
“TERMINATED”, servers_highwater “HIGHWATER” FROM v$shared_server_monitor;

 MAX CONN    STARTED    TERMINATED     HIGHWATER 
        3          6             6             3

With every execution, you observe that the values of the STARTED and TERMINATED columns are growing quickly. What action would you take?

#6. As part of the performance-tuning activity, you executed the utllockt.sql script. What does this script do? (Choose all that apply.)

#7. Which two statements are valid regarding row migration? (Choose two.)

#8. While tuning the shared server in your database, you executed the following command:

 SQL> ALTER SYSTEM SET DISPATCHERS = ‘(PROTOCOL=TCP)(DISPATCHERS=5)’;

How does this statement affect the shared server configuration? (Choose two.)

#9. Which two actions could you perform to reduce busy buffer waits caused on segment header blocks? (Choose two.)

#10. In an online transaction processing (OLTP) system, which is configured in shared server mode, you execute the following query to examine the sort performance:

 SQL> SELECT d.VALUE “Disk”, m.VALUE “Mem”, (d.VALUE/m.VALUE)*100 “Ratio” 
FROM v$sysstat m, v$sysstat d WHERE m.name=’sorts (memory)’ AND d.name=’sorts (disk)’;

 Disk      Mem      Ratio 
   23      206      11.165049

What action would you take after observing the output?

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

gen. 0.162

Server date 06:15 22-08-2008

Oracle 1z0-033

Forum

Start online exam simulation

Master braindump

User braindumps