RE: OEM 13c Metric for nologging
Date: Tue, 16 Jan 2018 08:49:37 +1100
Message-ID: <080f01d38e4a$be26bc10$3a743430$_at_westnet.com.au>
Yup, agreed Rich!
Pete
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Rich J
Sent: Tuesday, January 16, 2018 01:15 AM
To: oracle-l_at_freelists.org
Subject: Re: OEM 13c Metric for nologging
On 2018/01/15 05:02, Nagaraj chk wrote:
In our environment most of the databases have few tables in nologging option. I like to know, do we have any monitoring metric in OEM to monitor the nologging objects or do i need to create any custom metric extension to monitor nologging ? Please suggest.
This doesn't sound like a built-in metric, but it would be the simplest of metric extensions to make with a query of the LOGGING column of the DBA_TABLES view. The real question is, if logging is that important that it needs to be monitored, why isn't force logging used at the database level?
My $.02,
Rich
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Jan 15 2018 - 22:49:37 CET