|
|
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?
|
|
|
|
 gen. 0.113
|
Server date 03:20 15-03-2010
|
Developed by Zip © 2006
|
|
|
|
|
1z0-033 certification
1z0-033 master dump