Hi all,

Are there any other settings possible other then ORAPROF=0? Thanks in advance for your posts.

:confused:

Kind regards,

Marc

Yes,
ORAPROF or INFPROF can be set a higher value too.
It is the treshold limit in seconds for logging.

ORAPROF=1.0
all database actions taking longer than 1.0 seconds are logged, others are not logged.

Thanks Ome Luuk. This will make the tracefile a lot smaller, I guess.

Is there a possibility to trace the Bisam database in a "*PROF"-manner? We use SupportEye to analyze the tracefile and would like to use this product on a Bisam database also.

Kind regards,

Marc

There are different similar ways:
-- -set TT_SQL_TRACE=020200
will time queries and tell if Full Table Scans are done;
compiling sessions in profile mode will show how long certain functions take to complete. (compile flag: add option "-p").