tag:blogger.com,1999:blog-940885937847335876.post5516428184533624565..comments2024-01-31T15:08:14.203+05:30Comments on One Can Succeed at Almost Anything For Which He Has Enthusiasm...: How to Reduce DB File Sequential Read WaitNEERAJ VISHENhttp://www.blogger.com/profile/04032578930084182369noreply@blogger.comBlogger6125tag:blogger.com,1999:blog-940885937847335876.post-63867407158523724292016-02-04T12:19:44.933+05:302016-02-04T12:19:44.933+05:30The SQL statement associated with this event can b...The SQL statement associated with this event can be obtained using this query:<br /><br />select a.sid, a.serial#, a.username, a.osuser, b.sql_text<br />from v$session a, v$sqltext b<br />where a.sql_hash_value = b.hash_value<br />and a.sql_address = b.address<br />and a.sid in (select sid<br />from v$session_wait<br />where event = ‘db file sequential read’)<br />order by a.sid, b.hash_value, b.piece;Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-940885937847335876.post-9794051245356074362013-06-07T23:03:38.830+05:302013-06-07T23:03:38.830+05:30Yes ...
This is one of the very useful comments...Yes ...<br /><br />This is one of the very useful comments by Tom on his site and i have decided to share with others too. :) :) <br /><br /><br />NEERAJ VISHENhttps://www.blogger.com/profile/04032578930084182369noreply@blogger.comtag:blogger.com,1999:blog-940885937847335876.post-64923863539401709872013-06-07T12:18:23.708+05:302013-06-07T12:18:23.708+05:30this appears to be a post of Ask Tom
this appears to be a post of Ask Tom<br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-940885937847335876.post-72888248604421642422013-02-04T22:23:49.577+05:302013-02-04T22:23:49.577+05:30Thanks.
How can I know the SQL responsible for th...Thanks.<br /><br />How can I know the SQL responsible for the "db seq file read" wait events to tune it?Danannihttps://www.blogger.com/profile/10473394772364127680noreply@blogger.comtag:blogger.com,1999:blog-940885937847335876.post-49508193186235339802013-02-04T22:22:02.728+05:302013-02-04T22:22:02.728+05:30Ok. Thanks.
How can I Know which SQL is making to...Ok. Thanks.<br /><br />How can I Know which SQL is making to grow my "db file seq read" wait event?Danannihttps://www.blogger.com/profile/10473394772364127680noreply@blogger.comtag:blogger.com,1999:blog-940885937847335876.post-39257890078805307862012-10-21T15:22:14.710+05:302012-10-21T15:22:14.710+05:30One of my setup screen in my Oracle Financials App...One of my setup screen in my Oracle Financials Application was running very slow while querying, updatin ,& saving. <br />When i checked the trace file it showing me msg<br /><br />Wait# 45 nam='db file scattered read'<br /><br />how to solve this , can you answer me in detail, your help would be appreciated.<br /><br />thanksUnknownhttps://www.blogger.com/profile/03119345386791467321noreply@blogger.com