| 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: library cache pin on grant execute
That makes sense. I failed to consider cached information. Thanks for the reply.
Paul Baumgartel
paul.baumgartel_at_credit-suisse.com
212.538.1143
-----Original Message-----
From: Tanel Põder [mailto:tanel.poder.003_at_mail.ee]
Sent: Friday, April 07, 2006 8:33 AM
To: paul.baumgartel_at_credit-suisse.com; Mark.Bobak_at_il.proquest.com;
oracle-l
Subject: Re: library cache pin on grant execute
> I've often wondered why grants and revokes require exclusive pins. Why
> would a grant have to invalidate cached metadata for the object?
If might be just an implementation decision to keep the architecture consistent.
Grant is a change to data dictionary. Any data dictionary information present in library cache (in addition to dictionary cache) must be invalidated whenever there's a change done to data dictionary.
Tanel.
http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Apr 07 2006 - 08:39:00 CDT
 |
 |