SQL> select * from v$open_cursor where sid=77 order by SADDR desc ;
SADDR SID USER ADDRESS HASH_VALUE SQL_ID SQL_TEXT
-------- ---------- ---- -------- ---------- ------------- ------------------------------------------------------------
7DEE6B94 77 SYS 7DAFD9C4 1471956217 f8pavn1bvsj7t select con#,obj#,rcon#,enabled,nvl(defer,0) from cdef$ where
7DEE6B94 77 SYS 7DA777EC 3150898423 db78fxqxwxt7r select /*+ rule */ bucket, endpoint, col#, epvalue from hist
7DEE6B94 77 SYS 7DB08870 2107929772 a73wbv1yu8x5c select con#,type#,condlength,intcols,robj#,rcon#,match#,refa
7DEE6B94 77 SYS 7DA78A2C 864012087 96g93hntrzjtr select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt,
7DECCADC 77 SYS 7D9846D8 3873422482 0k8522rmdzg4k select privilege# from sysauth$ where (grantee#=:1 or grante
7DECCADC 77 SYS 6C7CC424 2017311249 5ur69atw3vfhj select decode(failover_method, NULL, 0 , 'BASIC', 1, 'PRECON
7DECCADC 77 SYS 72283C70 1950821498 459f3z9u4fb3u select value$ from props$ where name = 'GLOBAL_DB_NAME'
7DECCADC 77 SYS 7D97EF10 2747636884 0h6b2sajwb74n select privilege#,level from sysauth$ connect by grantee#=pr
7DECCADC 77 SYS 6C7D5044 2194907850 0ws7ahf1d78qa select SYS_CONTEXT('USERENV', 'SERVER_HOST'), SYS_CONTEXT('U
7DEBB50C 77 SYS 6C74F8AC 1818756823 g2d01djq6h1qr insert into sys.fga_log$ (sessionid, ntimestamp#, dbuid, os
7DEB8D5C 77 SYS 776B086C 2889265482 awn1qpyq3dcaa SELECT 3 FROM DUAL
7DEB8D5C 77 SYS 6F6C1808 2726364139 dgwysvqj820zb SELECT 4 FROM DUAL
7DEB8D5C 77 SYS 76AAE9E0 32127143 bunvx480ynf57 SELECT 1 FROM DUAL
7DEB8D5C 77 SYS 6B702C68 972030472 5v2mtp0wz00h8 SELECT 2 FROM DUAL
7DEB8D5C 77 SYS 6F66E368 3475517614 f1j53qb7khc5f SELECT 5 FROM DUAL
7DEB8D5C 77 SYS 66D250F0 2013308131 2hs0415w01973 BEGIN test_cursor; END;
