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 * taking a long time

pacoKASAug 16 2011 — edited Aug 17 2011

Hello:

Performing a "SELECT * from my_TABLE" takes a looooong time...

What's the reason?

When you execute that SELECT, the first 50 rows normally appear in a few seconds...

I have ANALYZED the table, rebuilded all its indexes... The problem continues...

The first 50 rows are shown in aprox. 3 minutes!!!!

In another ORACLE environment this SELECT takes only a few seconds (the number of rows is similar)...

Must I analyze another tables?

Any ideas?

My ORACLE version is 10.2.0.4.0

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 14 2011

Added on Aug 16 2011

9 comments

1,216 views