Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 62 Insurance
- 536K On-Premises Infrastructure
- 138.2K Analytics Software
- 38.6K Application Development Software
- 5.7K Cloud Platform
- 109.4K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.2K Integration
- 41.5K Security Software
v$aq total_wait value?

Guys,
Could you please tell me which time value view v$aq uses for columns total_wait and average_wait? Seconds maybe?
Thanks!
Answers
-
i think it should be milli second, you can monitor this view for some time and get idea how this value growing
-
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,
- -
- -
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 --
-
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
-
Ok thank you, i assume then that is a same case for our 11.2 database
-
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.
-
check the below document.
moving this thread to AQ team