HANA DATA DICTIONARY

System Tables and Monitoring Views The following public system tables and monitoring views are available:

AUDIT_POLICIES - Defined audit policies
AUTHORIZATION_GRAPH - Represents authorization dependencies of complex database objects
CONSTRAINTS - Constraints defined for tables

CS_BO_VIEWS - Business object views for column store join views
CS_FREESTYLE_COLUMNS - Freestyle search columns for column store join views
CS_JOIN_CONDITIONS - Join conditions defined for column store join views
CS_JOIN_CONSTRAINTS - Join constraints defined for column store join views
CS_JOIN_PATHS - Join paths defined for column store join views
CS_JOIN_TABLES - Physical tables referred by column store join views
CS_KEY_FIGURES - Key figures defined for column store join views
CS_VIEW_COLUMNS - Columns defined for column store join views

DATA_TYPES - Available SQL data types
EFFECTIVE_PRIVILEGES - Privileges of the current user
EXPLAIN_PLAN_TABLE - SQL query plan explanation result
FULLTEXT_INDEXES - Fulltext indexes on table columns
FUNCTIONS - Available functions
FUNCTION_PARAMETERS - Parameters of functions
GRANTED_PRIVILEGES - Privileges granted to users and roles
GRANTED_ROLES - Roles granted to users or other roles
INDEXES - Indexes on tables
INDEX_COLUMNS - Columns of indexes
INVALID_CONNECT_ATTEMPTS - Number of invalid connect attempts for a user between two successful connects


M_ATTACHED_STORAGES - Information about currently attached devices
M_BACKUP_CATALOG - Common data for all backup catalog entries
M_BACKUP_CATALOG_FILES - Location information of all backup catalog entries
M_BACKUP_CONFIGURATION - Backup configuration statistics
M_BLOCKED_TRANSACTIONS - Transaction list waiting for locks
M_CACHES - Shows aggregated information on caches
M_CACHES_RESET - Shows aggregated information on caches
M_CACHE_ENTRIES - Cache entry information
M_CATALOG_MEMORY - Memory usage information by catalog manager
M_CE_CALCSCENARIOS - All available CalculationScenarios
M_CE_CALCVIEW_DEPENDENCIES - All views that are referencing a CalculationScenario
M_CE_DEBUG_INFOS - Debug information after execution of a CalculationScenario
M_CE_DEBUG_JSONS - All available JSONS (original, instantiated, optimized) of a scenario for a concrete query
M_CE_DEBUG_NODE_MAPPING - Node mapping between CalculationNodes and RuntimeNodes after execution
M_CE_PLE_CALCSCENARIOS - All available CalculationScenarios created by the PlanningEngine
M_CLIENT_VERSIONS - Versions of all supported client applications
M_COMPACTION_THREAD - Compaction thread statistics
M_CONDITIONAL_VARIABLES - Semaphore statistics
M_CONDITIONAL_VARIABLES_RESET - Semaphore statistics
M_CONFIGURATION - Configuration parameters
M_CONNECTIONS - Detailed information on connections between a client and database. Information includes connection status, client information, connection type, resource utilization
M_CONNECTION_STATISTICS - Detailed statistics on each connection between an application and database
M_CONTAINER_DIRECTORY - ContainerDirectory statistics
M_CONTAINER_NAME_DIRECTORY - ContainerNameDirectory statistics
M_CONTEXT_MEMORY - Memory allocator statistics
M_CONTEXT_MEMORY_RESET - Memory allocator statistics
M_CONVERTER_STATISTICS - Converter statistics
M_CONVERTER_STATISTICS_RESET - Converter statistics
M_CS_ALL_COLUMNS - Runtime information of all columns of column tables, inclusive internal ones
M_CS_COLUMNS - Runtime information of columns of column tables
M_CS_PARTITIONS - Partition information of column tables
M_CS_TABLES - Runtime data of column tables
M_CS_UNLOADS - A history of column unloads
M_DATABASE - Database information
M_DATABASE_HISTORY - Installation version history
M_DATA_VOLUMES - DataVolume statistics
M_DATA_VOLUME_PAGE_STATISTICS - Page usage statistics on data volumes
M_DATA_VOLUME_PAGE_STATISTICS_RESET - Page usage statistics on data volumes
M_DATA_VOLUME_SUPERBLOCK_STATISTICS - FreeBlockManager Superblock statistics
M_DELTA_MERGE_STATISTICS - Table delta merge statistics
M_DISKS - Disk configuration and utilization of the host machine
M_ERROR_CODES - Error codes with descriptions
M_EVENTS - Internal events
M_EXPENSIVE_STATEMENTS - All statements with duration longer than a threshold
M_EXPORT_BINARY_STATUS - Export status information for current session
M_EXTRACTORS - Direct extractor connection (DXC) status information
M_FEATURES - All supported features
M_FULLTEXT_QUEUES - Fulltext index queue status
M_GARBAGE_COLLECTION_STATISTICS - Garbage collection/history manager statistics
M_GARBAGE_COLLECTION_STATISTICS_RESET - Garbage collection/history manager statistics
M_HEAP_MEMORY - Memory allocator statistics
M_HEAP_MEMORY_RESET - Memory allocator statistics
M_HISTORY_INDEX_LAST_COMMIT_ID - Last commit ID of history index for each session
M_HOST_INFORMATION - Host information such as machine, OS configuration
M_HOST_RESOURCE_UTILIZATION - Host resource utilization, CPU time is in milliseconds and added across all cores since system start
M_IMPORT_BINARY_STATUS - Import status information for current session
M_INIFILES - All configuration files
M_INIFILE_CONTENTS - Configuration information from inifiles
M_JOB_PROGRESS - Current long running system operations
M_LANDSCAPE_HOST_CONFIGURATION - Host roles in a distributed landscape
M_LICENSE - Information on the currently valid license (if any) installed on this system
M_LICENSE_USAGE_HISTORY - Information on the maximum resource consumption per time period, used for validity check of license installed on this system (if any)
M_LIVECACHE_CONTAINER_STATISTICS - LiveCache container statistics
M_LIVECACHE_CONTAINER_STATISTICS_RESET - LiveCache container statistics
M_LIVECACHE_LOCKS - Detailed information on the Object Management System (OMS) locks
M_LIVECACHE_LOCK_STATISTICS - LiveCache lock statistics
M_LIVECACHE_LOCK_STATISTICS_RESET - LiveCache lock statistics
M_LIVECACHE_OMS_VERSIONS - Detailed information on the OMS versions that currently exists
M_LIVECACHE_PROCEDURE_STATISTICS - LiveCache procedure statistics
M_LIVECACHE_PROCEDURE_STATISTICS_RESET - LiveCache procedure statistics
M_LIVECACHE_SCHEMA_STATISTICS - LiveCache schema statistics
M_LIVECACHE_SCHEMA_STATISTICS_RESET - LiveCache schema statistics
M_LOCK_WAITS_STATISTICS - Accumulated lock wait count and duration for record lock, table lock and metadata lock for all available services from DB startup until now
M_LOG_BUFFERS - Log buffer statistics
M_LOG_BUFFERS_RESET - Log buffer statistics
M_LOG_PARTITIONS - Log partition statistics
M_LOG_PARTITIONS_RESET - Log partition statistics
M_LOG_SEGMENTS - Log segment statistics
M_LOG_SEGMENTS_RESET - Log segment statistics
M_MEMORY_OBJECTS - Memory object statistics
M_MEMORY_OBJECTS_RESET - Memory object statistics
M_MEMORY_OBJECT_DISPOSITIONS - Disposition specific memory object statistics. The statistics are calculated and reading them may take a while.
M_MERGED_TRACES - Contains the merged content of the server trace files for all of the SAP HANA processes
M_MONITORS - Available monitoring views
M_MONITOR_COLUMNS - All the columns in the monitoring views
M_MUTEXES - Mutex statistics
M_MUTEXES_RESET - Mutex statistics
M_MVCC_TABLES - Statistics of row-store Multiversion Concurrency Control (MVCC) manager
M_OBJECT_LOCKS - Status of currently acquired locks on objects with detailed information such as lock acquisition time, lock mode
M_OBJECT_LOCK_STATISTICS - Lock contention statistics - lock wait count, wait time, failed count for each objects
M_OBJECT_LOCK_STATISTICS_RESET - Lock contention statistics - lock wait count, wait time, failed count for each objects
M_PAGEACCESS_STATISTICS - PageAccess statistics
M_PAGEACCESS_STATISTICS_RESET - PageAccess statistics
M_PASSWORD_POLICY - Configuration values concerning password policy
M_PERFTRACE - Current PerfTrace state
M_PERSISTENCE_MANAGERS - Persistence manager statistics
M_PERSISTENCE_MANAGERS_RESET - Persistence manager statistics
M_PREPARED_STATEMENTS - Prepared statements list
M_READWRITELOCKS - Read/Write lock statistics
M_READWRITELOCKS_RESET - Read/Write lock statistics
M_RECORD_LOCKS - Record lock status
M_REORG_ALGORITHMS - Landscape redistribution algorithms
M_REPO_TRANSPORT_FILES - All repository transport files
M_RS_INDEXES - Statistics of B-tree and CPB-tree indexes
M_RS_TABLES - Information on row tables: detailed table sizes and record count
M_RS_TABLE_VERSION_STATISTICS - Information on row table versions: detailed version counts and used sizes

M_SAVEPOINTS - Current and historical savepoint statistics
M_SAVEPOINT_STATISTICS - Savepoint statistics
M_SAVEPOINT_STATISTICS_RESET - Savepoint statistics
M_SEMAPHORES - Semaphore statistics
M_SEMAPHORES_RESET - Semaphore statistics
M_SERVICES - Status of all services
M_SERVICE_COMPONENT_MEMORY - Service-specific memory usage by logical component
M_SERVICE_MEMORY - Detailed information on memory utilization by services
M_SERVICE_NETWORK_IO - Service network I/O statistics
M_SERVICE_REPLICATION - Information about replicated services
M_SERVICE_STATISTICS - Statistics on active services
M_SERVICE_THREADS - Detailed information on threads created by services
M_SERVICE_THREAD_CALLSTACKS - Stack frame information for service threads
M_SERVICE_TRACES - Configured trace components for each service type
M_SERVICE_TYPES - Service types
M_SESSION_CONTEXT - Session variables for each connection.
M_SHARED_MEMORY - Shared memory usage information by SAP HANA indexserver
M_SNAPSHOTS - Existing snapshots
M_SQL_PLAN_CACHE - Statistics of an individual execution plan
M_SQL_PLAN_CACHE_OVERVIEW - Overall statistics of evicted and cached plans
M_SQL_PLAN_CACHE_RESET - Statistics of an individual execution plan
M_SYSTEM_INFORMATION_STATEMENTS - System information statements
M_SYSTEM_LIMITS - System limits information
M_SYSTEM_OVERVIEW - Overview of system status including important resource usage information and alerts

M_TABLES - Information on row and column tables
M_TABLE_LOB_FILES - All LOB files that belong to a table
M_TABLE_LOCATIONS - Tables and their logical location. Physical locations are shown in M_TABLE_PERSISTENCE_LOCATIONS
M_TABLE_PERSISTENCE_LOCATIONS - Column store tables and their physical data locations
M_TABLE_PERSISTENCE_STATISTICS - Persistence virtual file summary statistics for tables
M_TABLE_VIRTUAL_FILES - All virtual files that belong to a table
M_TEMPORARY_TABLES - Temporary tables
M_TEMPORARY_TABLE_COLUMNS - Columns of temporary tables
M_TEMPORARY_VIEWS - Temporary views
M_TEMPORARY_VIEW_COLUMNS - Columns of temporary tables
M_TENANTS - Available tenant information
M_TEXT_ANALYSIS_LANGUAGES - List of supported languages
M_TEXT_ANALYSIS_MIME_TYPES - List of supported mime types
M_TOPOLOGY_TREE - SAP HANA nameserver topology content
M_TRACEFILES - All trace files
M_TRACEFILE_CONTENTS - SAP HANA information from trace files
M_TRANSACTIONS - All transactions created by users or database
M_UNDO_CLEANUP_FILES - Information about undo files and cleanup files
M_VERSION_MEMORY - Memory usage of row-store Multiversion Concurrency Control (MVCC) manager
M_VOLUMES - Volumes used by SAP HANA servers
M_VOLUME_FILES - Information about volume files
M_VOLUME_IO_PERFORMANCE_STATISTICS - File performance statistics
M_VOLUME_IO_PERFORMANCE_STATISTICS_RESET - File performance statistics
M_VOLUME_IO_STATISTICS - File access statistics
M_VOLUME_IO_STATISTICS_RESET - File access statistics
M_VOLUME_SIZES - Volume sizes used by SAP HANA servers
M_WORKLOAD - Database workload collected every minute
M_XS_APPLICATIONS - Applications deployed and running in SAP HANA XS
M_XS_APPLICATION_ISSUES - Issues related to applications in SAP HANA XS


OBJECTS - Available objects
OBJECT_DEPENDENCIES - Dependencies between objects, for example, views which refer to a specific table
OWNERSHIP - Ownership of available objects when users create any object in other users' schemas
PRIVILEGES - Available privileges
PROCEDURES - Available stored procedures
PROCEDURE_OBJECTS - Contains results of the system procedure GET_PROCEDURE_OBJECTS
PROCEDURE_PARAMETERS - Parameters of stored procedures
QUERY_PLANS - Plans how to handle query execution
REFERENTIAL_CONSTRAINTS - Referential constraints
REORG_OVERVIEW - Overview of landscape redistributions
REORG_PLAN - Current plan for landscape reorganization
REORG_PLAN_INFOS - Additional informations about current landscape reorganization plan
REORG_STEPS - Details of landscape redistribution
ROLES - Shows available roles
SAML_PROVIDERS - Shows available SAML provider
SAML_USER_MAPPINGS - Shows the SAML providers known for each user
SCHEMAS - Shows available schemas
SEQUENCES - Available sequences
SQLSCRIPT_TRACE - Contains the names of the local temporary tables created by the SQLScript TRACE operator
STATISTICS - Stores a histogram of tables. The histogram can be used by query optimizer to calculate size of an intermediate result
STRUCTURED_PRIVILEGES - Available structured privileges
SYNONYMS - Available synonyms
TABLES - Available tables
TABLE_COLUMNS - Available table columns
TABLE_COLUMNS_ODBC - Available table columns
TABLE_GROUPS - Overview of table groups relations
TRANSACTION_HISTORY - Committed transactions and their users
TRIGGERS - Triggers defined for tables
USERS - All users
USER_PARAMETERS - All parameters and their values, which have been assigned to users in the system (using CREATE USER ... SET PARAMETER or ALTER USER ... SET PARAMETER)
VIEWS - Available views
VIEW_COLUMNS - Available view columns