We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now

How to check table lock using query ?? — Vertica Forum

How to check table lock using query ??

HyeontaeJu

HyeontaeJu Vertica Customer ✭

September 2020 in General Discussion

How to check table lock using query ??

0

Answers

Jim_Knicely

Jim_Knicely - Select Field - Administrator

September 2020

Data Collector tables!

dbadmin=> SELECT DISTINCT table_name, description FROM data_collector WHERE description ilike '% lock%';
    table_name    |                 description
------------------+----------------------------------------------
 dc_lock_requests | History of lock requests
 dc_lock_releases | History of lock releases
 dc_lock_attempts | History of lock attempts (resolved requests)
(3 rows)

https://www.vertica.com/docs/10.0.x/HTML/Content/Authoring/AdministratorsGuide/Monitoring/Vertica/RetainingMonitoringInformation.htm

0

Leave a Comment