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 -> Synonym Performance

Synonym Performance

From: Paul Bennett <bennett_at_cc.gatech.edu>
Date: 1998/04/06
Message-ID: <352957C9.4ED24A21@cc.gatech.edu>#1/1

What performance problems are there between public synonyms verses private synonyms verses your own tables.

Another way to phrase it. If I connect as the table owner and do a query. Then connect as another user and run the same query public synonym, then by private synonym. With the last two queries be seen as already parsed SQL, and will the db_blocks in memory be used?

Also, where can I find information like this on oracle's web site?

Thanks.

Received on Mon Apr 06 1998 - 00:00:00 CDT

Original text of this message

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