Re: finding default connection type....

tekion wrote:
> Does,
> any know how to find out which connection type "shared" or "dedicated"
> is set as the default. As far as I know, the default oracle
> installation set "default" as the defult connection type. Thanks.

If there is a dispatcher set up for your protocol and the client tnsnames.ora doesn't override it by specifying (server=dedicated) in the connection string, it is shared.
In all other cases it is dedicated.
This is explained in the Net administrators manual at length of course.

-- 
Sybrand Bakker
Senior Oracle DBA