RE: open/close cursor question

  • From: "Christian Antognini" <Christian.Antognini@xxxxxxxxxxxx>
  • To: "Guang Mei" <GMei@xxxxxx>
  • Date: Thu, 17 Mar 2005 18:40:17 +0100

Hi Guang

>1. Why did I see the open_cursor jump from 1 to 3 when I just opened =
>cursor, then to 5 when the second cursor opened?

Because each statement count.
1) PL/SQL block
2) SELECT RID from customers
3) select count(*) from v$open_cursor where sid=3D9

>2. Why did I get the same count before and after close the cursor?

Because Oracle automatically caches SQL statements executed in PL/SQL. =
Read "Usage Notes" under =


Other related posts: