SAP HANA Administration tables/views

[Former Member]

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.