DBMS_WORKLOAD_REPOSITORY.CREATE_BASELINE

[Former Member]

Hi,

Is it allowed to create baselines in the Oracle databases using sqlplus?

I'd like to use some baselines when I run the awrddrpt -report (sap note 853576).I can't find anything about creating baselines on Oracle databases from SAP-notes.

Regards,

TL

[fidel_vales]

Hello Thomas,

AFAIK, that option currently is not "implemented" in DBACockpit.

That means that you have to use sqlplus

and you are correct, it is not documented in a SAP note, you have to use the Oracle documentation.

[stefan_koehler]

Hello Thomas,

yes you can create baselines. Baselines are a part of the AWR and this is licensed with the "Diagnostic Pack".

This option is licsensed by SAP. Take a look at sapnote #740897 for more information.

For the options, that are included in the "Diagnostic Pack" - take a look at here:

http://www.dba-oracle.com/oracle_news/2005_3_10_get_licenses_10g_awr_addm.htm

Regards

Stefan