i'm trying to execute the file sqlplus /nolog @statistics.txt <sapuser> as per the sap note 0001020260 ihow can i find the sapuser

[Former Member]

i'm trying to execute the file sqlplus /nolog @statistics.txt <sapuser> as per the sap note 0001020260 ihow can i find the sapuser

[v_veeramalla]

You can check select * from dba_users , check RB comments about username

  You can also check env variable for the same. dbs_ora_schema

[fidel_vales]

KANNAN VENKATACHALAM wrote:

i'm trying to execute the file sqlplus /nolog @statistics.txt <sapuser> as per the sap note 0001020260 ihow can i find the sapuser

Hi,

here the SAPUSER is the "SAP Schema", the owner of the SAP tables.

if you do noit know who that is then you should NOT be doing that.

[Reagan]

Open the script and read it.

Rem 4. Make sure that the indexes of the relevant tables follow the "~"
Rem    naming convention. Replace <sapuser> with the name of the SAP user
Rem    (SAPR3 / SAPSR3 / SAP<sid> / SAP<xyz>):

Here is what the note says.

Regards

RB

[Former Member]

brconnect -u / -c -f stats -t all -- what it will do exactly ?

[Former Member]

Hi

here it will give you all explanation.

Update Statistics - SAP Database Guide: Oracle (BC-DB-ORA-DBA) - SAP Library

Regards

Dishant

[fidel_vales]

KANNAN VENKATACHALAM wrote:

brconnect -u / -c -f stats -t all -- what it will do exactly ?

Would you mind to read the BR*Tools documentation?

it is located on the oracle community (same place as this forum) it is quite a big document.

AFTER you have read it, if you have any problem understanding what that command does exactly you are welcome to ask again

[Former Member]

Hi

sapuser get created at time of installation

and it is a default user that is responsible to start Sap services on server. including db connection.

so you better ask basis person who has done the installation and having default sapuser;

Regards

Dishant

[fidel_vales]

I'm sorry, but you are far from the correct answer.

SAP Services are windows specific, I do not see anything on the question about windows.

you are talking about the SAP "OS" user and has nothing to do with the question from the OP related to a script  execution on Oracle SQL*PLUS