process causing wait events

There is the V$SESSION_WAIT system view that displays the events for which sessions have just completed waiting or are currently waiting. It has the SID that you can lookup in V$SESSION.

References:

V$SESSION_WAIT: https://docs.oracle.com/cd/B19306_01/server.102/b14237/dynviews_2094.htm#REFRN30229
V$SESSION: https://docs.oracle.com/cd/B19306_01/server.102/b14237/dynviews_2088.htm#REFRN30223

This gives details of waits, but I just want to know for which query how much waits, can i get this?

Your awr report should give you that info, can you post the part of the report where you see the wait events?

I want something like, wait events proportion to each query fired. Can I get that?

That I wouldn't know. You can request attention using the button above if you like.

I don't know how to get what you want either.  I've never had to dig into any SQL that deep before.  If you have to tune at the low level wait events and given what a high-end DBA/tuning Expert costs, you could save money by adding hardware!

The deepest level I know about is to  trace the SQL and run tkprof on the output.

If you are licensed for it ADDM and AWR will allow you to drill down pretty deep but not sure if it is to the level you are asking about.

I would open an SR with Oracle Support to see if what you want is possible.

Only wait is for disk IO to complete. It is part of normal DB operation.

>>Only wait is for disk IO to complete.

Incorrect.  There are many.

Please review:
https://docs.oracle.com/cd/B28359_01/server.111/b28320/waitevents.htm

If I run that query against my 11gR2 database I get 1,140 rows returned.  Your systems may vary.