This preview shows page 1. Sign up to view the full content.
Unformatted text preview: not in the data dictionary.
E: Stored outlines will not become invalid when you analyze the associated objects.
Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 801-804
Chapter 17: Tuning Database Applications
What does this statement do?
SQL>ANALYZE INDEX index_name VALIDITY STRUCTURE;
A. It places information into the INDEX_STATS view and allows for the monitoring of space
used by an index.
B. It provides information in the INDEX_HISTOGRAM view to indicate whether an index is
invalid or valid.
C. It provides information in the DBA_INDEXES view for the COST BASED Optimizer when
choosing an execution plan.
This statement places information into the INDEX_STATS view to allow you to monitor of
space usage by an index.
B: This ANALYZE statement does not provide information in the INDEX_HISTOGRAM view.
C: This ANALYZE statement does not provide information in the DBA_INDEXES view.
Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 917-918
Chapter 20: Tuning Other Areas of the Oracle Database
Which three types of statistics are reported in report.txt after running UTLESTAT SQL?
Actualtests.com - The Power of Knowing 1Z0-024 A. Locking statistics.
B. Memory usage statistics.
C. Explain plan statistics.
D. Library cache statistics.
E. Buffer busy wait statistics.
F. Rollback contention statistics.
Answer: D, E, F
Report.txt file contains library cache, buffer busy waits and rollback contention statistics.
A: This report does not shows locking statistics.
B: It will not provide memory usage statistics.
C: Report.txt file does not contain any information about explain plan statistics.
Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 769-776
Chapter 16: Introducing Database Tuning
What are two main OLTP requirements? (Choose two)
A. Use bind variables rather than literals in your SQL code.
B. Analyze your tables regularly to r...
View Full Document
- Fall '09