Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2002
    Location
    India
    Posts
    4

    Unanswered: Informix administration data.

    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

  2. #2
    Join Date
    Aug 2002
    Location
    Belgium
    Posts
    534
    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.
    rws

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •