InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
What Is Canceling Sql And Terminating Sessions? |
|
Answer» You can specify the directives to cancel long-running SQL queries or to terminate long-running sessions based on the amount of SYSTEM resources CONSUMED. In other words, you can cancel SQL queries or kill sessions if consumer group MEETS certain criteria. The CRITERION is specified using the SWITCH_TIME and SWITCH_ESTIMATE parameters. The option to CANCEL_SQL or KILL_SESSION can be specified by the SWITCH_GROUP parameter. You can specify the directives to cancel long-running SQL queries or to terminate long-running sessions based on the amount of system resources consumed. In other words, you can cancel SQL queries or kill sessions if consumer group meets certain criteria. The criterion is specified using the SWITCH_TIME and SWITCH_ESTIMATE parameters. The option to CANCEL_SQL or KILL_SESSION can be specified by the SWITCH_GROUP parameter. |
|