Force to create an explain plan even if a public QUEST_SL_EXPLAIN exist.

SQL Optimizer SQL Optimizer for Oracle
1

Hi

We are using the last version of sqlOptimiser for Oracle(8.5.0.2033)

Our database is 10g and the dba create a public QUEST_SL_EXPLAIN1 table.

The general option has been modified to force the use of this public table.

Unfortunately, when I run the sqloptimizer, the software is asking to create the table in my schema even ig the public table exist.

Note: I'm in a trial period. We have the previous version but currently, we are testing this tool for be part of our Oracle developer team.

Any clue of why sqloptimizer to force to have this table create on my schema?

Thank you

quest_plan_table_issue.jpeg
quest_plan_table_issue.jpeg687×520 146 KB

2

Hi,

Would you please run the following SQL “select owner, object_name, object_type from all_objects where object_name like ‘QUEST_SL_%’” in your database 10g and then give me the result?

Thanks,
Cliff

3

Hi cchan

Here the result

OWNER OBJECT_NAME OBJECT_TYPE

PUBLIC QUEST_SL_EXPLAIN1 SYNONYM
SYSTEM QUEST_SL_TEMP_EXPLAIN1 TABLE
OPS$SUPERMAN QUEST_SL_EXPLAIN1 TABLE

Message was edited by: RegisL

4

Hi,

Please try explain plan in SQL Plus with the same connection identities and see if you are able to get plan. If not success, try grant Select On the table at the back of the synonym ‘Quest_SL_Explain1’ and get plan again.

Thanks,
Cliff