+++++ Version Info ++++++
RDBMS version: 11.2.0.4
OS : RHEL 6.5
Due to performance issue, I need to manually gather statistics for a very large table tonight. The table size is 1.5 TB
Due to other maintenance + Business activities , I only have a 4 hour window to do this task ( 5 AM to 9 AM).
Below is the command I am going to run. If the command doesn't complete by 9AM (start of Business hours) , I need to cancel this gather stats job. Are there any consequences of cancelling the gather stats of a table before it is completed ? This is a very important table for the business.
EXEC DBMS_STATS.GATHER_TABLE_STATS
(
ownname => 'PKMS',
TABNAME => 'PKT_DTL',
cascade => TRUE,
NO_INVALIDATE => FALSE,
ESTIMATE_PERCENT => DBMS_STATS.AUTO_SAMPLE_SIZE,
DEGREE => 20
);
I want all the cursors referring this table to be invalidated , hence using NO_INVALIDATE => FALSE parameter