Try OpenEdge Now
skip to main content
Database Administration
Reference : Virtual System Tables : Virtual system table summaries
 

Virtual system table summaries

This sections that follow, are an alphabetical summary of the OpenEdge RDBMS's virtual system tables.
* After-image log activity (_ActAILog)
* Before-image log activity (_ActBILog)
* Buffer activity (_ActBuffer)
* Index activity (_ActIndex)
* Input/output activity (_ActIOFile)
* Input/output type activity (_ActIOType)
* Lock table activity (_ActLock)
* Other activity (_ActOther)
* Page writer activity (_ActPWs)
* Record activity (_ActRecord)
* Server activity (_ActServer)
* Space allocation activity (_ActSpace)
* Summary activity (_ActSummary)
* Area status (_AreaStatus)
* Area threshold (_AreaThreshold)
* Block (_Block)
* Buffer status (_BuffStatus)
* Cache (_Cache)
* Checkpoint (_Checkpoint)
* Code Features (_Code-Feature)
* Database connection (_Connect)
* Database features (_Database-Feature)
* Database startup parameters file status (_DbParams)
* Database status (_DbStatus)
* Database file status (_Filelist)
* Index statistics (_IndexStat)
* Latch statistics (_Latch)
* License management (_License)
* Lock table status (_Lock)
* Lock request (_LockReq)
* Logging (_Logging)
* Master block (_MstrBlk)
* User connection (_MyConnection)
* Resource queue statistics (_Resrc)
* Segments (_Segments)
* Servers (_Servers)
* SQL query plan (_SQL_Qplan)
* Startup (_Startup)
* Index and table statistics range (_StatBase)
* Table statistics (_TableStat)
* Transaction (_Trans)
* Transaction end lock statistics (_TxeLock)
* User index activity (_UserIndexStat)
* Database input/output (_UserIO)
* Record locking table (_UserLock)
* User status (_UserStatus)
* User table activity (_UserTableStat)