Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Unix/Oracle context switching

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US