Using which object-level parameters will help limit query processing and concurrency slowdowns? (Choose two.)
Using which object-level parameters will help limit query processing and concurrency slowdowns? (Choose two.)
STATEMENT_TIMEOUT_IN_SECONDS: This parameter sets a limit on the execution time for a SQL statement. If a statement runs longer than the specified time (in seconds), the system automatically aborts it. This helps prevent long-running queries from monopolizing resources and slowing down other processes. STATEMENT_QUEUED_TIMEOUT_IN_SECONDS: This parameter controls how long a statement will wait in a queue before it's canceled. When there's high concurrency, queries might be queued before they can be executed. Setting a timeout prevents statements from staying in the queue indefinitely, freeing up resources and preventing potential deadlocks.