Evo deo iz priručnika
Citat:
Collecting Profile Data
To collect profile data from your PL/SQL program for the PL/SQL hierarchical profiler, follow these steps:
1. Ensure that you have the following privileges:
* EXECUTE privilege on the DBMS_HPROF package
* WRITE privilege on the directory that you specify when you call DBMS_HPROF.START_PROFILING
2. Use the DBMS_HPROF.START_PROFILING PL/SQL API to start hierarchical profiler data collection in a session.
3. Run your PL/SQL program long enough to get adequate code coverage.
To get the most accurate measurements of elapsed time, avoid unrelated activity on the system on which your PL/SQL program is running.
4. Use the DBMS_HPROF.STOP_PROFILING PL/SQL API to stop hierarchical profiler data collection.
For more information about DBMS_HPROF.START_PROFILING and DBMS_HPROF.STOP_PROFILING, see Oracle Database PL/SQL Packages and Types Reference.
Dakle, profiling podaci se upisuju u fajl, ne u tabele.
Kako doci do podatka koliko se puta u bazi neka procedura poziva (izvrsava)
