Delete dictionary statistics

[Former Member]

Dear All

When I execute the below command it is hang till running  5/6 hrs. Not completed.

BRCONNECT command to delete dictionary statistics:

OS> brconnect -u / -c -f stats -t oradict_stats -d

Please help.

Thanks,

MS

[former_member218171 · Accepted solution]

Hi,

How big is your database? have you tried the option -p (parallelism)??

-p|-parallel: Defines the number of parallel threads for updating statistics

Input syntax:
-p|-parallel <number>

Default: 1

For example, you can set this parameter to the number of CPUs to speed up update
statistics.

Hope it helps!

Cheers!

[Former Member · Accepted solution]

Hi Cotton,

My database size is 126 GB. I start it with -p 4 but till it hang not completed.

Regards,

MS

[former_member188883 · Accepted solution]

Hi MS,

If you are on Oracle 11g , please update the dbatools to 7.20 or higher and then perform the statistics update.

Hope this helps.

Regards,

Deepak Kori

[Former Member]

Hi MS,

Refere below link.

http://help.sap.com/saphelp_nw73/helpdata/en/46/b9b7c889321826e10000000a1553f6/content.htm

SAP Note: 838725 - Oracle dictionary statistics and system statistics.

Thanks & Regards,

V Srinivasan