Dataguard standby views

View / Table ------------------------------	Purpose / Usage -----------------------------------------------------------------------------------
v$dataguard_stats	Shows Data Guard apply/transport lag statistics.
v$dataguard_status	Displays Data Guard error/status messages.
v$dataguard_config	❌ Not a standard Oracle view (possibly custom).
v$dataguard_process	Shows active Data Guard background processes (RFS, MRP, etc.).
v$bgprocess	Lists all background processes running in the instance.
v$active_instances	Lists active instances in RAC environments.
v$active_services	Shows currently active services in the instance.
v$active_session_history	ASH data; samples active sessions for performance diagnostics.
dba_activity_table	❌ Not standard — likely custom. Use DBA_AUDIT_TRAIL for DML audit.
dba_app_errors	Lists compilation errors for PL/SQL programs.
dba_applications	Lists applications registered (e.g., Workspace Manager).
dba_ddl_locks	Shows schema-level locks (DDL operations).
dba_dml_locks	Displays row-level DML locks (e.g., UPDATE, INSERT).
dba_db_links	Lists all defined DB links and their properties.
dba_db_link_sources	Shows which users/objects use DB links.
dba_dependencies	Shows object dependencies (views, packages, tables).
dba_directories	Lists Oracle Directory objects (for UTL_FILE, Data Pump, etc.).
dba_goldengate_privileges	Lists users with Oracle GoldenGate replication privileges.
v$dbfile	Lists datafiles and status info for current instance.
v$tempfile	Lists tempfiles used by temporary tablespaces.
v$logfile	Lists redo log files and their group/size/status.
dba_data_files	Lists all permanent datafiles and their details.
dba_temp_files	Lists all tempfiles in temp tablespaces.
v$rman_configuration	Displays RMAN configuration parameters (retention, device type).
v$result_cache_objects	Lists cached results; check for cache flushes here.
v$passwordfile_info	Shows info about Oracle password file usage.
v$pdbs	Lists PDBs (Pluggable Databases) in a CDB environment.
v$parameter_valid_values	Lists valid values for init parameters (for validation).
v$obsolete_backup_files	Shows obsolete backups eligible for deletion by RMAN.
v$obsolete_parameter	Lists deprecated/obsolete init parameters.
v$instance_ping	RAC view; shows block ping stats between instances.
v$session_connect_info	Shows connection protocol/service per session.

---------------------------------------------------------------------------------------------------------------