We are using version 11.2.0.4 of oracle Exadata.
Suddenly we see many of INSERT and SELECT queries were experiencing wait event "library cache lock" and are not moving ahead. Then tracking back to the session and related sql_id, we found one CREATE table statement which was showing event as "shared Pool Latch" and that was initiated from a third party user and when we killed that session all the waits(library cache lock) disappears. And we were not able to see the full text of the CREATE DDL either from dba_hist_sqltext/gv$sqlarea/gv$sql , but just the initial few words of that like below. So just wanted to understand , logically how the CREATE table can cause the SHARED POOL latch and block many of the other queries? And if there is a way, we can get full text of the DDL statement from the performance history.?
"Create table TEST1 as "