v$active_session_history. as perscribed by others here on the list, set statistics_level='BASIC' and these will go away. (thanks, Niall).
this was for 10.1.0.3 on win32 - but since you did not include the database version and OS ... I'm just guessing. (hint)
Paul
On Thu, 24 Feb 2005 14:30:18 +0100, Tony.Adolph@(protected) <Tony.Adolph@(protected)> wrote: > Hi all, > A developer here is trying to find the source of the error "ORA-01401 (See ORA-01401.ora-code.com): > inserted value too large for column". He want to know which table / > column(s) are causing the problem. > > The error is not logged in the alert log. > > I set sql_trace = true and had him repeate his tests. Although we got > bucket loads of trace files in both user_dump_dest and > backfround_dump_dest we did not get any trace files or errors relating to > ORA-01401 (See ORA-01401.ora-code.com). I tried to grep for just the 1401 string, still nothing. > > How can find the culprit here folks? > > Cheers > Tony > > -- > http://www.freelists.org/webpage/oracle-l >
-- #/etc/init.d/init.cssd stop # f=ma, divide by 1, convert to moles. -- http://www.freelists.org/webpage/oracle-l