Run the following script to identify objects that are nologging in the currently active config.
This script assumes that the owner of the shareplex tables is splex and there is an active config
-------cut here---------------------------------------------------
column OWNER format a10
column TAB format a15
column ID format 9999999
column LOG format a4
select t.owner OWNER, t.table_name TAB,o.object_id ID ,t.logging LOG from
splex.shareplex_objmap s, dba_tables t, dba_objects o
where s.objid=o.object_id
and t.owner=o.owner
and t.table_name=o.object_name
and o.object_type='TABLE'
and t.logging='NO'
/
----------------------------cut here------------------------------------------------------------------------------
