Re: Tunning & DBA SQLs

Klaus Schnurr <kschnurr_at_primenet.com> wrote:

>We are using Oracle Server 7.1 (running under Solaris 2.4) in a
>semiconductor manufacturing environment. Users are mainly using the
>database for data analysis purposes which requires intensive data
>queries. However, deploying the database and the front-end tools within
>a client-server environment revealed very soon the limitations of the
>systems. One user can bring system down to its knees by running an
>extremely complex query which consumes all the system resources. The
>users are connecting via the Sequelink middleware product from Intersolv
>to the database. Now, I have the following questions:
 

>1. Is there any way, within Oracle or UNIX, to restrict the available
>system and oracle resources which are available for a requested
>instance?
 

>2. Can Oracle restrict the number of rows a query can return to the user
>(i.e. trapping "run-away" queries)
 

>3. Does anybody know of Oracle SQL statements which would allow to
>monitor the database performance?
 

>Thanks a lot for your support and help!
 

>Klaus

I can give you some help with item 3. The web site below has over 20 queries you can use to monitor Oracle

[warning: self promotion on]

Check out: http://www.menlosoftware.com/

[self promotion off]

Regards,
Paul Received on Thu Apr 11 1996 - 00:00:00 CEST