Dick,
Which version of Oracle ?
Was your test with 2 different user ID's ?
Our problem is that all users log on
with the same user id, which seems
to diminish the product's effectiveness.
thanks.
ed
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, October 18, 2002 12:54 PM
> Kirti,
>
> I've toyed with the product due to a perceived need here. The
experiment
> was to have two users loggin to the database both running very nasty
queries (we
> have the GOD of obfuscated SQL here). On the first pass, with no resource
> management in place both queries ran successfully in 30 minutes but boy
did the
> server take a hit (4 processors with < 10% idle across them). On the
second
> pass we put resource management in place for one user really clamping down
on
> it. The first user's query completed in 10 minutes where as the second
user
> took 45 minutes to complete and the server didn't even break a sweat (one
> processor was 100% idle throughout). I'd like to do more with it, but
> PeopleSoft does things in a way the precludes resource manager from being
> effective.
>
> Dick Goulet
>
> ____________________Reply Separator____________________
> Author: "Deshpande; Kirti" <[EMAIL PROTECTED]>
> Date: 10/18/2002 8:00 AM
>
> Hello Listers,
>
> Anyone using Oracle's Database Resource Manager?
> Does it really work as outlined in the Docs?
> Care to share your experience?
>
> Thanks,
>
> - Kirti
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Deshpande, Kirti
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ed Lewis
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
