Performance Issue

[Jens Fudickar]

Hi all,

i have a performance problem with the following code.

PROCEDURE GetDBMSOutputFromSession;
BEGIN
IF OracleSession.Connected THEN
OracleSession.CheckConnection(False);
IF OracleSession.Connected THEN
REPEAT
OracleSession.DBMS_Output.Get_Line(
dbms_output_result,
dbms_output_Status);
IF dbms_output_Status glSuccess THEN
break;
Statement.StatementDBMSOutPut.Add(
dbms_output_result);
UNTIL False;
END;

It's executed 1300 times and takes round about 600 seconds. In this time, i think there is never any line found.

Does anyone see a way to tune it.

The server is normally really fast, only the client is slow.

Greetings and thanks
Jens

------------------

 

[Marco Kalter]

Perhaps you can use the Oracle Monitor to find out which database activity (if any) is the bottleneck?

------------------
Marco Kalter
Allround Automations

 

[Jens Fudickar]

Hi Marco,

thanks for the hint.

I will look for it. )

Greetings
Jens

------------------