Re: Number of Oracle Connections

Select Count(*)
FROM v$session;

is much faster because you don't have to wait for the entire contents of the v$session dynamic performance view to be spooled to your screen.

This can take a long time, especially if you are e.g. administering over a slow WAN link and or have hundereds of sessions.

D.P. Received on Sun Sep 03 2000 - 03:23:30 CDT