Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Setting event 1555

Setting event 1555

From: Nahata, Naveen (US - Hyderabad) <nnahata_at_deloitte.com>
Date: Wed, 10 Nov 2004 05:36:40 -0600
Message-Id: <35A6B4FC173FE3449C7ABB1AD17187AD092B80@uscnt0418.us.deloitte.com>


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
Received on Wed Nov 10 2004 - 05:32:06 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US