perfstat user in 4.6C/oracle9i

[Former Member]

Dear all,

We found that there is a oracle user perfstat in our 4.6C/oracle9i/solaris landscape.

But in our hpux system where we have installed installed 4.6C/oracle10g, we could not find the user perfstat.

Can you please explain

1.what is the use of perfstat user in oracle?

2. why it is not available in oracle 10g/sap4.6c?

3. Do we need to recreate the same user manually in oracle10g/sap4.6C?

Pl clarify

Thanks

Senthil

[stefan_koehler · Accepted solution]

Hello Senthil,

the PERFSTAT user is normally added, if you install STATSPACK on oracle. This is a package for Oracle 9i (and as well as for Oracle 10g, if you don't have the Oracle Database Diagnostic Pack).

STATSPACK is used to take performance snapshots on oracle databases to analyze load situations / performance issues.

If you install SAP on Oracle 10g you automatically have the "Oracle Database Diagnostic Pack" and you can use the AWR instead of the STATSPACK - so no STATSPACK is needed (and no PERFSTAT user is installed).

So you don't need to add this user manually.

For more information about STATSPACK - take a look at sapnote #717484

Regards

Stefan

[fidel_vales · Accepted solution]

Hi,

One sidenote or clarification to what Stefan mentioned.

AWR is an extra Oracle option that requires an extra licence to be used.

If you have adquired Oracle via SAP, the licence is included.

If you have not adquired it via SAP but directly to Oracle, you need to get in tocuh wuth them in order to adquire the require licence to use AWR.