RE: context switching (attempt 2)

From: Ric Van Dyke <ric.van.dyke_at_hotsos.com>
Date: Tue, 29 Oct 2013 11:32:17 -0500
Message-ID: <C970F08BBE1E164AA8063E01502A71CF021C1563_at_WIN02.hotsos.com>



Yes I believe it's a context switch each time.

You can trace it with DBMS_PROFILER and or DBMS_TRACE to see what is happening. In this case DBMS_TRACE will likely show you what you want. TRACE doesn't show timing info but does show all the context switching. You also might want to try DBMS_HPROF, it's good for the subroutine calls, not sure if it really shows the context switching like TRACE does.

You can start here for some info on how to use these packages:

http://docs.oracle.com/cd/B28359_01/appdev.111/b28370/tuning.htm

Ric Van Dyke
Education Director
Hotsos Enterprises, Ltd
Cell 248-705-0624
Hotsos Symposiun March 2-6 2014, Be There.

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Backseat DBA Sent: Tuesday, October 29, 2013 12:21 PM To: oracle-l_at_freelists.org
Subject: context switching (attempt 2)

Say I have a procedure like so with the following calls begin pkg_test.get(1);

pkg_test.insert(1,2,3);

pkg_test.update(1,50);

end;

The 3 procedures, get, insert, and update are straight sql commands. But is it still a context switch from pl/sql to sql inbetween each procedure call? Or does it stay as sql since there isn't any pl/sql in between each procedure call.
Sorry if this a dumb question.

Thanks.

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Tue Oct 29 2013 - 17:32:17 CET

Original text of this message