S
S
Sasha2017-10-27 15:55:28
macOS
Sasha, 2017-10-27 15:55:28

Is there a good PL SQL profiler for Oracle queries on Mac OS?

We rummaged through all sorts of DBMS for Mac OS
- Aqua Data Studio
- dBeaver
- RazorSQL
- DataGrip
- TOAD for Mac

, and none of them has a suitable query profiler ... More precisely, not only suitable, but not at all.

On Windows, there is a great profiler in PL SQL Developer that works out of the box.
Here is an example of the result of the PL SQL Developer profiler
59f32becc1d68759924432.jpeg
. You do not need to write any additional lines like

DBMS_profiler.start_profiler()
<my script>
DBMS_profiler.stop_profiler()


Also on TOAD under Win there are allegedly DBMS and Heirarchical profilers that require dances for configuration and SYS access (concerns the hierarchical profiler). And the DBMS profiler from TOAD under Win does not work correctly, showing zero results.
It is clear that you can use Windows PL SQL Developer on Mac OS.
But, damn it, is it really on Mac OS, a system for developers, that there are still no DBMS clients that allow you to do query profiling under Oracle?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
S
Sasha, 2018-01-04
@lipasite

Nothing better than TOAD for Win has yet been invented for Mac OS.
The best profiler from PL/SQL Developer.
I found a solution - Crossover - just allows you to run Win applications on Mac OS.
1. Install Crossover
2. Create a "bottle" (bottle) - a virtual container for running Win-applications, select "Unknown application",
3. Feed the Oracle 32-bit client installer EXE, install.
4. Select the newly created "bottle" and install the "unknown application" by selecting the EXE of the TOAD installer.
5. Now TOAD sees the Oracle Client and works without problems (since they are installed together in the same container).
Similarly, PL/SQL Developer can be installed.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question