RE: OEM 13c Metric for nologging

I don’t believe there’s a metric to check if logging is disabled at an object level.  There is a configuration collection as to whether it’s in logging or no logging mode, if you are licensed for config/compliance.    You can also write a metric extension to check the objects if you need. 

-- 
- Courtney

http://www.oracle.com/
Courtney Llamas | Consulting Member of Technical Staff
Phone: HYPERLINK "tel:+2814108258"+2814108258 | Mobile: HYPERLINK "tel:+8324720596"+8324720596 
Oracle Strategic Customer Program

Oracle 

http://www.oracle.com/commitment

Oracle is committed to developing practices and products that help protect the environment

 

From: Pete Sharman [mailto:peter.sharman_at_westnet.com.au] 
Sent: Monday, January 15, 2018 3:50 PM
To: rjoralist3_at_society.servebeer.com; oracle-l_at_freelists.org
Subject: RE: OEM 13c Metric for nologging

 

Yup, agreed Rich!

 

Pete

 

From: HYPERLINK "mailto:oracle-l-bounce_at_freelists.org"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: HYPERLINK "mailto:oracle-l_at_freelists.org"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