bad dialog process standstill

[Former Member]

hi

sap gurus

i have installed sap 4.7 sr1 on windows 2003 with 1GB ram

at the intial time when am starting instance all the dialog workprocess are in running state

all are reading table REPOSRC with user sapsys from 000 client action is direct read

plz provide the solution

with regards

shankar

[Former Member]

Hello,

which Oracle database version do you have? Do you know which statement is "slow", you think? Do you know the execution plan of this statement? Are the statistics of this table update? Are there indexes for this tables? Are they used? How big is this table etc....?

As you know, many things (OS, the application, the database, network etc....)can be reasons for the performance problems.

You should give more details about this problem, otherwise nobody can analyse it.

You can have a look at this SAP note or read the section about <b><i>direct path read</i></b> in this note:

<b><u>619188</u></b> - <b><i>FAQ: Oracle Wait Events</i></b>

Best regards

Baran