Which view can be used to obtain a list of instance working threads/auxiliary threads and allow users to determine their running status?
SESSION_STAT
THREAD_WAIT_STATUS
POOLER_STATUS
REPLICATION_STAT
Which system view can be used to obtain the real-time active session list and analyze the activity information of active users in the current system?
SESSION_STAT
SESSION_TIME
SESSION_STAT_ACTIVITY
SESSION_MEMORY_DETAIL
GaussDB provides a Full SQL trace feature. The higher the tracing level, the more information is gathered, and the less the performance overhead.
True
False
Which parameter is used to enable or disable the WDR snapshot function?
wdr_snapshot_interval
wdr_snapshot_retention_days
create_wdr_snapshot
enable_wdr_snapshot
Which of the following situations are suitable for generating a WDR?
A node restarted between two snapshots.
No major system failures or significant changes
A primary/standby switchover was performed between two snapshots.
The dbe_perf.statement view was reset.