# Information Schema XTRADB\_READ\_VIEW Table

The [Information Schema](https://mariadb.com/docs/server/reference/system-tables/information-schema) `XTRADB_READ_VIEW` table contains information about the oldest active transaction in the system.

The `PROCESS` [privilege](https://mariadb.com/docs/server/reference/sql-statements/account-management-sql-statements/grant) is required to view the table.

It has the following columns:

| Column                              | Description                                                                                                                                    |
| ----------------------------------- | ---------------------------------------------------------------------------------------------------------------------------------------------- |
| READ\_VIEW\_UNDO\_NUMBER            |                                                                                                                                                |
| READ\_VIEW\_LOW\_LIMIT\_TRX\_NUMBER | Highest transaction number at the time the view was created.                                                                                   |
| READ\_VIEW\_UPPER\_LIMIT\_TRX\_ID   | Highest transaction ID at the time the view was created. Should not see newer transactions with IDs equal to or greater than the value.        |
| READ\_VIEW\_LOW\_LIMIT\_TRX\_ID     | Latest committed transaction ID at the time the oldest view was created. Should see all transactions with IDs equal to or less than the value. |

<sub>*This page is licensed: CC BY-SA / Gnu FDL*</sub>

{% @marketo/form formId="4316" %}