[ owner @ 13.01.2011. 11:32 ] @
Pozdrav,

trebao bih doci do podataka koliko se puta, koliko cesto, neka procedura u bazi poziva, koliko traje njeno izvrsenje i koje procedure ili funkcije ta procedura prilikom izvrsavanja jos poziva.

Unapred se zahvaljujem
[ djoka_l @ 14.01.2011. 11:13 ] @
U principu, tebi treba profiler.
Kako se koristi Oracle profiler možeš da pročitaš u priručniku "Oracle® Database Advanced Application Developer's Guide". Najčešće, profiler se ne koristi direktno, već alat kojim radiš razvoj PL/SQL koda (TOAD, PL/SQL Developer itd.) već ima mogućnosti da se prikažu informacije koje bi dobio, na manje pregledan način, dirktnom upotrebom Oracle PL/SQL profilera.
[ owner @ 14.01.2011. 12:50 ] @
@djoka_I, hvala ti na odgovoru.

Znaci ne postoji neki fiksni View ili tabela iz koje se mogu dobiti te informacije??

[ djoka_l @ 14.01.2011. 12:59 ] @
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.