RE: ADDM Database Time

  • From: "Terrian, Thomas J Mr CTR DLA J6DIB" <Tom.Terrian.ctr@xxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 25 Aug 2010 13:21:40 -0400

Never mind, I found it:  STAT_NAME = 'DB time' in dba_hist_sys_time_model.


-----Original Message-----
From: Terrian, Thomas J Mr CTR DLA J6DIB 
Sent: Wednesday, August 25, 2010 12:46 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: ADDM Database Time

Oracle 10.2, Enterprise:

I need to write a query that returns the "Database Time" that ADDM uses.  I
assume it must be the difference between the second AWR snapshot and the
first.

Does anyone know what the query is for "Database Time"?

Other related posts:

  • » ADDM Database Time- Terrian, Thomas J Mr CTR DLA J6DIB
  • » RE: ADDM Database Time - Terrian, Thomas J Mr CTR DLA J6DIB