Section 6.5. Exercises

---

6.5 Exercises

1. System administrators and database administrators can argue endlessly about whether the setting of the TIMED_STATISTICS Oracle parameter has a profound effect upon application performance. Research Oracle MetaLink to determine whether there are any bugs that induce an unacceptable penalty upon your implementation. Next, construct an experiment to reveal the response time impact of using a system-wide value of TIMED_STATISTICS=TRUE .

2. A trace file contains elapsed time data about significantly less time than the known duration of the attempted observation interval. Explain the types of data collection error that could have caused this phenomenon to occur.

---

Top