How to allocate the system resources to some of users on the system?

[Former Member]

Gentlemen,

Please advice with the following scenario,

Which I have SAP ECC 6.0 Production System on oracle database with release u201C10.2.0.2.0u201D,

Kernel Patch number: 75

SAP_BASIS 0011

SAP_ABA 0011

PI_BASIS 0011

ST-PI 0006

SAP_BW 0012

SAP_AP 0008

SAP_HR 0009

SAP_APPL 0008

EA-IPPE 0008

EA-APPL 0007

EA-DFPS 0008

EA-HR 0007

EA-FINSERV 0006

FINBASIS 0008

EA-PS 0008

EA-RETAIL 0008

EA-GLTRADE 0008

ECC-DIMP 0007

ERECRUIT 0008

FI-CA 0008

FI-CAX 0008

INSURANCE 0006

IS-CWM 0006

IS-H 0008

IS-M 0008

IS-OIL 0008

IS-PS-CA 0008

IS-UT 0008

SEM-BW 0008

LSOFE 0008

ST-A/PI 0000

My problem that I facing a big problem with system performance with u201CZu201D transaction code and u201CZu201D reports,

Top management of the project requested to allocate the system resources to some of users on the system,

I want to know if this valid to allocate system resources to some users and how to manage it,

Many thanks for your help,

Regards,

Ahmed

[Former Member]

Solved.

Regards,

Ahmed

[markus_doehr2]

> My problem that I facing a big problem with system performance with u201CZu201D transaction code and u201CZu201D reports,

> Top management of the project requested to allocate the system resources to some of users on the system,

Z-programs are self developed programs. You should check with e. g. transaction SE30 where the most time is spent. If it's the database, then one should check if the SQL statement are efficient (no "select * from <tabname>" etc.), maybe a database index will help.

As already said, it's not possible to assign resources to special users. The root cause for long running programs is usually an inefficient SQL statement.

Markus

[stefan_koehler]

Hello Ahmed,

>I want to know if this valid to allocate system resources to some users and how to manage it

Which resources?

If you set memory or time limits, these limits are valid for all users, not only for some specific ones. You can not define different values for different users.

On oracle level you have some other possibilities, but these are anything else than standard and not supported.

Regards

Stefan