Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Virtual Private Databases and DB Pooling
In article <93j5m0$1ks$1_at_nnrp1.deja.com>,
neti0_at_yahoo.com wrote:
> Hello,
>
> I am looking at oracle's Virtual Private DB.
>
> My understanding is that we can get the fine-grained access control if
> we log in with our individual User ID / Password.
>
> If that is the case how does the DB Pooling get effected? What is the
> performance penalty?
>
> Thanks in advance
> Phani
>
Do you mean connection pooling? I don't know of any connection to that.
The performance penality is for each table (with a security policy) in
a query or DML, a additional predicate will be added by the DBMS. This
can be significant if there is more than one table with a policy or the
appropriate index is not in place.
Good Luck
Ron Plank
> Sent via Deja.com
> http://www.deja.com/
>
Sent via Deja.com
http://www.deja.com/
Received on Fri Jan 12 2001 - 10:15:32 CST