Q
Problem solve Get help with specific problems with your technologies, process and projects.

Setting events to avoid "snapshot too old" errors

In order to identify offending statements in "ORA-1555: snapshot too old" errors, can you please let me know how to set events? I have seen in Oracle forums to set "alter session set events = '1555 trace name errorstack level 1'." But this was for Oracle 8.1.7. Our database is version 9.2.0.6.0. Is this event valid for version 9.2.0.6.0. as well?

In order to identify offending statements in "ORA-1555: snapshot too old" errors, can you please let me know how to set events? I have seen in Oracle forums to set "alter session set events = '1555 trace name errorstack level 1'." But this was for Oracle 8.1.7. Our database is version 9.2.0.6.0. Is this event valid for version 9.2.0.6.0. as well?

Also, can you tell me some good documents for more details on valid events for each release and the trace levels? Thank you in advance.

The event will still work in versions higher than Oracle 8.1.7. The event number matches the ORA- error number, which causes Oracle to capture a trace whenever that error is raised.

There is very little documentation on events for each release as they should only be set under the guidance of Oracle Support. I have yet to see a document that lists a table of events and what they are used for. Most people learn of events from Metalink or on the Internet.

Dig Deeper on Oracle database design and architecture

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close