Search notes:

oradebug direct_access

oradebug help direct_access
DIRECT_ACCESS  <set/enable/disable command | select query> Fixed table access

oradebug direct_access enable trace

oradebug direct_access disable reply

oradebug direct_access set mode = unsafe

oradebug direct_access set content_type = 'text/plain'
oradebug direct_access set content_type = 'text/xml'

Dump the result of query on a fixed table to the trace file.

oradebug direct_access select * from x$bh

See also