English Русский Contacts Site map Add to favorites
Registration
Login
Master braindump list
New braindumps
Submit a dump
Get latest dump
braindumps.com.ua
flame
3COM (7)
Adobe (1)
BEA (1)
Checkpoint (22)
Cisco (20)
Citrix (17)
CIW (15)
Compaq (0)
CompTIA (51)
CWNA (2)
EMC (2)
Exin (4)
GEJOS (4)
HDI (1)
HP (4)
IBM (13)
Juniper (1)
Linux Prof Institute (LPI) (2)
Lotus (11)
Microsoft (2461)
Network Appliance (2)
Novell (16)
Oracle (411)
PLSQL (1)
PMI (4)
SAS (1)
Sun (87)
Teradata (4)
Login:
Password:
RSS feed

Contacts
Certification links
Links
Authorized users can post comments.
Please log in or sign up.

back to list
Back to main forum
Oracle 7.3 & 8 to Oracle9i DBA OCP Upgrade 

АвторSubject: Q735
written 05 December 2007 23:53   View profile Jonnik  Edit/Delete  Answer  Answer with quotation
Explanation:
The optimizer uses a cost-based approach for all SQL statements in the session regardless of the presence of statistics and optimizes with a goal of best throughput (minimum resource use to complete the entire statement). By setting the OPTIMIZER_MODE into ALL_ROWS you will minimize TOTAL response time. The CBO is a statistics-driven optimizer, and mode ALL_ROWS, FIRST_ROWS, FIRST_ROWS_n, CHOOSE are CBO settings.
Incorrect Answers:
1: The rule-based optimizer mode does not use table or index statistics at all. When RULE is specified, statistics are not used. In this case total response time will not be minimal.
3: By setting the OPTIMIZER_MODE into FIRST_ROWS you will minimize response time for first row.
4: By setting the OPTIMIZER_MODE into FIRST_ROWS_n you will minimize response time for first N rows.
OCP: Oracle 9i Performance Tuning Study Guide, Joseph C. Johnson, p. 99-101
Chapter 3: SQL Application Tuning and Design

Current tread:
back to list

Q735 - Go to question 23:53 05.12.07

back to list
Up ^ gen. 0.072 Server date 16:07 20-11-2008 Developed by Zip © 2006 Up ^
Forum
Start online exam simulation
Master braindump
Main forum
Question comments