My Oracle Support Banner

Automatic Gather Statistics Job For Healthcare Transaction Base (HTB) (Doc ID 1339173.1)

Last updated on DECEMBER 05, 2019

Applies to:

Oracle Healthcare Transaction Base - Version 6.1 and later
Information in this document applies to any platform.

Goal

In Oracle Healthcare Transaction Base (HTB) 6.1 what is the recommended setup for "auto optimizer stats collection" database parameter?

The value for this database parameter can be found with the following statement:
select CLIENT_NAME, STATUS from DBA_AUTOTASK_CLIENT where client_name = 'auto optimizer stats collection';


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.