Monitors RLV store memory usage per table.
You must have EXECUTE privilege on the system procedure, as well as the MONITOR system privilege.
Version-specific data, such as version bitmaps and on-demand indexes, are not included in RLV memory accounting. They do not count against the RLV memory limit, and are not reported in sp_iqrlvmemory.
If no parameters are specified, information on all RLV tables consuming memory is returned. table_name, with the additional option of table_owner, can be provided to restrict the output to one table. If table_owner is not specified, it defaults to the current user.
Column Name | Description |
---|---|
table_id | ID of the table this row represents. |
fragments | Number of store fragments for this table. |
total | Total RLV store memory, in MB, used by this table. |
data | RLV store memory, in MB, used for the column fragments for this table. |
dictionary | RLV store memory, in MB, used for the dictionaries for this table. |
bitmap | RLV store memory, in MB, used to store table-level bitmaps. |
This example returns the current RLV memory usage for the table rlv_table1 owned by user DBA.
sp_iqrlvmemory ‘rlv_table1’, ‘DBA’
Output:
table_id | fragments | total | data | dictionary | bitmap | |
---|---|---|---|---|---|---|
1 | 778 | 1 | 1 | 0 | 1 | 1 |
2 | 779 | 1 | 48 | 48 | 0 | 1 |
3 | 785 | 2 | 1596 | 1584 | 0 | 12 |