| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Overhead using a role
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
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
 |
 |