Actions after SQLT XTRACT.
Hi...
I'm using a RAC database 10.2.0.4 and I have had some performance issues, I did a SQLT XTRACT of a query and got the next observations.
-
| # | Object
Type | Object Name | Observation |
|---|---|---|---|
| 1 | CURSOR | V$SQL | There exist(s) 3 Child Cursor(s) in memory for this SQL. |
| 2 | SHARED CURSOR | GV$SQL_SHARED_CURSOR | There exist(s) 1 Child Cursor(s) flagged as not shareable because of AUTH_CHECK_MISMATCH. |
| 3 | SHARED CURSOR | GV$SQL_SHARED_CURSOR | There exist(s) 2 Child Cursor(s) flagged as not shareable because of BIND_UACS_DIFF. |
| 4 | SHARED CURSOR | GV$SQL_SHARED_CURSOR | There exist(s) 1 Child Cursor(s) flagged as not shareable because of LANGUAGE_MISMATCH. |
0