Quote Originally Posted by malay_biswal
You can find the PID and then use truss to see what it's doing in O/S level. BTW truss works on sun solaris.
and hw is that going to tell you whether it is parsing a query or not (it wont)

the answer is you cant really

parsing is only a miniscule time anyway so you will either be executing or fetching