Two example methods of querying the database for this information:
select owner , table_name, index_name from dba_indexes where logging='NO'; select tablespace_name, logging from dba_tablespaces /
Source: LOGGING OR NOLOGGING THAT IS THE QUESTION By Francisco Munoz Alvarez