How do set event to get more details through trace generated by ORA-00272.
event="00272 trace name errorstack level 10"
is this set at the sqlplus or c:\ prompt?
Do you only set event through trace generated .trc or ORA- message as well?
Based on the above ora-00272 Can some one show me an example please?
yo do that when support tells you, even you do it what are you going to do with the trace file, even support needs a documentation to decode the trace file when they are reading it....
You can do that two ways:
1. In your init.ora file:
event="00272 trace name errorstack level 10'
reboot Oracle db after that.
2. From svrmgrl as user internal or sqlplus - sysdba (9i):
ALTER SYSTEM SET EVENT '00272 trace name errorstack level 10';
Setting the event will dump the memory heap, which Oracle Support will use to find the cause of the ORA-00272 error. Also could dump the SQL statement causing the error. The pattern is:
00272 - ORA-00272
trace name - trace file in udump
level 10 - how much information to be dumped.
It is good idea to do that with Oracle Support guidance, since anyway they have to figure it our what is the reason.
Hope that helps,
Senior Oracle DBA
visit our web site !!