Could be better views to look for this, but v$session reports what each session has. select username, server, status from v$session /Johan On Tue, 2006-01-17 at 12:41 +0530, Onkar N Tiwary wrote: > Hi, > > I just wanted to know the mode of the database if its a dedicated or > shared server mode. which data dictionary shall i use????? -- //www.freelists.org/webpage/oracle-l