Overhead using a role
- From: Larry Hahn <lhahn_60@xxxxxxxxx>
- To: Oracle-L@xxxxxxxxxxxxx
- Date: Tue, 27 Apr 2004 10:31:36 -0700 (PDT)
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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
