RE: Overhead using a role

From: Larry Hahn <lhahn_60_at_yahoo.com>
Date: Wed, 28 Apr 2004 06:34:05 -0700 (PDT)
Message-ID: <20040428133405.19841.qmail@web42004.mail.yahoo.com>

Dennis,

The second query actually ran longer. Looks like a trace is in order. Thanks for the suggestion.

Larry
--- DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM> wrote:
> Larry
> I doubt that the role makes the difference you are
> seeing. Dumb idea -
> depending on how you ran your test, maybe the first query
> brought the blocks
> into the buffer cache.
> Rule of thumb: When explain plan doesn't answer your
> question, trace the
> execution.
>
> Dennis Williams
> DBA
> Lifetouch, Inc.
> dwilliams_at_lifetouch.com
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Larry
> Hahn
> Sent: Tuesday, April 27, 2004 12:32 PM
> To: Oracle-L_at_freelists.org
> Subject: Overhead using a role
>
>
> Is there much overhead involved in using roles?
>
> I have a query that runs about 4 minutes using the schema
> owner account. The same query runs about 50% longer using
> a
> userid that is attached to a role that has read any table
> rights.
>
> I did an Explain Plan on both, but they are exactly the
> same. We are running under RBO. The database is 8.1.7.3
> running on Sun Solaris.
>
> Thanks for any light anyone can shed on this.
>
> Larry
>
>
>
>
> __________________________________
> Do you Yahoo!?
> Win a $20,000 Career Makeover at Yahoo! HotJobs
> http://hotjobs.sweepstakes.yahoo.com/careermakeover
>

> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com

>

> To unsubscribe send email to:
> oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at
> http://www.freelists.org/archives/oracle-l/
> FAQ is at
> http://www.freelists.org/help/fom-serve/cache/1.html
>

> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com

>

Do you Yahoo!?
Win a $20,000 Career Makeover at Yahoo! HotJobs http://hotjobs.sweepstakes.yahoo.com/careermakeover

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Wed Apr 28 2004 - 08:31:11 CDT