Home » RDBMS Server » Server Utilities » Re: Monitoring Selects
Re: Monitoring Selects [message #368059] Wed, 09 February 2000 13:11
Thierry Van der Auwera
Messages: 44
Registered: January 2000

You can monitor the sys.V_$sqlarea view.
This view contains all statements passed to the oracle database. You can make selections like

select sql_text from sys.v_$sqlarea
where parsing_user_id = (select distinct user# from sys.v_$session
where username = 'A_USER_NAME')
AND upper(sql_text) like '%A_TABLE_NAME%'

Hope this helps,


Previous Topic: Re: dump table records to 'insert into xxx values ( ....)' statements ?
Next Topic: Re: Export File Size Limits?
Goto Forum:

Current Time: Fri Feb 03 00:02:20 CST 2023