Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: How to keep record of who logged on and who did what on the database

Re: How to keep record of who logged on and who did what on the database

From: Roeland Stouthart <oracle_at_worldonline.nl>
Date: 1997/03/19
Message-ID: <01bc33d4$945960a0$dd141b91@oracle.kpmg.nl>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US