Re: Bind session to a Shared Server?

On Tue, 16 Aug 2005 16:25:52 GMT, netcomradeNSPAM_at_bookexchange.net (NetComrade) wrote:

>Is there are any way to do this?
>Would like to do this, so that we could look at a single trace file
>for a session, instead of multiple ones if a sql requests migrate from
>(shared) server to (shared) server.
>Besides the hassle of multiple trace files, I have seen a few times in
>the past where the execution plan was different in dedicated vs. mts.
>
>-a
>.......
>We use Oracle 8.1.7.4 and 9.2.0.6/7 on Solaris 2.7 and RH4
>remove NSPAM to email

You could

1. upgrade to 10g, which offers a shared server trace consolidation feature.
2. Force a dedicated session from the specific client you want to trace, allowing you to trace this specific session and letting all others running shared server as usual. It is done via tnsnames.ora :

myconn =
(DESCRIPTION=
  (ADDRESS=(PROTOCOL=tcp)(HOST=myhost)(PORT=1521))   (CONNECT_DATA=

     (SERVICE_NAME=myservice)
     (SERVER=dedicated))) <-----------------------

• Kenneth Koenraadt