My Oracle Support Banner

How to collect Statistics for A Single Partition in OSM (Doc ID 1297022.1)

Last updated on JUNE 11, 2019

Applies to:

Oracle Communications Order and Service Management - Version 6.3 and later
Information in this document applies to any platform.
***Checked for relevance on 02-Oct-2012***

Goal

1.What are all the tables that must be included in the collect statistics for a single partition? Will the following script suffice to collect the stats for a particular partition?


begin
DBMS_STATS.GATHER_TABLE_STATS(ownname=>user, tabname=>'OM_ORDER_INSTANCE', partname=>'P_000000000003100000',estimate_percent=> 10,block_sample=>true,
method_opt=>'FOR ALL INDEXED COLUMNS SIZE AUTO',granularity=>'ALL', degree => 4, cascade =>TRUE);

END;

2.What is the Oracle recommendation? Is it OK to run a collection of statistics only for one newly created partition instead for the the entire schema?

3.How often is a user required to run a collection of  statistics, and which ones must be collected?

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.