Oracle Database Discussions

Db Version : 10.2.0.4

The dispatchers and shared_servers=1 are set. I assume this means we can use the db in shared server mode.

While setting up connections in Weblogic connection pool, the jdbc URL has SERVER=SHARED.

However, while querying v$session I am not able to see any shared sessions.

I am using the following query..

select * from v$session where server <> 'DEDICATED';

But this doesn't return me any rows or returns rows that is not what I am looking for. Basically I am expecting to see connections from
weblogic pool.

Is this the correct way to check or is there some other way ?

Pls let me know

Rgds,
Gokul