Skip Headers

# Accessing the TopLink Profiler Results

Previous

Next

The simplest way to view TopLink profiler results is to read the TopLink log files with a text editor. For general information about TopLink logging, such as logging file location, see "Logging".

Alternatively, you can use the graphical performance profiler that the TopLink Web client provides. For more information, refer to the Web client online Help and README files.

Example: Performance Profiler Output shows an example of the TopLink profiler output.

Performance Profiler Output

    Begin Profile of{
    ReadAllQuery(oracle.toplink.demos.employee.domain.Employee)
    Profile(ReadAllQuery,# of obj=12, time=1399,sql execute=217, prepare=495, row fetch=390, time/obj=116,obj/sec=8)
    } End Profile

The second line of the profile contains the following information about a query:

- `ReadAllQuery(oracle.toplink.demos.employee.domain.Employee)`: specific query profiled, and its arguments.

- `Profile(ReadAllQuery`: start of the profile and the type of query.

- `# of obj=12`: number of objects involved in the query.

- `time=1399`: total execution time of the query (in milliseconds).

- `sql execute=217`: total time spent preparing the SQL script.

- `prepare=495`: total time spent preparing the SQL script.

- `row fetch=390`: total time spent fetching rows from the database.

- `time/obj=116`: number of milliseconds spent on each object.

- `obj/sec=8) */`: number of objects handled per second.