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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s