harshal： long running query
Hi

How to check the long running query ... time remaining to execute?
.......

R.Wang： Two ways to do
It's real a quite big question and I'm trying to answer it in short.

Basically, when we talk about tuning long running query, I'll follow two ways below.

• Explain Plan (see AskTome posting here) If I were you, I'll keep my eyes on any unreasonable Full Table Scan, or extreme high cost)
• Generate Statspack report (see OraclePoint post here for detail) You may need to pay attention to Hit Ratio and Top Five Wait Event. Some sql statement tuning is eventually caused by system resource limitation, not code writting of sql statement.

If you have oracle metalink account, why don't you read the articles listed at this posting. .......

whiterock： Can\'t predict the period of executing
I don't think there is a way to predict the remaining period of executing.

If you are asking the way to tune update statement, R.Wang's answer is my answer also.