RE: context switching (attempt 2)
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