Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Overhead using a role

Overhead using a role

From: Larry Hahn <lhahn_60_at_yahoo.com>
Date: Tue, 27 Apr 2004 10:31:36 -0700 (PDT)
Message-ID: <20040427173136.41123.qmail@web42007.mail.yahoo.com>


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
Received on Tue Apr 27 2004 - 12:44:33 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US