| Oracle parameter [message #51160] |
Sat, 04 May 2002 05:10  |
nadella srikanth
Messages: 6
Registered: March 2002
|
Junior Member |
|
|
Hi All,
Can somebody please let me know what the parameter
'Event="10231 trace name context forever, level 10" ' is, and what it does? This is in the init<sid>.ora parameter file.
Thanks in advance.
|
|
|
|
| Re: Oracle parameter [message #51175 is a reply to message #51160] |
Mon, 06 May 2002 06:11  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
|
Event 10231 causes full table scans to skip corrupt blocks, rather than fail with an ORA-1578 error. Event 10232 causes the corrupt blocks to be dumped to the process trace file. If you have found these events set in your parameter file, they are probably left over from a time when somebody suspected a data block corruption and set these events prior to doing a full table scan to check it out. If you are thinking of setting them yourself to investigate something, then setting them at the session level should be adequate
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
