Re: Unix/Oracle context switching

From: srivenu <srivenu_at_hotmail.com>
Date: 11 Mar 2004 23:53:42 -0800
Message-ID: <1a68177.0403112353.761f8b@posting.google.com>

> A context switch (ie PL/SQL -> SQL) in Oracle, will result in a context
> switch in Unix.

I dont think this results in a context switch at the OS level as both the SQL and PL/SQL parser are run in user mode only.

>Weren't they merged in 9i?

Since 9i the PL/SQL and SQL engine are using the same SQL parser. But still there is a context switch. That is the reason BULK BINDS are as good in 9i as they are in 8i.

regards
Srivenu Received on Fri Mar 12 2004 - 01:53:42 CST