View the Exhibit and examine the query based on the DBA_THRESHOLDS view and its partial output :Which observation about
Posted: Sun Jun 11, 2023 3:50 pm
View the Exhibit and examine the query based on the DBA_THRESHOLDS view and its partial output :Which observation about the output is correct?
A. Logons Per Sec triggers an alert when the number of users logging on in an interval of one second is equal to or greater than 100.
B. Blocked User Session Count triggers an alert based on the ELAPSED_TIME_PER_CALL and DB_TIME_WAITING metrics collection per minute.
C. Database Time Spent Waiting(%) triggers an alert when more than 30% of the DB time per second for three consecutive seconds is spent on lock waits.
D. Average Users Waiting Counts triggers an alert when the count is more than 30 for 3 consecutive 1 minute intervals and is related to the log file sync wait event.
- View The Exhibi 1 (47.43 KiB) Viewed 208 times
B. Blocked User Session Count triggers an alert based on the ELAPSED_TIME_PER_CALL and DB_TIME_WAITING metrics collection per minute.
C. Database Time Spent Waiting(%) triggers an alert when more than 30% of the DB time per second for three consecutive seconds is spent on lock waits.
D. Average Users Waiting Counts triggers an alert when the count is more than 30 for 3 consecutive 1 minute intervals and is related to the log file sync wait event.