Skip to Content

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.

To report this post you need to login first.

3 Comments

You must be Logged on to comment or reply to a post.

Leave a Reply