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
Member
Hallo,

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,

Greetings,

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


Current Time: Thu Mar 28 16:16:02 CDT 2024