v$aq total_wait value?

rootsman

Guys,

Could you please tell me which time value view v$aq uses for columns total_wait and average_wait? Seconds maybe?

Thanks!

Kuljeet Singh - Oracle-Oracle

i think it should be milli second, you can monitor this view for some time and get idea how this value growing

Mark D Powell

rootsman, you would think that Oracle would identify the unit of measure for each column in an RDBMS Dictionary or Dynamic Performance view in the Official documentation for the view, but I can see that Oracle does not, at least in 12.2,

- -

https://docs.oracle.com/en/database/oracle/oracle-database/12.2/refrn/V-AQ.html#GUID-910FEB1D-171D-4EA3-946B-944FBB68B8D…

- -

We do not use AQ so I do not expect to be able to monitor and make a guess but I would expect seconds for total_wait and milliseconds for average_wait.

- -

HTH -- Mark D Powell --

Gaz in Oz

Going all the way back to Oracle 10.2 documentation, it says that both are in seconds:

https://docs.oracle.com/cd/B19306_01/server.102/b14257/aq_views.htm#i1007496

rootsman

Ok thank you, i assume then that is a same case for our 11.2 database

Gaz in Oz

It is possible, but I would do some testing to confirm, or otherwise, that it is indeed seconds.

Perhaps raising an SR with MOS to get the definitive answer from Oracle themselves would also be a good way to go.

PraveenKumarTm-Oracle

check the below document.

https://docs.oracle.com/en/database/oracle/oracle-database/18/refrn/V-AQ.html#GUID-910FEB1D-171D-4EA3-946B-944FBB68B8DA

moving this thread to AQ team