Database Administration (MOSC)

MOSC Banner

workarea executions

edited May 8, 2014 8:53AM in Database Administration (MOSC) 4 commentsAnswered ✓

Hi,

in documentation I saw the following :

SELECT name profile, cnt, DECODE(total, 0, 0, ROUND(cnt*100/total)) percentage

  FROM (SELECT name, value cnt, (SUM(value) over ()) total

  FROM V$SYSSTAT

WHERE name

  LIKE 'workarea exec%');

The output of this query might look like the following:

PROFILE                                    CNT PERCENTAGE
----------------------------------- ---------- ----------
workarea executions - optimal             5395         95
workarea executions - onepass              284          5
workarea executions - multipass              0          0

What are the meanings of workarea executions  onepass  and multipass  and optimal  ?

optimal ? Comparing to what ? How is it defined ?

I looked for in all docs , I can not see.

Thank you.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center