Setting event 1555

Hi All,

I see a few ORA-01555: Snapshot too old errors in the alert log daily. The trace file doesn't give much clue about the application/SQL that is causing the error.

I'm planning to set event 1555 at the system level to get to the bottom of the problem.

1. What are the performance implications of setting this event? Is the impact high or low?
2. Should I use systemstate or errorstack in the event specification? What are the performance implications of both?

Since I have no experience of setting this event in the past, please provide any useful information which I have not sought for in my above questions.

Regards
Naveen

This message (including any attachments) contains confidential = information intended for a specific individual and purpose, and is = protected by law. If you are not the intended recipient, you should = delete this message. Any disclosure, copying, or distribution of this = message, or the taking of any action based on it, is strictly = prohibited.

--
http://www.freelists.org/webpage/oracle-l