Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: WAS3.0 way too slow on linux, help...
Setting Tracing Levels for PL/SQL, Is that of any help ..?
You can get detailed information about what the PL/SQL Cartridge is doing by
increasing the tracing level. You can do this from the Logger Configuration
form. In the form, go to the "System Messages Logging" section, and change
the value in the Severity Level field.
The tracing messages are printed only to the wrb.log file; they are not sent
to the user.
The severity levels range from 0 to 15; low values indicate that only errors are logged, while high values indicate that warnings and informative messages are also logged. For example, if you set the severity level to 8, you can see when the cartridge has performed the authentication and execution operations. The following table describes the severity levels:
Meaning Severity Recommended usage
Fatal errors (for example, memory errors)
0 indicates a core failure or a database error occurred.
Soft errors (for example, non-fatal input/output errors) 1 indicates that writing to file or resource failed.
2 (user-defined)
3 (user-defined)
Warnings (for example, missing file or missing configuration section)
4 indicates a configuration error.
5 (user-defined)
6 (user-defined)
Tracings (for example, request has been executed)
7 indicates the process has entered the init, terminate, or reload stages.
8 indicates the process has entered the authentication and execution
stages.
9 (user-defined)
10 (user-defined)
11 is used for printing debugging variables. Debugging (for example, variable logging)
12 (user-defined)
13 (user-defined)
14 (user-defined)
15 (user-defined) Received on Sat Nov 21 1998 - 16:52:56 CST