Now, in SQL Server it is a very common practice to open a connection to the database for each
concurrent statement you want to execute. If you are going to do five queries, you might well
see five connections in SQL Server. SQL Server was designed that way—much like Windows
was designed for multithreading, not multiprocessing. In Oracle, whether you want to do five
queries or five hundred queries, the maximum number of connections you want to open is
one. Oracle was designed that way. So, what is a common practice in SQL Server is something
that is actively discouraged in Oracle; having multiple connections to the database is something
you just don’t want to do.
Partager