Can somebody suggest me which tables-fields will provide the following info. I am giving the oracle table-filed names for your reference.

Info Required Oracle Table-Filed Informix Table-Field

Machine V$SESSION-MACHINE syssessions-hostname
Banner V$VERSION-BANNER ??????????
Process Id V$PROCESS-SPID ??????????
Session Id V$SESSION-SID syssessions-sid
Sqltext V$SQLTEXT-SQL_TEXT ??????????


Your help would be highly appreciated.

Thanks & Regards
Balaji Srinivas P

Hi,

It is impossible to compare these Oracle tables with Informix tables.
Just to give you an example:
Every connection to an Oracle instance is translated into a process. In Informix it is translated into a thread.
This means that a session is (syssessions) is allocated to a thread, named sqlexec.
check with onstat commands to descipher all this.
What is an Oracle banner?
For the machine name you will have to create a stored procedure
with system 'uname' in it.