Oracle Database monitoring operations

Operations on the Oracle monitoring database 1. Check SQL _idselect a from the view gv $ session. SQL _id from gv $ session a where. USERNAME = 'dbrwdadm '---- the database user performing the operation and. OSUSER = 'L. jqiao-pc' ---- system user, generally your computer name and. SQL _id is not null; www.2cto.com 2. query the specific operation select sysdate as rrectime, B from gv $ sqlarea Based on the queried SQL _id. * from gv $ sqlarea B where B. SQL _id = 'a. SQL _id '; -- you can also query the results from v $ session and v $ sqlzrea, v _ $ session, and v _ $ session.