Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

What happens if you cancel Gather Stats job half way through ?

User_4ZSEXFeb 28 2017 — edited Mar 1 2017

+++++ 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

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 29 2017
Added on Feb 28 2017
8 comments
3,968 views