/////////////////////////////////////////////////////////////////////////////// // SQL> describe v$session // Name Null? Type // ----------------------------------------- -------- ---------------------------- // SADDR RAW(4) // SID NUMBER // SERIAL# NUMBER // AUDSID NUMBER // PADDR RAW(4) // USER# NUMBER // USERNAME VARCHAR2(30) // COMMAND NUMBER // OWNERID NUMBER // TADDR VARCHAR2(8) // LOCKWAIT VARCHAR2(8) // STATUS VARCHAR2(8) // SERVER VARCHAR2(9) // SCHEMA# NUMBER // SCHEMANAME VARCHAR2(30) // OSUSER VARCHAR2(30) // PROCESS VARCHAR2(9) // MACHINE VARCHAR2(64) // TERMINAL VARCHAR2(30) // PROGRAM VARCHAR2(48) // TYPE VARCHAR2(10) // SQL_ADDRESS RAW(4) // SQL_HASH_VALUE NUMBER // PREV_SQL_ADDR RAW(4) // PREV_HASH_VALUE NUMBER // MODULE VARCHAR2(48) // MODULE_HASH NUMBER // ACTION VARCHAR2(32) // ACTION_HASH NUMBER // CLIENT_INFO VARCHAR2(64) // FIXED_TABLE_SEQUENCE NUMBER // ROW_WAIT_OBJ# NUMBER // ROW_WAIT_FILE# NUMBER // ROW_WAIT_BLOCK# NUMBER // ROW_WAIT_ROW# NUMBER // LOGON_TIME DATE // LAST_CALL_ET NUMBER // PDML_ENABLED VARCHAR2(3) // FAILOVER_TYPE VARCHAR2(13) // FAILOVER_METHOD VARCHAR2(10) // FAILED_OVER VARCHAR2(3) // RESOURCE_CONSUMER_GROUP VARCHAR2(32) // PDML_STATUS VARCHAR2(8) // PDDL_STATUS VARCHAR2(8) // PQ_STATUS VARCHAR2(8) ///////////////////////////////////////////////////////////////////////////////// #ifndef TORACLESESSION_HH #define TORACLESESSION_HH #include "TObject.h" #include "TString.h" // truncated version... class TOracleSession: public TObject { public: TString fPROGRAM ; Int_t fLOGON_TIME; TString fOSUSER; TString fMACHINE; TString fPROCESS; TString fTERMINAL; TString fTYPE; Int_t fSID; Int_t fSERIAL; TString fSCHEMANAME; TString fMODULE; TString fSTATUS; //----------------------------------------------------------------------------- // //----------------------------------------------------------------------------- public: // ****** constructors and destructor TOracleSession(); ~TOracleSession(); // ****** overloaded methods of TObject void Clear(Option_t* Opt=""); void Print(Option_t* Opt="") const; ClassDef(TOracleSession,1) }; #endif