media/image14.png

A single-user batch session is one in which only a single user can connect to a database at a scheduled time, execute a procedure, and disconnect from the database after the procedure runs completely.

There are a number of resource-intensive batch jobs that you may need to perform periodically, such as:

  • Create daily, weekly, or monthly reports.

  • Generate database statistics.

  • Perform large-scale database updates.

  • Update database schema.

In these cases, you should start a database in a single-user batch session.