Authorization for Administation ofr oracle for SAP

[Former Member]

Hi,

I want to know the transactions & authorizations required to administrate the oracle from SAP frontend.

It is very helpful for me if anyone give me link or tell me from where I can start?

Regards,

Rajesh

[former_member204746 · Accepted solution]

you cannot manage much from SAP frontend, you need OS access to sqlplus and to brtools.

[Former Member]

Rajesh,

Indeed, you can do very little from the SAP gui as far as administration is concerned. However, you can get useful information on the database status

db02 : Tablespace sizes, history, critical objects, missing indexes

db03: Oracle parameters

db12: Backup logs

db13: Other database administration job logs and scheduling

db17: Configure what is being checked during jobs like database checks

db20: Influence how stats are calculated

st04: Memory information on the database

I hope this helps

Andreas