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

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

#61. View the Exhibit and examine the alert log file.

The Service Level Agreement for the production database includes that the database down-time should not be more than 10 minutes. What performance-related issue could you identify by examining the alert log file?

#62. Examine the following query:

 SQL> SELECT num_rows, blocks, empty_blocks AS empty, avg_space 
 2 FROM dba_tables 
 3 WHERE owner=’HR’ 
 4 AND table_name=’DEPARTMENTS’;

 NUM_ROWS     BLOCKS    EMPTY    AVG_SPACE 
    12145        175       13         1250

What does the number 13 displayed in the EMPTY column indicate?

#63. ABC Corp. plans to build an online transaction processing (OLTP) system. The company plans to tune all the components during the development life cycle.
From the list given below, identify the order in which the components should be tuned.
1. logical and physical model
2. cursor sharing
3. Oracle instance memory structures
4. operating system
5. data file I/O

#64. Consider the following scenario:
• You are working on a production database; you cannot shut down and restart the instance frequently.
• During daytime, you need to maintain a higher cache hit ratio.
• During nighttime, there are no online transactions and memory requirements are mainly for Oracle backup and restore operations.
Which strategy would you recommend to optimally use the memory?

#65. In your test database, you want to automatically collect database statistics at regular intervals. You execute the spauto.sql script to automate this task. What must you ensure before executing this script?

#66. The database performance is degrading. You need to isolate the SQL statements that are contributing to the disk I/O load. Which diagnostic step would you recommend in the given scenario?

#67. Because of fragmentation, a frequently required large PL/SQL package is being flushed out of the library cache. Which strategy would you recommend to ensure the availability of the package in the library cache?

#68. How would you identify the buffer cache blocks being used by an object?

#69. You noticed that the LGWR process is slow in freeing the redo log buffers. On querying the V$SYSTEM_EVENT view, you find that some time is spent on waiting for the log file switch (archiving needed) event. The archiving directories are not full. What should you do to minimize the waits? (Choose all that apply.)

#70. While doing a routine performance check of your test database, you find that a large number of statements are getting invalidated in the library cache, thereby causing the statements to be reparsed. What could be the reason for the invalidations?

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

gen. 0.084

Server date 06:29 02-12-2008

Oracle 1z0-033

Forum

Start online exam simulation

Master braindump

User braindumps