LIBRARY CACHE PIN

[ramasineParticipante]

Mais uma informação!

16:58:36 sql’@’bposing > select * from V$session_event
16:58:51 2 where sid = 204;

SID EVENT TOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED AVERAGE_WAIT MAX_WAIT TIME_WAITED_MICRO

---

204 latch free 67 9 14 0 3 144360
204 db file sequential read 4080 0 2666 1 20 26660908
204 db file scattered read 17 0 13 1 2 125422
204 single-task message 3 0 14 5 5 144987
204 SQLNet message to client 4 0 0 0 0 2
204 SQLNet message to dblink 16835 0 1 0 0 12498
204 SQLNet message from client 4 0 0 0 0 1064
204 SQLNet message from dblink 16835 0 11761 1 116 117608196
204 SQL*Net more data from dblink 151 0 0 0 0 2798