Any oracle Performance analytical tools in PLSQLD?

[SaKa]

Hi,
Just wondering if there is any performance analytical tools built with PLSQLD please? Is there anything to support oracle Statspack?

I find some elements in sessions, is there any advanced documentation on how to use it please? What does "Enable SQL Trace do? I also get "Table or View doesnot exist" error on "SQL Monitor" tab (oracle 12.1) apparently a grant issue but how do i know which table to grant please?

Thanks
Sak

 

[Marco Kalter]

For performance analysis we have the statistics page of the SQL Window and Test Window, the Profiler and Trace tab pages on the Test Window, and the general SQL Trace option for a session. All these features are described in the User's Guide.

The SQL Monitor tab page of the Sessions tool requires select privileges on the V$SQL_MONITOR view, and execute privileges on the DBMS_SQLTUNE package. In the Sessions tool you can click on the "Define Session Queries" button to view (and edit) the exact SQL statements that are used for each tab page.