the database in question is Oracle 10g Enterprise software
the tools available are Toad, SQL Developer, and other built in oracle tools
I have an application server within the network, alongside the database server within the network. I also have a system outside of the firewall.
With my current monitoring tools: SGA monitor within Toad
I can see queries coming from the application server to the database, but I can't see what is being sent to/from the system out of the firewall, which does communicate to the database.
Running a packet sniffer I can see the database communicating with the system outside of the firewall (dmz)
What command would allow me to see all of the queries being made, and how would this be run?