# Toad plan table issue

**URL:** <https://forums.toadworld.com/t/toad-plan-table-issue/48882>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [January 30, 2020, 12:24pm UTC](https://forums.toadworld.com/t/toad-plan-table-issue/48882 "2020-01-30T12:24:53Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![raul.kaubi](https://avatars.discourse-cdn.com/v4/letter/r/d26b3c/32.png) [@raul.kaubi](https://forums.toadworld.com/u/raul.kaubi)\
**Post date:** [January 30, 2020, 12:24pm UTC](https://forums.toadworld.com/t/toad-plan-table-issue/48882/1 "2020-01-30T12:24:53Z")

</div>

Toad 13.2.0.258

I have logged in with user SYSTEM.

I am trying to explain plan on table, that is another schema.  
I have opened editor window, and set schema as AETADMIN.

I am trying to explain plan on that very schema.

I place my cursor on top of this statement and press ctrl+e:

`select * from aetadmin.view_osaliste_nimed where dokument_id=281;`

And I get nothing.

If I spool this to screen, and repeat this process, I get this:

```
----------------------------------
-- Session: SYSTEM@(DESCRIPTION=(ADDRESS=(PORT=1521)(HOST=XXXXXXXXXXXXX)(PROTOCOL=TCP))(CONNECT_DATA=(SERVICE_NAME=YYYYYY)))
-- Timestamp: 14:20:05.820
ALTER SESSION SET current_schema = AETADMIN;

----------------------------------
-- Session: SYSTEM@(DESCRIPTION=(ADDRESS=(PORT=1521)(HOST=XXXXXXXXXXXXX)(PROTOCOL=TCP))(CONNECT_DATA=(SERVICE_NAME=YYYYYY)))
-- Timestamp: 14:20:05.820
explain plan set statement_id='raulk2:013020142005' into TOAD_PLAN_TABLE For
select * from aetadmin.view_osaliste_nimed where dokument_id=281;

----------------------------------
-- Session: SYSTEM@(DESCRIPTION=(ADDRESS=(PORT=1521)(HOST=XXXXXXXXXXXXX)(PROTOCOL=TCP))(CONNECT_DATA=(SERVICE_NAME=YYYYYY)))
-- Timestamp: 14:20:05.851
ALTER SESSION SET current_schema = SYSTEM;

----------------------------------
-- Session: SYSTEM@(DESCRIPTION=(ADDRESS=(PORT=1521)(HOST=XXXXXXXXXXXXX)(PROTOCOL=TCP))(CONNECT_DATA=(SERVICE_NAME=YYYYYY)))
-- Timestamp: 14:20:05.851
Select *
From TOAD_PLAN_TABLE
Where statement_id = :STATEMENT_ID
order by id;
:STATEMENT_ID(VARCHAR[19],IN)='raulk2:013020142005'

```

You can see that, it will insert output into AETADMIN.TOAD\_PLAN\_TABLE  
And then change schema, and query this plan from SYSTEM.TOAD\_PLAN\_TABLE

Raul

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [January 30, 2020, 2:38pm UTC](https://forums.toadworld.com/t/toad-plan-table-issue/48882/2 "2020-01-30T14:38:07Z")

</div>

I agree, that the "ALTER SESSION SET current\_schema = SYSTEM" should come last...but....

Do you have a TOAD\_PLAN\_TABLE in each schema?  
Why not create one TOAD\_PLAN\_TABLE with a public synonym?  
That would make this problem go away.

I've logged this bug and it will be fixed soon.

---

<div class="post-metadata">

**Author:** ![raul.kaubi](https://avatars.discourse-cdn.com/v4/letter/r/d26b3c/32.png) [@raul.kaubi](https://forums.toadworld.com/u/raul.kaubi)\
**Post date:** [April 29, 2020, 8:08pm UTC](https://forums.toadworld.com/t/toad-plan-table-issue/48882/3 "2020-04-29T20:08:36Z")

</div>

> [@JohnDorlon](#):
>
> Do you have a TOAD\_PLAN\_TABLE in each schema?  
> Why not create one TOAD\_PLAN\_TABLE with a public synonym?

I've no control over what developers do on their environments. I've come to conclude, that in some environments, each developer has its in their own schema.  
This synonym seems like a good idea yeah.

> [@](#):
>
> I've logged this bug and it will be fixed soon.

Thanks.

Raul

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [April 29, 2020, 8:26pm UTC](https://forums.toadworld.com/t/toad-plan-table-issue/48882/4 "2020-04-29T20:26:02Z")

</div>

It's been fixed like the others.

---

<div class="post-metadata">

**Author:** ![raul.kaubi](https://avatars.discourse-cdn.com/v4/letter/r/d26b3c/32.png) [@raul.kaubi](https://forums.toadworld.com/u/raul.kaubi)\
**Post date:** [April 29, 2020, 9:12pm UTC](https://forums.toadworld.com/t/toad-plan-table-issue/48882/5 "2020-04-29T21:12:53Z")

</div>

Thanks, knowing its fixed, is good enough for me.  
Thanks.

Raul