Name
prof_enable — Control virtuoso profiling
Synopsis
prof_enable
(
|
in
flag
integer
); |
Description
prof_enable
is used to enable or disable
profiling of execution times, SQL statements and web requests.
Passing flag value 1, enables profiling, causing times of statement
executions, which begin and end while profiling is on, to be
accumulated.
When called with a flag of 0, the accumulation is stopped and results gathered so far are written into file named virtprof.out in the server's working directory. For a description of the file, see section about SQL Execution Profiling in Performance tuning part of Virtuoso documentation.
Parameters
flag
An INTEGER . Valid values are 1 or 0.
Return Types
None.
Errors
No errors are signalled by
prof_enable
Examples
Example 24.247. Simple example
Enable profiling.
SQL> prof_enable(1);