Which the data that I obtain of view DUAL?

I am in a company who 50% of the employees if connect by
application server, being thus view v$session does not show who
are loggged.
View dual brings this information, does not remember as to make
to remove this information.
Who can help me?
Tanks.

Quote:

---

Originally posted by hhbrazil
Tanks.

---

So you going to give tanks to those who help ;) If im not mistaken you are asking how to view users session created through application server right ??

More or but this, I know that the dual shows of terminal/machine
the user has connected... I need of this information

Use sys_context function.

example...

select sys_context('USERENV','OS_USER') from dual;
select sys_context('USERENV','IP_ADDRESS') from dual;
select sys_context('USERENV','TERMINAL') from dual;

HTH

OMG so much info in a single row single column table?? ;)

Obviously NOT normalised!

tank you a lot... Mr adewri