Hello all,
Thanks to Bjorn Engsig of MiracleAS.dk
Also,
Here is the answer from Oracle support. I wanted to share with you:
# Begin
tkprof substracts the child statistics from parent ones.
.
the trace file is missing the line for PARSE call of the blsql block
- as it's missing
it's imposs
Hello Mogens,
I saw this problem whether or not shared pool was flushed for PL/SQLs.
Here are my observations for SQLs!!!
and PL/SQLs:
- Enabling sql trace from current session:
When a cursor is closed after their child recursive statements, their
recursive statistics parsed after the statement a
Danisment - isn't it always "alter system flush shard_pool"? I thought so...
Danisment Gazi Unal (Unal Bilisim) wrote:
>Hello,
>
>I did 2 tests for PL/SQL and SQL statements. This is the test for
>SQL.
>
>Here are the steps:
>
>SQL > alter session flush shared_pool;
>SQL > alter session set sql_
Hello,
I did 2 tests for PL/SQL and SQL statements. This is the test for
SQL.
Here are the steps:
SQL > alter session flush shared_pool;
SQL > alter session set sql_trace=true;
SQL > insert into test select * from test;
SQL > alter session set sql_trace=false;
FROM DICTIONARY:
SVRMGR> select