Skip to end of metadata
Go to start of metadata

The query corresponding to each monitoring element to check object information is as follows.

Memory Table Usage

This queries the usage of memory tables.

  • Main Column Description

ColumnDescription
USER_NAMETable owner
TABLE_NAMETable name
PARTITION_NAMEThe 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_NAMETablespace 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)

Queue

This queries the usage of the queue table.

For column description, refer to Memory table and usage column description.

Memory Table with Low Efficiency

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.

  • Main Column Description

ColumnDescription
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)

Memory Index, Queue Index 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.

  • Main Column Description

ColumnDescription
INDEX_PARTITIONEDWhether 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.

Disk Table

This is Disk table usage information. Since the query is different for each version, the user should use the query for the version.

  • Main Column Description

ColumnDescription
TABLE_NAMETable name
PARTITIONED_TABLEWhen a partition table is created in a table, the name of the partition table is displayed. '-' For non-partitioned tables
TBS_NAMEShows 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.

Disk Index Usage

This is disk index usage information. Since the query is different for each version, the user should use the query for the version.

  • Main Column Description

ColumnDescription
TABLE_NAMETable name
PARTITIONED_TABLEWhen a partitioned table is created on a table, the name of the partition table is displayed. '-' For non-partitioned tables
INDEX_NAMEIndex name
PARTITIONED_INDEXWhen a partitioned index is created on an index, the partitioned index name is displayed. '-' For non-partitioned indexes
TBS_NAMEThe 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.

Partition Table Information

This query shows information about the partition table, such as the partition table partitioning method and partitioning criteria.

  • Main Column Description

ColumnDescription
PARTITIONED_METHODShows how to partition the partition table.
PARTITION_ORDERFor hash partitions, this shows the order of the partitions.
ROW_MOVEMENTShows 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_VALUEFor 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_VALUEIn 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.
ACCESSShows 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
CREATEDThis is the time when the partition table was created. This column is available in Altibase 6.5.1 and later.
LAST_DDL_TIMEThis is the last time DDL was executed on the partition table. This column is available in Altibase 6.5.1 and later.

Sequence

This query shows information about sequence objects.

Synonym

This query shows information about synonyms.

  • Main Column Description

ColumnDescription
SYNONYM_OWNERThe 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_OWNERThe owner of the synonym target object
OBJECT_NAMEThe name of the synonym target object
LAST_DDL_TIMEThe last name DDL was executed on synonym

PSM

This query shows execution information for stored procedures and functions.

  • Main Column Description

ColumnDescription
STATUSCompile status. INVALID requires compilation

PSM Creation Statement

When the PSM name is entered in the PROC_NAME condition, the PSM creation statement is displayed.

View

This query shows information about the VIEW object.

View Creating Statement

When a view name is entered in the TABLE_NAME condition, the VIEW creation statement is displayed.

Package

This shows information about the package.

  • Main Column Description

 

ColumnDescription
PACKAGE_TYPEPackage type. Whether it is a PACKAGE Specification or PACKAGE Body.
STATUSCompile status. INVALID requires compilation.

PACKAGE Subprogram

This shows information about subprograms (stored procedures and store functions) included in the package.

  • Main Column Description

ColumnDescription
SUB_TYPECompile status. If 1, compile is required.
PARA_NAMESubprogram parameter name
PARA_ORDERSubprogram parameter sequence. Has 1 in the first case.
INOUT_TYPEParameter input/output
DATA_TYPEParameter data type
SIZEThe size of a parameter type
DEFAULT_VALThe default value of a parameter

PACKAGE Creating Statement

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.

Trigger

This shows trigger creation information.

  • Main Column Description

ColumnDescription
TABLE_NAMETable name where the trigger is defined
IS_ENABLEWhether TRIGGER works.
EVENT_TIMETime to trigger
EVENT_TYPEType of event that triggers
GRANULARITYUnit that triggers

Job

This shows information about the job object.

  • Main Column Description

ColumnDescription
JOB_NAMEThe name of the JOB object
PROC_NAMEThe name of the procedure registered in JOB
NTERVAL, INTERVAL_TYPEPerformance cycle
STATEJOB progress status. If ING, it means that the procedure is currently being executed by the task scheduler.
EXEC_COUNTThe number of JOB executions
ERROR_CODEThe result of the last JOB execution
START_TIMEThe time when JOB first started executing
LAST_EXEC_TIMEThe time at which the JOB was last executed means the time that was most recently executed.
END_TIMEThe time at which the last JOB was executed.
IN_ENABLEWhether is the JOB execution is possible by the job scheduler

Database User

This is a statement to search database user information.

Tablespace List

This is a statement to search the tablespace list.

 

 

 

 

 

  • No labels