Print Thread
Explain Plan table
#36975 01/11/10 04:31 PM
Joined: Apr 2003
Posts: 25
Cleveland, OH, USA
Member
OP Offline
Member
Joined: Apr 2003
Posts: 25
Cleveland, OH, USA
I have been tasked with running Explain Plans in a database where the EXPLAIN_PLAN table resides, but with a different table name (Thanks DBAs! mad). Is there a way I can point the Explain Plan window to a different output table?


Beware of false knowledge; it is more dangerous than ignorance. ~ George Bernard Shaw
Re: Explain Plan table
BJCooperIT #36976 01/12/10 07:47 AM
Joined: Sep 2003
Posts: 27
Sheffield, Yorkshire, England
H
Member
Offline
Member
H
Joined: Sep 2003
Posts: 27
Sheffield, Yorkshire, England
Synonym?

Re: Explain Plan table
hadfieldjohn #37024 01/15/10 06:17 PM
Joined: Apr 2003
Posts: 25
Cleveland, OH, USA
Member
OP Offline
Member
Joined: Apr 2003
Posts: 25
Cleveland, OH, USA
Thanks, John. I would if I had the privileges in that database but, sadly, I am mostly a read-only user and the only table I can insert into is the dba's table dbasch.sqln_explain_plan. Just because they use a different tool than the developers, they think that table is sufficient. Grrr...

What I was hoping for is a preference for the Explain Plan table.


Beware of false knowledge; it is more dangerous than ignorance. ~ George Bernard Shaw
Re: Explain Plan table
BJCooperIT #37028 01/18/10 11:24 AM
Joined: Aug 1999
Posts: 22,219
Member
Offline
Member
Joined: Aug 1999
Posts: 22,219
There is no preference. You will either need a synonym or create a PLAN_TABLE in your own schema.


Marco Kalter
Allround Automations

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.101s Queries: 14 (0.030s) Memory: 2.5119 MB (Peak: 3.0420 MB) Data Comp: Off Server Time: 2024-05-15 15:19:39 UTC
Valid HTML 5 and Valid CSS