I guess, You cannot monitor by sql query.,,
But you can monitor the activity in the log file., may be u can say
tail -f to get continouls updates.
Also, to find out if the patch is complete or not, you have to rely on logfiles.
You can find the patch completion message at the end of the file.
Also, Next time when you restart the adpatch, It asks you if you want to continue the previous stopped patch....
------------------------------------------------------------------------
The most enjoyable things in the world are either Immoral or too Expensive or otherwise Inaccessible anyway