Skip to content

Instantly share code, notes, and snippets.

@gregrahn

gregrahn/scott_emp2_cursors.txt

Created February 27, 2012 16:00
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save gregrahn/1924923 to your computer and use it in GitHub Desktop.
Save gregrahn/1924923 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
scott_emp2_cursors.txt
--
-- open EMP2 tab & browse DATA tab, notice there are 2 open cursors, noting the SQL_EXEC_ID numbers
--
PROGRAM SQL_ID SQL_EXEC_ID CURSOR_TYPE SQL_TEXT
------------------------------------ ------------- ----------- --------------- ------------------------------------------------------------
SQL Developer apdcq2s3sxn9y 16777216 OPEN SELECT ROWID "ROWID", ORA_ROWSCN "ORA_ROWSCN", EMPNO EMPNO,
oracle@localhost.localdomain (P000) apdcq2s3sxn9y 16777216 OPEN-RECURSIVE SELECT ROWID "ROWID", ORA_ROWSCN "ORA_ROWSCN", EMPNO EMPNO,
oracle@localhost.localdomain (P001) apdcq2s3sxn9y 16777216 OPEN-RECURSIVE SELECT ROWID "ROWID", ORA_ROWSCN "ORA_ROWSCN", EMPNO EMPNO,
SQL Developer apdcq2s3sxn9y 16777217 OPEN SELECT ROWID "ROWID", ORA_ROWSCN "ORA_ROWSCN", EMPNO EMPNO,
oracle@localhost.localdomain (P002) apdcq2s3sxn9y 16777217 OPEN-RECURSIVE SELECT ROWID "ROWID", ORA_ROWSCN "ORA_ROWSCN", EMPNO EMPNO,
oracle@localhost.localdomain (P003) apdcq2s3sxn9y 16777217 OPEN-RECURSIVE SELECT ROWID "ROWID", ORA_ROWSCN "ORA_ROWSCN", EMPNO EMPNO,
6 rows selected.
--
-- close EMP2 DATA tab
--
PROGRAM SQL_ID SQL_EXEC_ID CURSOR_TYPE SQL_TEXT
------------------------------------ ------------- ----------- --------------- ------------------------------------------------------------
SQL Developer apdcq2s3sxn9y 16777216 OPEN SELECT ROWID "ROWID", ORA_ROWSCN "ORA_ROWSCN", EMPNO EMPNO,
oracle@localhost.localdomain (P000) apdcq2s3sxn9y 16777216 OPEN-RECURSIVE SELECT ROWID "ROWID", ORA_ROWSCN "ORA_ROWSCN", EMPNO EMPNO,
oracle@localhost.localdomain (P001) apdcq2s3sxn9y 16777216 OPEN-RECURSIVE SELECT ROWID "ROWID", ORA_ROWSCN "ORA_ROWSCN", EMPNO EMPNO,
3 rows selected.
--
-- reopen EMP2 tab & browse DATA tab (2nd time)
--
PROGRAM SQL_ID SQL_EXEC_ID CURSOR_TYPE SQL_TEXT
------------------------------------ ------------- ----------- --------------- ------------------------------------------------------------
SQL Developer apdcq2s3sxn9y 16777216 OPEN SELECT ROWID "ROWID", ORA_ROWSCN "ORA_ROWSCN", EMPNO EMPNO,
oracle@localhost.localdomain (P000) apdcq2s3sxn9y 16777216 OPEN-RECURSIVE SELECT ROWID "ROWID", ORA_ROWSCN "ORA_ROWSCN", EMPNO EMPNO,
oracle@localhost.localdomain (P001) apdcq2s3sxn9y 16777216 OPEN-RECURSIVE SELECT ROWID "ROWID", ORA_ROWSCN "ORA_ROWSCN", EMPNO EMPNO,
oracle@localhost.localdomain (P002) apdcq2s3sxn9y 16777218 OPEN-RECURSIVE SELECT ROWID "ROWID", ORA_ROWSCN "ORA_ROWSCN", EMPNO EMPNO,
oracle@localhost.localdomain (P003) apdcq2s3sxn9y 16777218 OPEN-RECURSIVE SELECT ROWID "ROWID", ORA_ROWSCN "ORA_ROWSCN", EMPNO EMPNO,
SQL Developer apdcq2s3sxn9y 16777219 OPEN SELECT ROWID "ROWID", ORA_ROWSCN "ORA_ROWSCN", EMPNO EMPNO,
oracle@localhost.localdomain (P004) apdcq2s3sxn9y 16777219 OPEN-RECURSIVE SELECT ROWID "ROWID", ORA_ROWSCN "ORA_ROWSCN", EMPNO EMPNO,
oracle@localhost.localdomain (P005) apdcq2s3sxn9y 16777219 OPEN-RECURSIVE SELECT ROWID "ROWID", ORA_ROWSCN "ORA_ROWSCN", EMPNO EMPNO,
8 rows selected.
--
-- close EMP2 DATA tab
--
PROGRAM SQL_ID SQL_EXEC_ID CURSOR_TYPE SQL_TEXT
------------------------------------ ------------- ----------- --------------- ------------------------------------------------------------
SQL Developer apdcq2s3sxn9y 16777216 OPEN SELECT ROWID "ROWID", ORA_ROWSCN "ORA_ROWSCN", EMPNO EMPNO,
oracle@localhost.localdomain (P000) apdcq2s3sxn9y 16777216 OPEN-RECURSIVE SELECT ROWID "ROWID", ORA_ROWSCN "ORA_ROWSCN", EMPNO EMPNO,
oracle@localhost.localdomain (P001) apdcq2s3sxn9y 16777216 OPEN-RECURSIVE SELECT ROWID "ROWID", ORA_ROWSCN "ORA_ROWSCN", EMPNO EMPNO,
oracle@localhost.localdomain (P002) apdcq2s3sxn9y 16777218 OPEN-RECURSIVE SELECT ROWID "ROWID", ORA_ROWSCN "ORA_ROWSCN", EMPNO EMPNO,
oracle@localhost.localdomain (P003) apdcq2s3sxn9y 16777218 OPEN-RECURSIVE SELECT ROWID "ROWID", ORA_ROWSCN "ORA_ROWSCN", EMPNO EMPNO,
5 rows selected.
--
-- reopen EMP2 tab & browse DATA tab (3rd time)
--
PROGRAM SQL_ID SQL_EXEC_ID CURSOR_TYPE SQL_TEXT
------------------------------------ ------------- ----------- --------------- ------------------------------------------------------------
SQL Developer apdcq2s3sxn9y 16777216 OPEN SELECT ROWID "ROWID", ORA_ROWSCN "ORA_ROWSCN", EMPNO EMPNO,
oracle@localhost.localdomain (P000) apdcq2s3sxn9y 16777216 OPEN-RECURSIVE SELECT ROWID "ROWID", ORA_ROWSCN "ORA_ROWSCN", EMPNO EMPNO,
oracle@localhost.localdomain (P001) apdcq2s3sxn9y 16777216 OPEN-RECURSIVE SELECT ROWID "ROWID", ORA_ROWSCN "ORA_ROWSCN", EMPNO EMPNO,
oracle@localhost.localdomain (P002) apdcq2s3sxn9y 16777218 OPEN-RECURSIVE SELECT ROWID "ROWID", ORA_ROWSCN "ORA_ROWSCN", EMPNO EMPNO,
oracle@localhost.localdomain (P003) apdcq2s3sxn9y 16777218 OPEN-RECURSIVE SELECT ROWID "ROWID", ORA_ROWSCN "ORA_ROWSCN", EMPNO EMPNO,
oracle@localhost.localdomain (P004) apdcq2s3sxn9y 16777220 OPEN-RECURSIVE SELECT ROWID "ROWID", ORA_ROWSCN "ORA_ROWSCN", EMPNO EMPNO,
oracle@localhost.localdomain (P005) apdcq2s3sxn9y 16777220 OPEN-RECURSIVE SELECT ROWID "ROWID", ORA_ROWSCN "ORA_ROWSCN", EMPNO EMPNO,
SQL Developer apdcq2s3sxn9y 16777221 OPEN SELECT ROWID "ROWID", ORA_ROWSCN "ORA_ROWSCN", EMPNO EMPNO,
oracle@localhost.localdomain (P006) apdcq2s3sxn9y 16777221 OPEN-RECURSIVE SELECT ROWID "ROWID", ORA_ROWSCN "ORA_ROWSCN", EMPNO EMPNO,
oracle@localhost.localdomain (P007) apdcq2s3sxn9y 16777221 OPEN-RECURSIVE SELECT ROWID "ROWID", ORA_ROWSCN "ORA_ROWSCN", EMPNO EMPNO,
10 rows selected.
--
-- close EMP2 DATA tab
--
PROGRAM SQL_ID SQL_EXEC_ID CURSOR_TYPE SQL_TEXT
------------------------------------ ------------- ----------- --------------- ------------------------------------------------------------
SQL Developer apdcq2s3sxn9y 16777216 OPEN SELECT ROWID "ROWID", ORA_ROWSCN "ORA_ROWSCN", EMPNO EMPNO,
oracle@localhost.localdomain (P000) apdcq2s3sxn9y 16777216 OPEN-RECURSIVE SELECT ROWID "ROWID", ORA_ROWSCN "ORA_ROWSCN", EMPNO EMPNO,
oracle@localhost.localdomain (P001) apdcq2s3sxn9y 16777216 OPEN-RECURSIVE SELECT ROWID "ROWID", ORA_ROWSCN "ORA_ROWSCN", EMPNO EMPNO,
oracle@localhost.localdomain (P002) apdcq2s3sxn9y 16777218 OPEN-RECURSIVE SELECT ROWID "ROWID", ORA_ROWSCN "ORA_ROWSCN", EMPNO EMPNO,
oracle@localhost.localdomain (P003) apdcq2s3sxn9y 16777218 OPEN-RECURSIVE SELECT ROWID "ROWID", ORA_ROWSCN "ORA_ROWSCN", EMPNO EMPNO,
oracle@localhost.localdomain (P004) apdcq2s3sxn9y 16777220 OPEN-RECURSIVE SELECT ROWID "ROWID", ORA_ROWSCN "ORA_ROWSCN", EMPNO EMPNO,
oracle@localhost.localdomain (P005) apdcq2s3sxn9y 16777220 OPEN-RECURSIVE SELECT ROWID "ROWID", ORA_ROWSCN "ORA_ROWSCN", EMPNO EMPNO,
7 rows selected.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment