ORA-03113: end-of-file on communication channel on using V$SQL_PLAN
Hello collegues,
I am trying to make the snapshot of top 10 SQL's with their plans into the static plan table from the library cache using V$ views.
When using V$SQL_PLAN I am getting ORA-03113 error.
According to Google references this was common problem.
Has anybody solve this problem or can see suitable workaround?
I am using this on 9.2.0.8 release.
Let me show the code. I get to ORA-03113 on the second SQL when selecting from the view on v$sql_plan.
create or replace view dynamic_plan_table -- according to Tom Kyte's http://asktom.oracle.com/pls/apex/f?p=100:11:0::NO::P11_QUESTION_ID:230338600346782894
I am trying to make the snapshot of top 10 SQL's with their plans into the static plan table from the library cache using V$ views.
When using V$SQL_PLAN I am getting ORA-03113 error.
According to Google references this was common problem.
Has anybody solve this problem or can see suitable workaround?
I am using this on 9.2.0.8 release.
Let me show the code. I get to ORA-03113 on the second SQL when selecting from the view on v$sql_plan.
create or replace view dynamic_plan_table -- according to Tom Kyte's http://asktom.oracle.com/pls/apex/f?p=100:11:0::NO::P11_QUESTION_ID:230338600346782894
0