Important Guideline for Setting of Oracle Event Tracing

ALLEN, Texas - Nov. 5, 2014 - PRLog -- Sometimes, you need to set some event for obtaining results to send to Oracle support or you need to analysis those result. After setting those events, it might be possible that you would forget to disable or remove those events. It is very important to stop those events because sometimes it may impact database performance.

Do not set any particular events within the database by the EVENTS initialization parameter, except Oracle support clearly demands for it. Also, make sure that formerly set events are disabled at the next accessible chance or during the subsequently scheduled bounce of database. Once the difficulty for which the event was deployed is resolved. Sometimes, the events persist to linger enabled long after the specific problems are resolved. It is acceptable if the event doesn’t impact performance. If database performance is not optimal, however, these unneeded events require to be disabled, especially expensive events such as data block or index block corruption. It’s best not to wait until performance becomes intolerable but to proactively disable them at the next achievable downtime.

Once performance becomes terrible, these events may necessitate to be disabled straight away, thus causing database downtime because database bounce is required to disable those. Once more thing to keep in mind is that many of these events can be set at the session/system level using command “alter session” or “alter system” without requiring a database bounce. So even if Oracle Support requests an event to be set, inquire whether the same event can be set at the session/system level, rather than at the instance level using the EVENTS initialization parameter. Also, application code can often be changed without too many hassles to include an alter session command prior to a specific operation. That is suspected to cause the problem. Though this will require multiple changes to be made to an application, it will avoid a database downtime.

You can find real time scenario based Oracle DBA Interview Questions and Answers from Gitesh Trivedi's book named Oracle DBA Interview Questions & Answers - 5th Edition including Oracle 12c database. It is very useful guide to crack Oracle DBA Interviews and useful for your routine day by day Oracle DBA activities. Book is available at http://www.kendba.com/books/interview-questions-books/ or you can find out from http://www.amazon.in/dp/0615947840 for India buyers.

For more detail you can check from http://www.kendba.com