I am trying to do some performance tuning on an existing Oracle Report Builder report that exists (rep1.rdf) but the SQL Tracker feature of Toad for Oracle is not returning any results. Any ideas?
This is what I am doing:
I launched Toad for Oracle
In Toad for Oracle, start the Monitoring Tool by selecting Database->Monitor->SQL Tracker
I launched the Oracle Reports Builder and connected and opened the rep1.rdf report
In Toad for Oracle SQL Tracker Tool (window title shows Monitoring Tool for Database Clients), I pressed Refresh button and the clicked on the rwbuilder.exe entry to highlight it. Then I clicked on the Start Monitoring button. “Yes” no appears in the highlighted entry under Monitoring.
5.In the Oracle Reports Builder, i ran the report by pressing the Run Paper Layout button. The report is executed and displayed successfully.
- In Toad for Oracle SQL Tracker Tool, the rwbuilder.exe(pid) window does not display any of the SQL statements that were executed. I cannot seem to be able to capture them and the timings. The tool works successfully with Oracle Forms and Toad itself.
I am running within a VM in Windows 7 environment. The database is 11g and the Oracle Development suite is 10g. The Toad for Oracle version is 12.10. However, i have also tried with previous versions of Toad for Oracle (12.8, 12.9) with the same results.
ORACLE 10g suite
Report Builder 10.1.2.3.0
ORACLE Server Release 10.1.0.5.0
Oracle Procedure Builder 10.1.2.3.0
Oracle ORACLE PL/SQL V10.1.0.5.0 - Production
Oracle CORE 10.1.0.5.0 Production
Oracle Tools Integration Services 10.1.2.0.2
Oracle Tools Common Area 10.1.2.0.2
Oracle Toolkit 2 for Windows 32-bit platforms 10.1.2.0.2
Resource Object Store 10.1.2.0.2
Oracle Help 10.1.2.0.2
Oracle Sqlmgr 10.1.2.3.0
Oracle Query Builder 10.1.2.3.0 - Production
PL/SQL Editor © WinMain Software (www.winmain.com), v1.0 (Production)
Oracle ZRC 10.1.2.3.0
Oracle XML Developers Kit 10.1.0.5.0 - Production
Oracle Virtual Graphics System 10.1.2.0.2
Oracle Image 10.1.2.0.2
Oracle Multimedia Widget 10.1.2.0.2
Oracle Tools GUI Utilities 10.1.2.0.2
Toad for Oracle (32 bit Xpert full version) v. 220.127.116.11
Dell SQL Tracker v. 18.104.22.168
Oracle Database 11g Enterprise Edition Release 22.214.171.124.0 - 64bit Production