Session - Monitor Reports Not Showing

[Kevin Seymour]

When I open the sessions window I don't see the new Monitor Reports tab. I understand that Oracle 11.2 is required, but we have database 11.2.0.3 and I have the 11.2 full install on my PC. The only interesting thing I see is that the full 11.2 install comes with OCI 11.1 and I'm wondering if that is the cause?

PL/SQL Developer
Version 11.0.2.1766
02.99270 - Unlimited user license
Service Contract: 2/1/2016
Windows 7 (64-bit) 6.1 Build 7601 (Service Pack 1)

Physical memory : 4,194,304 kB (4,194,304 available)
Paging file : 4,194,304 kB (4,194,304 available)
Virtual memory : 2,097,024 kB (1,802,988 available)

Parameters
C:\Program Files (x86)\PLSQL Developer\plsqldev.exe
NOAUTOLOGON
NOLOADDESKTOP

Preferences
Session mode: Multi
OCI Library:
Use OCI7: False
Allow Multiple Connections: False

Preference Files
C:\Users\********\AppData\Roaming\PLSQL Developer\Preferences\default\Default.ini
C:\Users\********\AppData\Roaming\PLSQL Developer\Preferences\********\default.ini

License File
C:\Program Files (x86)\PLSQL Developer\aalf.dat

Debug file
C:\Program Files (x86)\PLSQL Developer\PlSqlDev.elf

Plug-Ins
Active Query Builder (C:\Program Files (x86)\PLSQL Developer\PlugIns\ActiveQueryBuilder.dll)
*PL/SQL Documentation (plsqldoc) (C:\Program Files (x86)\PLSQL Developer\PlugIns\plsqldoc.dll)
Red Gate Deployment Plug-In (C:\Program Files (x86)\PLSQL Developer\PlugIns\RedGate.dll)
Version Control Interface 1.2 (C:\Program Files (x86)\PLSQL Developer\PlugIns\VCS.dll)
*Wrap demo version 1.0 (C:\Program Files (x86)\PLSQL Developer\PlugIns\wrap.dll)
(* is Active)

Homes
OraDb11g_home1 (C:\app\********\product\11.2.0\dbhome_1)

DLLs
C:\app\********\product\11.2.0\dbhome_1\bin\oci.dll

TNS File
C:\app\********\product\11.2.0\dbhome_1\Network\Admin\tnsnames.ora

Using
Home: OraDb11g_home1
DLL: C:\app\********\product\11.2.0\dbhome_1\bin\oci.dll
OCI: version 11.1
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0

Character Sets
Character size: 1 byte(s)
CharSetID: 31
NCharSetID: 2000
Unicode Support: True
NLS_LANG: AMERICAN_AMERICA.WE8MSWIN1252
NLS_CHARACTERSET: WE8ISO8859P1
NLS_NCHAR_CHARACTERSET: AL16UTF16

Monitors
Id = 0
Primary = True
Handle = 65537
Left = 0
Top = 0
Width = 1366
Height = 768

Id = 1
Primary = False
Handle = 65539
Left = -1440
Top = 0
Width = 1440
Height = 900

Id = 2
Primary = False
Handle = 65604
Left = 1366
Top = 0
Width = 1440
Height = 900

MainFormOnTaskbar = False

 

[tseck]

No - you're wrong.

If you upgraded PLSQLDev to v11 and if you had added some user-queries to the session window, then after upgraded to v11 the new SQL Monitor query is not configured.

You can add the query by yourself or delete the section [SessionQueries] completely from your user.prefs.

I think, adding the Query is more secure. So open the session window and click Define Session Queries. Go to the Details tab and click new. Provide the caption SQL Monitor and set DB Version to 11.2. The Query to enter is

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

That's it. After closing the dialog you should see a new SQL Monitor tab in the session details.

BTW: I've never seen the output of the query, because using dbms_sqltune requires an Oracle Enterprise Edition license plus Real Application Testing option. [The Oracle Personal Edition should also work at no additional cost.]

 

[Kevin Seymour]

That worked perfectly. Thank you. I find it odd behavior that adding a new "feature" would be conditional on any customization I had made.

 

[tseck]

Fine. From a developer view the new feature is the ability to support text and to view its contents in an HTML Window. The new Monitor-Query is just a simple example for this feature.

I think they just forgot to include this to existing user.prefs when upgrading.