explain taking long time

General
General covers Articles, Reference documentation, FAQs, Downloads and Blogs that do not belong to a specific subject area. General-purpose Articles about everything and anything
Enthusiast

explain taking long time

Hi Team,

 

    There is a table  defined on database A and B. I am able to perform select queries on table created in database A but while execute it on database b, the same query is running for undefined time.

 

   A  explain on simple select * query is running until aborted but doesnt provide results. Is this a DBA activity that needs attention for such a scenario.

 

  eg: Select * from A.employee (Runs in 2 seconds)

        Explain Select * from B.employee (Runs for undefined time)

 

Regards

Parthiban V

4 REPLIES
Highlighted
Junior Contributor

Re: explain taking long time

Strange, seems like retrieving metadata by the optimizer is blocked.

 

Can you run the plain select?

 

 

Enthusiast

Re: explain taking long time

Hi Dieter,

 

   I did a select * from the table

   It is running for very long time 

  Did you mean that as 'plain select'

 

Regards

Parthi

Junior Contributor

Re: explain taking long time

Yes, did it finish?

 

Do you have access to Viewpoint's QueryMonitor to check where it's stuck?

Enthusiast

Re: explain taking long time

No it didnt finish,

 

Unfortunately i dont have viewpoint so i have sropped a mail to DBA also