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

    Unanswered: Tables in informix ---- Urgent

    Can somebody help me the informix equalent tables for the following oracle tables or where can I get the similar data.

    V$VERSION
    V$SESSION
    V$PROCESS
    V$SESS_IO
    V$SQLTEXT

    I really need help on this plzzzzz....

    Thanks in advance

  2. #2
    Join Date
    Mar 2002
    Posts
    112

    re

    Version=`oninit -V`
    Session=`onstat -g ses`
    Process=`onstat -g glo` (for see oninit process)
    Session io=`onstat -g tfp` (you have to find thread from onstat -g ses)
    Sql statement=`onstat -g sql`

    You can select from SMI but I think it's easier

  3. #3
    Join Date
    Oct 2002
    Location
    Buenos Aires
    Posts
    7

    Equivalence

    Also, check the system tables in the sysmaster database
    (system tables start with sys*)
    e.g. syssession

    greetz

Posting Permissions

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