Apex performance
Date: Tue, 8 Jul 2014 09:08:19 -0700 (PDT)
Message-ID: <6e295b57-f22d-4138-805f-f208e741c5f1_at_googlegroups.com>
Hi,
Oracle 11.2.0.2 Apex version 4.2
I have a stored procedure that contains a piece of sql that populates a table. The source for the data is a blob, this blob is processed by a function and cast into a table. Like this:
insert /*+APPEND*/ into ecg_chart_cache (session_id,seq,channel_1)
When this procedure is run from sqlplus it works fine. However when run from apex, it does an endless number of direct path reads against the lob segment containing the blob. The function itself simply reads the blob once in its entirety into a plsql variable then processes it, piping the rows back as they are extracted from the blob.
I have compared the v$ses_optimizer_env from both sessions, but cant see any differences.
Does anybody have any other ideas?
Cheers
Ralph
Received on Tue Jul 08 2014 - 18:08:19 CEST
select v_session_id,
seq,
channel_1
from table(get_ecg(p_trace_id => p_trace_id, p_start_seq => 1, p_end_seq => p_chunk_size, p_sample_every => p_sample_every));