The query corresponding to each monitoring element to check object information is as follows.
Column | Description |
---|---|
USER_NAME | Table owner |
TABLE_NAME | Table name |
PARTITION_NAME | The name of the partitioned table if you created the partitioned table on the table. Memory partition tables are supported starting from 6.5.1. |
TBS_NAME | Tablespace name specified when creating the table |
ALLOC(M) | The total number of pages allocated to the memory table |
USED(M) | The total of 'pages loaded with actual data' among the pages allocated by the memory table. For example, if the user executes a full DELETE on a memory table with an ALLOC size of 100M, ALLOC will not change to 100M, but USED will be close to zero. The user can reduce ALLOC by executing TRUNCATE. |
USAGE(%) | This is expressed as a percentage of the 'page loaded with actual data' among pages allocated to the memory table. (Ie USED / ALLOC) |
This queries the usage of the queue table.
This queries a memory table which actual usage is lower than the all allocated pages.
This outputs the memory table with the total size of pages allocated from the memory table of 1G or more and USAGE of 50% or less.
Description | |
---|---|
ALLOC(M) | The total number of pages allocated to the memory table |
USED(M) | The total of 'pages loaded with actual data' among the pages allocated by the memory table. For example, if the user executes a full DELETE on a memory table with an ALLOC size of 100M, ALLOC will not change to 100M, but USED will be close to zero. The user can reduce ALLOC by executing TRUNCATE. |
USAGE(%) |
This queries the index usage of the memory table and queue tables.
Since the query is different for each version, the user should use the query for the version.
Column | Description |
---|---|
INDEX_PARTITIONED | Whether the index is a partition index. F: Non-partition index T: Partition index (Memory partition index is supported in Altibase 6.5.1 or later.) |
SIZE(MB) | The user can find the index size by the number of nodes attached to the index. One page is used for every 15 index nodes, and the page size is 32 KB. There is a difference in the number of slots available for each node according to the Altibase server version. For this reason, even if the data is the same, the index size may differ depending on the version. |
This is Disk table usage information. Since the query is different for each version, the user should use the query for the version.
Column | Description |
---|---|
TABLE_NAME | Table name |
PARTITIONED_TABLE | When a partition table is created in a table, the name of the partition table is displayed. '-' For non-partitioned tables |
TBS_NAME | Shows the tablespace specified when creating the table. If a tablespace is specified for a partitioned table, the tablespace name specified in the partitioned table is displayed. |
MAX(MB) | The maximum size of the tablespace to which the table belongs |
ALLOC(MB) | The total size of the table allocated |
USED(MB) | Refers to the size of the table allocated data that contains data. When DELETE the data, the space DELETE can be reused, but in the case of a disk table, unlike a memory table, USED does not decrease even if DELETE is performed. To check the actual USED except for the space that can be reused as DELETE, AGING must be performed. Ex) ALTER TABLE table_name AGING; ALTER TABLE ~ AGING; Because it holds the X lock on the table during execution, other requests for the table will be in a waiting state, so be careful when performing it. ALLOC and USED always have the same value unless AGING is performed. |
This is disk index usage information. Since the query is different for each version, the user should use the query for the version.
Column | Description |
---|---|
TABLE_NAME | Table name |
PARTITIONED_TABLE | When a partitioned table is created on a table, the name of the partition table is displayed. '-' For non-partitioned tables |
INDEX_NAME | Index name |
PARTITIONED_INDEX | When a partitioned index is created on an index, the partitioned index name is displayed. '-' For non-partitioned indexes |
TBS_NAME | The tablespace specified when creating the index. If a tablespace is specified in a partitioned index, the tablespace name specified in the partitioned index is displayed. |
MAX(MB) | The maximum size of the tablespace to which the index belongs |
ALLOC(MB) | The total size allocated to the index |
USED(MB) | The size of the index allocated space that contains data. If DELETE is performed on the data, the space DELETE can be reused, but the USED of the index does not decrease even when DELETE is performed. To check the actual USED except for the space that can be reused as DELETE, AGING must be performed. Ex) ALTER INDEX index_name AGING; ALTER INDEX ~ AGING; During execution, because the X lock is held on the table, other requests for the table will be in a waiting state, so be careful when performing it. ALLOC and USED always have the same value unless AGING is performed. |
This query shows information about the partition table, such as the partition table partitioning method and partitioning criteria.
Column | Description |
---|---|
PARTITIONED_METHOD | Shows how to partition the partition table. |
PARTITION_ORDER | For hash partitions, this shows the order of the partitions. |
ROW_MOVEMENT | Shows whether it is allowed to automatically move the record to another partition when the partitioned table record is updated and the column value corresponding to the partition key is changed to a value belonging to another partition. T is allowed to move and F is not allowed. This option is set when creating a partition table. |
PARTITION_MIN_VALUE | For range partitions, the minimum reference value of the partition table is displayed as a string. For a list partition, PARTITION_MIN_VALUE and PARTITION_MAX_VALUE are the same. In the case of a hash partition, both PARTITION_MIN_VALUE and PARTITION_MAX_VALUE are null. |
PARTITION_MAX_VALUE | In the case of range partition, the maximum reference value of the partition table is displayed as a string. For a list partition, PARTITION_MIN_VALUE and PARTITION_MAX_VALUE are the same. In the case of a hash partition, both PARTITION_MIN_VALUE and PARTITION_MAX_VALUE are null. |
ACCESS | Shows the access mode for data in the partition table. This column is available in Altibase 6.5.1 and later. R: Data read-only mode W: Data read/write mode (basic mode) A: Data read/add mode |
CREATED | This is the time when the partition table was created. This column is available in Altibase 6.5.1 and later. |
LAST_DDL_TIME | This is the last time DDL was executed on the partition table. This column is available in Altibase 6.5.1 and later. |
This query shows information about sequence objects.
This query shows information about synonyms.
Column | Description |
---|---|
SYNONYM_OWNER | The database user who created the synonym. When this value is 'PUBLIC', it means synonym created by default so that anyone can use it when creating a database. |
OBJECT_OWNER | The owner of the synonym target object |
OBJECT_NAME | The name of the synonym target object |
LAST_DDL_TIME | The last name DDL was executed on synonym |
This query shows execution information for stored procedures and functions.
Description | |
---|---|
STATUS |
When the PSM name is entered in the PROC_NAME condition, the PSM creation statement is displayed.
This query shows information about the VIEW object.
When a view name is entered in the TABLE_NAME condition, the VIEW creation statement is displayed.
Package
This shows information about the package.
Description | |
---|---|
PACKAGE_TYPE | Package type. Whether it is a PACKAGE Specification or PACKAGE Body. |
STATUS |
This shows information about subprograms (stored procedures and store functions) included in the package.
Description | |
---|---|
SUB_TYPE | Compile status. If 1, compile is required. |
PARA_NAME | Subprogram parameter name |
PARA_ORDER | Subprogram parameter sequence. Has 1 in the first case. |
INOUT_TYPE | Parameter input/output |
DATA_TYPE | Parameter data type |
SIZE | The size of a parameter type |
DEFAULT_VAL |
When the package name is entered in the PACKAGE_NAME condition, the PACKAGE creation statement is displayed. This is available in Altibase 6.3.1 and later.
This shows trigger creation information.
Description | |
---|---|
TABLE_NAME | Table name where the trigger is defined |
IS_ENABLE | Whether TRIGGER works. |
EVENT_TIME | Time to trigger |
EVENT_TYPE | Type of event that triggers |
GRANULARITY |
This shows information about the job object.
Column | Description |
---|---|
JOB_NAME | The name of the JOB object |
PROC_NAME | The name of the procedure registered in JOB |
NTERVAL, INTERVAL_TYPE | Performance cycle |
STATE | JOB progress status. If ING, it means that the procedure is currently being executed by the task scheduler. |
EXEC_COUNT | The number of JOB executions |
ERROR_CODE | The result of the last JOB execution |
START_TIME | The time when JOB first started executing |
LAST_EXEC_TIME | The time at which the JOB was last executed means the time that was most recently executed. |
END_TIME | The time at which the last JOB was executed. |
IN_ENABLE | Whether is the JOB execution is possible by the job scheduler |
This is a statement to search database user information.
This is a statement to search the tablespace list.