Re: pro*c performance question

> Magnus Lonnroth <mloennro_at_se.oracle.com> writes:
> Put this into your source-code immediately after connecting (only for v6):
>
> exec sql alter session set sql_trace true;
> exec sql alter session set events '10233 trace name context forever';
>
> The first statement opens a trace-file in USER_DUMP_DEST (init.ora) and logs all
> cursor activity. The second statement makes Oracle log information about when and
> how much memory is allocated per cursor. If you have an X-terminal and do this on
> unix, you can debug your program in one window, and run "tail -f tracefile" in
> another. I find this setup very useful.
I just wanted to add that the name of the trace file will vary from system to system. On UNIX in V6, for example, the name has the format <oracle_pid>_<unix_pid>.trc. In Oracle7, the format is <oracle_process_name>_<unix_pid>.trc, while <oracle_process_name> is "pmon", "smon", etc. if the process is a background process. If the process is a dedicated server, the process name is "ora".

Hope this helps.

                                    Rick
                                    Rick Wessman
				    Network Products Division
				    Oracle Corporation
                                    rwessman_at_us.oracle.com