Files
db_report/sql/15_check_supplemntal_logging.sql
Yacine31 4e7683aee2 mise à jour v2
Grosse mise à jour :
- style moderne des tableaux et code
- code structuré et factorisé
- sql et sh affinés
2025-11-19 15:55:11 +01:00

17 lines
792 B
SQL

prompt <h2>Database supplemental logging :</h2>
select /* db-html-report */ 'force_logging' as property, force_logging as value from v$database
union all
select 'supplemental_log_data_min' as property, supplemental_log_data_min as value from v$database
union all
select 'supplemental_log_data_pk' as property, supplemental_log_data_pk as value from v$database
union all
select 'supplemental_log_data_ui' as property, supplemental_log_data_ui as value from v$database
union all
select 'supplemental_log_data_fk' as property, supplemental_log_data_fk as value from v$database
union all
select 'supplemental_log_data_all' as property, supplemental_log_data_all as value from v$database
union all
select 'supplemental_log_data_pl' as property, supplemental_log_data_pl as value from v$database