Under what circumstances does a select query not appear in the V$SQL view?
One situation is on a Real Application Cluster (RAC). In such environments, V$SQL will only contain the library cache of the current node. To see the library cache across all nodes, select from GV$SQL.