Using button "SESSIONS" and violation of "option pack" license for Diagnostic and Tuning

P

Peter93

Member²
Hello,
in blog of Burleson Consulting
http://www.dba-oracle.com/t_dba_features_used_statistics.htm

I found
SELECT on V$ACTIVE_SESSION_HISTORY could cause Licence violation, if you have not Licences some packages.

As an example, if you SELECT from any of the Oracle Diagnostic Pack and Tuning Pack views like V$ACTIVE_SESSION_HISTORY, the database will record your usage of it in this DBA view.
Click to expand...

Could this be also caused by use of PL-SQL developer when showing Sessions?
 
Last edited:
I have seen PLSQL-Developer is using following query:

select m.sql_text, dbms_sqltune.report_sql_monitor(sql_id => m.sql_id, type => 'HTML', report_level => 'ALL') AS report
from v$sql_monitor m
where m.sid = :sid and m.session_serial# = :serial#
order by 1
Click to expand...

Is this a violation of license, because "dbms_sqltune" Tuning package was used?
 
Last edited:
Hello,
First of all v$sessionV$active_session_history
As for the rest you can delete all queries that could cause license violation through editing of session quries (menu item "define session queries")
 
It's a very bad practice of Oracle that it tricks you into using features you haven't licensed and you have to go out of you way to find out what exactly you must NOT use. PSD should stay on the safe side and by default, only enable the features that are legit with the most restrictive licenses of Oracle. Yeah, it becomes even more tricky when it's not PSD per se, but the user who uses these features in SQL. Especially when different connections have different licenses.
 
There may be a misunderstanding:

The queries are part of PL/SQL-Developer!!
When you are using button "SESSIONS" within PL/SQL-Dev, then this querie is done by PL/SQL-Developer and automatically triggers a license violation, when package is not licensed.

@Marco Kalter
I would like to get an answer from Allround Automation!
 
Peter, you are not right. These queries are customizable. See the documentation about a session window
 
Last edited:
@albert: You are right, they are customizable.
But per Default installation of PLSQL-Dev we violate the License agreement with oracle. :-(
 
Peter93 said:
But per Default installation of PLSQL-Dev we violate the License agreement with oracle. :-(
Click to expand...
Could you please specify which Filter / Details using it in Sessions.
thanks
 
Press Button " Define Session Queries" ->
Define Session Queries-> TAB-Details -> SQL Monitor

Then look for "Query":

select m.sql_text, dbms_sqltune.report_sql_monitor(sql_id => m.sql_id, type => 'HTML', report_level => 'ALL') AS report
from v$sql_monitor m
where m.sid = :sid and m.session_serial# = :serial#
 
Confirming it, its there. Not in my installation, cause using heavily modified and not the default.
We being the lucky ones - its licenced, but it would be nice to confirm it from Marco and in case remove it from the default installation.
 
You must log in or register to reply here.
Back
Top