SELECT * FROM v$sql_cursor;
CURNO FLAG STATUS PARENT_H PARENT_L CHILD_LO CHILD_PI PERS_HEAP_ WORK_HEAP_ BIND_VARS DEFINE_VAR BIND_MEM_LOC INST_FLAG INST_FLAG2
---------- ---------- --------- -------- -------- -------- -------- ---------- ---------- ---------- ---------- ---------------------------------------------------------------- ---------------------------------------------------------------- ----------------------------------------------------------------
1 78 CURFETCH 04A0E100 03E48C08 03E48DAC 03E49DA4 272 1036 0 14 CGA /BMP/UGA/BHP/WHP/TCA/XRB/SHR /XRB
2 1 CURNULL 00 00 00 00 0 0 0 0
3 1 CURNULL 00 00 00 00 0 0 0 0
4 1 CURNULL 00 00 00 00 0 0 0 0
5 1 CURNULL 00 00 00 00 0 0 0 0
6 1 CURNULL 00 00 00 00 0 0 0 0
7 1 CURNULL 00 00 00 00 0 0 0 0
8 0 CURNULL 00 00 00 00 0 0 0 0
9 0 CURNULL 00 00 00 00 0 0 0 0
10 0 CURNULL 00 00 00 00 0 0 0 0
11 0 CURNULL 00 00 00 00 0 0 0 0
12 0 CURNULL 00 00 00 00 0 0 0 0
13 0 CURNULL 00 00 00 00 0 0 0 0
14 0 CURNULL 00 00 00 00 0 0 0 0
15 0 CURNULL 00 00 00 00 0 0 0 0
16 0 CURNULL 00 00 00 00 0 0 0 0
17 0 CURNULL 00 00 00 00 0 0 0 0
18 0 CURNULL 00 00 00 00 0 0 0 0
19 0 CURNULL 00 00 00 00 0 0 0 0
20 0 CURNULL 00 00 00 00 0 0 0 0
21 0 CURNULL 00 00 00 00 0 0 0 0
22 0 CURNULL 00 00 00 00 0 0 0 0
23 0 CURNULL 00 00 00 00 0 0 0 0
24 0 CURNULL 00 00 00 00 0 0 0 0
25 0 CURNULL 00 00 00 00 0 0 0 0
26 0 CURNULL 00 00 00 00 0 0 0 0
27 0 CURNULL 00 00 00 00 0 0 0 0
28 0 CURNULL 00 00 00 00 0 0 0 0
29 0 CURNULL 00 00 00 00 0 0 0 0
30 0 CURNULL 00 00 00 00 0 0 0 0
31 0 CURNULL 00 00 00 00 0 0 0 0
32 0 CURNULL 00 00 00 00 0 0 0 0
33 0 CURNULL 00 00 00 00 0 0 0 0
34 0 CURNULL 00 00 00 00 0 0 0 0
35 0 CURNULL 00 00 00 00 0 0 0 0
36 0 CURNULL 00 00 00 00 0 0 0 0
37 0 CURNULL 00 00 00 00 0 0 0 0
38 0 CURNULL 00 00 00 00 0 0 0 0
39 0 CURNULL 00 00 00 00 0 0 0 0
40 0 CURNULL 00 00 00 00 0 0 0 0
41 0 CURNULL 00 00 00 00 0 0 0 0
42 0 CURNULL 00 00 00 00 0 0 0 0
43 0 CURNULL 00 00 00 00 0 0 0 0
44 0 CURNULL 00 00 00 00 0 0 0 0
45 0 CURNULL 00 00 00 00 0 0 0 0
46 0 CURNULL 00 00 00 00 0 0 0 0
47 0 CURNULL 00 00 00 00 0 0 0 0
48 0 CURNULL 00 00 00 00 0 0 0 0
49 0 CURNULL 00 00 00 00 0 0 0 0
50 0 CURNULL 00 00 00 00 0 0 0 0