Problems during explain plan

From: Reid Lai <reidlai_at_hk.super.net>
Date: 1997/02/14
Message-ID: <01bc1a30$4f78cb00$0b0a40ca@hk.super.net.hk.super.net>#1/1

Hello world,

Recently, our project team has discovered a problem when we issue explain plan statement at the same time. I know we have a system table SYS.PLAN_TABLE and all result generated by EXPLAIN PLAN will be stored in this table. It works fine when a single developer to do so at a time.

However, this will be a choas when we issue EXPLAIN PLAN statement at the same time. We could see that we cannot know which rows belongs to which user. And also all the result is accumulated when we issue the same statement again. For the time being, we can only delete all the rows in PLAN_TABLE and restrict only one developer to issue EXPLAIN PLAN at a time.

Could anybody help to solve this problem?

-- 
Best Regards,

Reid Lai
mailto://reidlai@hk.super.net
http://www.hk.super.net/~reidlai

Received on Fri Feb 14 1997 - 00:00:00 CST