Re: Event 'db file seq. read' stuck for hours on the same file#/block# ?

Do you have lots of killed sessions? Have you bounced the db lately? smon topping out your cpu?

(Sometimes killed sessions don't get cleaned up until you bounce. Sometimes they keep locks.)

jg

--
@home.com is bogus.
"Well, I'm just a simian who writes conservative opinions. And there
are plenty of other simians who share my political predilection who can
ably take my place. " - Joseph Perkins, black conservative.