SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Select count(col_name) from Table -> Takes Long time

Jeevanantham VOct 28 2017 — edited Nov 7 2017

Hi,

When i execute this query, it takes long time.

Select count(Ac_no) from CA_ACC_DETAILS -- Account details table, Contains 2000 records.

Actions were taken by me:

1)Verified V$lock table to confirm if there is any lock on table.

2) Explain Plan for select count(ac_no) from table -> This also takes lot of time, not getting completed.

What might be the issue? Where to check if particular query takes lot of time to execute? Is there any other way to resolve these kind of issues?

Please support on this.

This post has been answered by unknown-7404 on Oct 28 2017

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 5 2017

Added on Oct 28 2017

15 comments

2,488 views