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

Home -> Community -> Usenet -> c.d.o.server -> Re: Virtual Private Databases and DB Pooling

Re: Virtual Private Databases and DB Pooling

From: <ronplank_at_my-deja.com>
Date: Fri, 12 Jan 2001 16:15:32 GMT
Message-ID: <93naip$i9k$1@nnrp1.deja.com>

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

Original text of this message

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