1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33
|
Connected to Oracle Database 10g Enterprise Edition Release 10.2.0.4.0
Connected as mni
SQL> select count(*) from emp look_at_me;
COUNT(*)
----------
14
SQL> alter session set current_schema=scott;
Session altered
SQL> select count(*) from emp look_at_me;
COUNT(*)
----------
14
SQL>
SQL> Select t.SQL_ID, t.CHILD_NUMBER, t.EXECUTIONS, t.PARSE_CALLS, t.PARSING_USER_ID, t.PARSING_SCHEMA_ID
2 from v$sql t
3 Where sql_text like '%look_at_me%'
4 and sql_text not like '%v$sql%'
5 /
SQL_ID CHILD_NUMBER EXECUTIONS PARSE_CALLS PARSING_USER_ID PARSING_SCHEMA_ID
------------- ------------ ---------- ----------- --------------- -----------------
69amg80kkjvcs 0 1 1 67 67
69amg80kkjvcs 1 1 1 67 100
SQL> |
Partager