What is called as the Virtual Processor in database?

What is called as the Virtual Processor in the database and how is virtual processor different from other processors


2 Answers
1-2 of  2
2 Answers
  • Database server processes are called virtual processors because the way they function is similar to the way that a CPU functions in a computer. Just as a CPU runs multiple operating-system processes to service multiple users, a database server virtual processor runs multiple threads to service multiple SQL client applications. A small number of virtual processors serve a much larger number of client applications or queries.Virtual processors can share processing.Virtual processors save memory and resources.Virtual processors can perform parallel processing.
    0

  • ANS: In Virtual processor approach, there are several virtual processors more than the real number of processor present in the system. In this case, we map tuples and work with the virtual processor instead of real processors. virtual processor are then mapped to real processor
    0

oracle
Practice Mock Test
oracle