Skip to Main Content
Forums

Oracle Database Discussions

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(*) VERY slow!

movilogoMay 16 2009 — edited May 17 2009
The table has only 8 columns and 5 way partitioned.

It was fine till it had 550 million rows [Oracle 11g + Windows XP Pro]. Select count(*) from table used to take ~ 500 seconds.

When records count reached 600 million, suddenly looks like database hit a brick wall. Now even select count(*) runs for whopping 2800 seconds!!

What went wrong by just adding 50 million extra records??

Thanx.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 14 2009
Added on May 16 2009
#general-database-discussions
20 comments
15,761 views