Re: How to identify whether or not client session get ORA-1652 of TEMP in RAC.

Can you elaborate on reassignment in RAC causing ORA-1652 (unable to extend temp segment by string in tablespace ...)? Once we know the difference between that and the ORA-1652 experienced by the users, we can help you.

Yong Huang

wangbin_at_start.com.au (wangbin) wrote in message news:<2d15bd69.0311062203.6ee7520e_at_posting.google.com>...
> Thanks Sybrand.
>
> We use a third part application, so we cannot modify the code to add
> the exception handler. I know how to get ORA-1652 from alert.log. But
> most of those are caused by re-assignment in RAC, which I don't care.
> Is there a way to find out how often the clients get it without
> changing the apps?
>
> Kind Regards,
> Bin
>
> > > Is it possible to monitor how often the client sessions get the error?
> > > The system is on Internet. I have received complain from our customer
> > > once. I don't want to receive too much complain from our customers
> > > before I take an action.
> > >
> > > Thanks,
> > > Bin
> >
> > With appropiate exception handlers in the application it is possible
> > to log the occurence of 1652 in a table. Other than that as this 1652
> > isn't surpressed from the alert, you could just grep the alert and
> > pipe it to wc -l.
> > If you are running on NT, you could install Cygwin to obtain grep.
> >
> > Sybrand Bakker
> > Senior Oracle DBA
Received on Fri Nov 07 2003 - 08:59:42 CST