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

Add to favorites

Profile

Registration

Braindumps

Master braindump list

Forums

Vendor

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

#81. You noticed that the CUSTOMERS table is facing excessive row migration, thereby causing contention for free lists. What would you do to reduce row migration? (Choose all that apply.)

#82. Users complain of slow response time in your online transaction processing (OLTP) system. You compare current statistics with baseline statistics. You notice that in the current statistics library cache, the hit ratio has decreased and there are request misses for shared pool reserved area. Given below are the sizes of shared pool and shared pool reserved area:
SHARED_POOL_SIZE = 500 MB
SHARED_POOL_RESERVED_SIZE = 50 MB
What kind of strategy would you suggest for performance tuning?

#83. Why does performance degrade when many UPDATE, INSERT, or DELETE statements are issued on a table that has an associated Bitmap index?

#84. You executed the following command:

 SQL> SELECT paddr, TYPE, wait, totalq FROM v$queue;

    PADDR             TYPE     WAIT    TOTALQ 
       00           COMMON      852      6819 
 709E687C       DISPATCHER       21      3444 
 709E6FFC       DISPATCHER       12      3381

For the process 00, the wait column shows a significant increase in the value. Identify two possible solutions for this. (Choose two.)

#85. The KEEP pool is full. You issued a query requiring buffers from the KEEP pool. What will happen?

#86. Which three actions on the TEST_TBS tablespace would result in tablespace checkpoint? (Choose three.)

#87. What would you do to reduce fragmentation within extents?

#88. You require that a session should be killed with an out-of-memory failure when the session’s Java state exceeds 2GB. Which parameter would you modify?

#89. View the Exhibit.

In your database, you find that the fy05q1 table in a dictionary managed tablespace has excess space. Further, you find that the table consists of three extents. The size of the first extent is 100KB, the second is 200KB, and the third is 300K. The high water mark is in the middle of the second extent, and there is 400KB of unused space. You want to release the unused space so that it can be used by other segments. You execute the following command to achieve this task:

 SQL> ALTER TABLE fy05q1 DEALLOCATE UNUSED;

What would this command do?

#90. In your test database you have two applications (Application A and Application B) returning the same result set.
• Application A has buffer cache hit ratio of 99%, requires 100,000 logical reads, and 1,000 physical reads
• Application B has buffer cache hit ratio of 60%, requires 1,000 logical reads, and 400 physical reads
Which statement is correct?

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

gen. 0.125

Server date 05:35 02-12-2008

Oracle 1z0-033

Forum

Start online exam simulation

Master braindump

User braindumps