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

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 - 00:03:01 CST