Skip to Content
Author's profile photo Former Member

SAP HANA Administration tables/views

The following are some of the important HANA tables/views required for administration


Table/View Name

Used for

M_LICENSE

Contains License information

_SYS_PASSWORD_BLACKLIST

Contains the list of blacklisted passwords

GRANTED_PRIVILEGES

Privileges granted directly to the specified user (or role) are listed. Privileges contained within granted roles are not shown.

GRANTED_ROLES

All roles granted directly to the specified user (or role) are listed

EFFECTIVE_PRIVILEGES

Privileges granted to the specified user both directly and indirectly through roles are listed separately.

EFFECTIVE_ROLES

All roles granted to the specified user both directly and indirectly through other roles are listed separately.

M_VOLUME_IO_STATISTICS

Lists the total read size and the total write size for each volume since the service in question was last started

M_VOLUME_IO_STATISTICS_RESET

Lists the statistics since the reset time.

M_LOG_SEGMENTS

Monitoring view for log segments

M_VOLUME_IO_STATISTICS

Aggregated I/O statistics for the volume since the service was started

M_DATA_VOLUME_PAGE_STATISTICS.

Displays statistics on the data volume’s pages

M_SERVICE_MEMORY

Lists the memory usage information

M_HEAP_MEMORY_RESET

View to reset memory usage

M_CS_TABLES

Provides column store table information

M_RS_TABLES

Provides row store table information

M_CS_COLUMNS

Contains memory related information of the Column store table’s columns

M_HOST_RESOURCE_UTILIZATION

Lists the resource utilization by the host

M_DELTA_MERGE_STATISTICS

Information about all delta merge operations since the last system start

HOST_DELTA_MERGE_STATISTICS

Delta merge statistics in the table, collected by the Statistics server

GLOBAL_MEMORY_STATISTICS

Global memory consumption of the database over the last 30 days

M_EXPORT_BINARY_STATUS

Monitor the progress of a running export

M_IMPORT_BINARY_STATUS

Monitor the progress of a running import

M_PERSISTENCE_ENCRYPTION_STATUS

Check persistence encryption status

M_PERSISTENCE_ENCRYPTION_KEYS

Check how long the current encryption key has been valid

M_BACKUP_CATALOG

Provides an overview of information about backup activities.

M_BACKUP_CATALOG_FILES

Provides information about the backups created, and the backup destinations that are used by data and log backups.

M_SERVICE_REPLICATION

Contains the basic status of replication between primary and secondary systems

M_CONVERTER_STATISTICS

View to estimate the size of the next complete data backup,

M_BACKUP_CATALOG

Provides an overview of information about backup activities.

M_BACKUP_CATALOG_FILES

Provides information about the backups created, and the backup destinations that are used by data and log backups.

Assigned tags

      3 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Andy Silvey
      Andy Silvey

      Hi Balaji,

      this is a very useful blog, thank you.

      Andy.

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      You are welcome

      Author's profile photo Digendra Singh
      Digendra Singh

      Hi Balaji,

      Blog is very helpful  Thanks..

      Digendra