Oracle-L: RE: Re[2]: Re:Resource Management

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Fri, 18 Oct 2002 11:23:32 -0800
Message-ID: <F001.004EDB66.20021018112332@fatcity.com>

Dick - Thanks for posting your results. We have a different ERP (Lawson), and we have been considering whether Resource Management is worth the effort. Currently all users access Oracle through a single userid, but there is an option for each user to have a separate login. The price is that you then have to create and maintain many userids.

Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Friday, October 18, 2002 1:32 PM
To: Multiple recipients of list ORACLE-L

Ed,

The version is 8.1.6 and yes it was with two different usernames. In the
end since we wanted to apply this to PeopleSoft where everyone is the same userid it was impossible too. Still looking for another solution.

Dick Goulet

____________________Reply Separator____________________
Author: "Ed Lewis" <eglewis_at_hotmail.com>
Date:       10/18/2002 10:12 AM

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" <ORACLE-L_at_fatcity.com> 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" <kirti.deshpande_at_verizon.com>
> 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: kirti.deshpande_at_verizon.com
>
> 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: ListGuru_at_fatcity.com (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: dgoulet_at_vicr.com
>
> 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: ListGuru_at_fatcity.com (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: eglewis_at_hotmail.com

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: ListGuru_at_fatcity.com (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: dgoulet_at_vicr.com

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: ListGuru_at_fatcity.com (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: DENNIS WILLIAMS
  INET: DWILLIAMS_at_LIFETOUCH.COM

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: ListGuru_at_fatcity.com (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).

Received on Fri Oct 18 2002 - 14:23:32 CDT