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!

how full table scan works

3013446Jan 8 2016 — edited Jan 10 2016

Hi All,

I have a table which is accesed by application every 5 seconds.Now this table has multiple delete insert updates going on.The size of the table is aprox 200MB (high water mark) and there are say 5 rows which will be hardly 20 to 30 KB. My SGA is say 2 GB. So now the stats are not gathered and there is no index in this table. Now i can see full table scan as its wait event. Now i want to know.

how a full tabel scan happens does Oracle load the entire 200MB of data into SGA and then do a table scan or it just takes the actual size used by the table i.e 20-30KB.

Thanks,

This post has been answered by BrunoVroman on Jan 8 2016

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 7 2016

Added on Jan 8 2016

#general-database-discussions

10 comments

1,028 views