Re: HELP! System crashes

On Fri, 04 Jul 1997 13:46:19 GMT, owrkrj_at_mailhub.sickkids.on.ca (Joost Ouwerkerk) wrote:

>I've been writing and running rather complex queries (through
>SQL*Plus) and my wacky DBA has told me that some of my queries have
>brought down the system -- because they request too much memory,
>rollback segment space, or whatever.
>
>I personally believe that if an SQL query (SELECT statement only) is
>bringing the server down, there is something seriously wrong, --not
>with the query-- but with the system. Can't he just put some resource
>limitations on my userid?
>
>I have now been cut off from using the database (Oracle7.3 on an IBM
>AIX server) -- my userid deactivated. Did I really do something wrong
>or has our DBA lost it? He's told us that nobody can run queries
>during office hours. Some system.
>
>J. Ouwerkerk
>Toronto.
Without attempting to take sides ( I am a DBA (at least that is what my CV says)) some of the issues are :-

Yes resources can be restricted for any user. I personnaly am never very keen on this as a perfectly good long-running job may be aborted because it has hit limit that was set ages ago.

Secondly depending on what purpose the server is in use for (ie an OLTP or high availabillity/quick response application or equal a development server used for testing purposes)

Thirdly - is the sql statement written as well as it should be - do you as a developer expect it to take that much time. Do you commit frequently or wait till the end of the statement.

If I were you I would be inetersted in talking to the sys adm and making sure that the SGA for the d/base is not set too high. A long running bit of code may impact on other things but it should not bring either a system or a datbase down

Hope that is of some help

John Hallas (jhalla_at_premier.co.uk) Received on Sat Jul 05 1997 - 00:00:00 CEST