Hi Gurus,
thanks.I am very happy with the answers.But...
1.From V$resource_limit and v$license I get max connections from the instance started...
2.From SEMMNS we get the max allowed connections to the database....(Max limit to that server)
How can I find out the max no.of connections abtained since the database was created...Is there any way?.
Ours is multi threaded server having set SEMMNS 10250..
SEMMSL =256...There are 7 databases sitting in this server..
having processes defined in init.ora ranging from 50 to max 256(50,50,100,100,100,200,256).
Thanks.
Thanigaivasan.