System Table Updates
This section contains information on system tables updates for Vertica Analytic Database 8.1.x.
GRACE_PERIOD Column
System tables SESSIONS
and USERS
now include a GRACE_PERIOD
column that is set by SET SESSION GRACEPERIOD
and CREATE USER/ALTER USER
, respectively. For general information, see Handling Session Socket Blocking in the Administrator's Guide.
Table for Auditing External Tables
System table EXTERNAL_TABLE_DETAILS
records information about external tables. You can use this table to audit the amount of ORC and Parquet data you are using, which might be limited by your license.
Table for Monitoring Memory Pool Allocations
System table ALLOCATOR_USAGE
provides information on memory pool allocation and usage for each Vertica node. You can use the information presented in the table to help diagnose memory pool issues.
Table for Monitoring Notifier Errors
The system table NOTIFIER_ERRORS
now provides information on errors encountered by notifiers.