Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How to keep record of who logged on and who did what on the database
sccstech <sccstech_at_superlink.net> wrote in article
<5gc2ct$p5g$2_at_earth.superlink.net>...
>
> Recently due to some client application requesting more than 50,000 rows
> the database server crashed because of the virtual memory being run out.
> Now this happened on the Windows NT machine.
>
> What possible ways can be there to avoid such situations where database
> server crashed and there is no information available to track down what
> brought down the server.
>
> Also, how can one limit the response returned by the querries.
Use user profiles to limit the resources a user can consume. It's a reactive limitation, after crossing the line, oracle terminates your transaction.
Roeland Received on Wed Mar 19 1997 - 00:00:00 CST