Why does the DB lock tables
Article ID: 77511
Updated On:
Products
SINGLE SIGN ON - LEGACY
CA Data Protection (DataMinder)
CA User Activity Reporting
Issue/Introduction
Why does the Data Protection data base lock certain tables?
Environment
Release:
Component: DLPSRV
Component: DLPSRV
Resolution
We have a job called DLP_WGN_STATS runs WGN_STATS package which is the main CBO statistics gathering package that is supplied by CA.
The statistics that are gathered by this package are specific to CA Data Protection and do not replace the gathering of system statistics (that is, Workload Statistics for system performance) or the Oracle Data Dictionary statistics.
As part of this, LOCK_STATS procedure unlocks while gathering statistics on all Data Protection tables.
After gathering statistics same procedure locks the statistics of these tables to prevent from analyzing statistics in between.
The statistics that are gathered by this package are specific to CA Data Protection and do not replace the gathering of system statistics (that is, Workload Statistics for system performance) or the Oracle Data Dictionary statistics.
As part of this, LOCK_STATS procedure unlocks while gathering statistics on all Data Protection tables.
After gathering statistics same procedure locks the statistics of these tables to prevent from analyzing statistics in between.
Feedback
Yes
No
Powered by
