Question: How do I lock-down my
production tables such that I am the only person who can run
DDL against a production table? How can I use the
"alter table xxx disable table lock syntax?
The following commands are designed to dump the ASH data to a flat file.
This is useful for analyzing transaction waits at a super-detailed level:
SQL>oradebug dump ashdump 10
SQL>alter session set events 'immediate trace name ashdump level 10'