Setting event 1555
- From: "Nahata, Naveen (US - Hyderabad)" <nnahata@xxxxxxxxxxxx>
- To: "Oracle Mailing List" <ORACLE-L@xxxxxxxxxxxxx>
- Date: Wed, 10 Nov 2004 05:36:40 -0600
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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
