Daily Archives: September 7, 2018

Only basic SQL queries are supported in Database Query Monitor

Sitescope DB query monitor supports only direct SQL queries and not any PL/SQL kind of statements like variable declarations, set, define, conditional blocks etc.

Example:

Good query:
select username from v$session where username like ‘u_name’
Problematic query:
define u_name = ‘APPS’ select username from v$session where username like ‘u_name’; undefine u_name

 

Advertisements