tag:blogger.com,1999:blog-20612393.post9090356821038152529..comments2023-09-29T21:26:11.876+07:00Comments on Surachart Opun's Blog: dblink hangs; enq: DX - contentionSurachart Opunhttp://www.blogger.com/profile/05646896104906516714noreply@blogger.comBlogger9125tag:blogger.com,1999:blog-20612393.post-1934390033200274852011-07-27T10:08:37.215+07:002011-07-27T10:08:37.215+07:00yes ..
change logic...
make sure your sql filter...yes .. <br />change logic... <br />make sure your sql filter on remote, not transfer many data to source database and then filter.<br /><br />I mean use hint "DRIVING_SITE"Surachart Opunhttps://www.blogger.com/profile/05646896104906516714noreply@blogger.comtag:blogger.com,1999:blog-20612393.post-28847063896277966442011-07-27T05:03:59.367+07:002011-07-27T05:03:59.367+07:00it is 10.2.0.4
and looks like logic should be chan...it is 10.2.0.4<br />and looks like logic should be changed.<br /><br />Thank yougoryunovhttps://www.blogger.com/profile/06851091789503158667noreply@blogger.comtag:blogger.com,1999:blog-20612393.post-3702769579811139272011-07-26T12:36:06.686+07:002011-07-26T12:36:06.686+07:00what is your Oracle Version?
solved... you may ch...what is your Oracle Version?<br /><br />solved... you may change logic in pl/sql or sql statement.Surachart Opunhttps://www.blogger.com/profile/05646896104906516714noreply@blogger.comtag:blogger.com,1999:blog-20612393.post-69978040943178569462011-07-26T12:06:32.500+07:002011-07-26T12:06:32.500+07:00Hi Surachart,
did you resolve the issue? If so, di...Hi Surachart,<br />did you resolve the issue? If so, did you apply the patch or changed the query? I was trying to find a patch but do not see those numbers on MOS site.<br /><br />Thanks,<br />Andreygoryunovhttps://www.blogger.com/profile/06851091789503158667noreply@blogger.comtag:blogger.com,1999:blog-20612393.post-5319146215543433912009-03-05T17:49:00.000+07:002009-03-05T17:49:00.000+07:00statspack report?Sure... surachart @ gmail dot com...statspack report?<BR/><BR/>Sure... surachart @ gmail dot com<BR/><BR/>Or You can post on forums.oracle.com<BR/><BR/>That's a good way to discuss.Surachart Opunhttps://www.blogger.com/profile/05646896104906516714noreply@blogger.comtag:blogger.com,1999:blog-20612393.post-55966904729969151442009-03-05T16:12:00.000+07:002009-03-05T16:12:00.000+07:00Hello again.May I send you the whole statspack rep...Hello again.<BR/><BR/>May I send you the whole statspack report?<BR/><BR/>Bye,<BR/>Angel.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-20612393.post-75268620728983350262009-03-05T15:22:00.000+07:002009-03-05T15:22:00.000+07:00That was the first thing I thought, but the "inact...That was the first thing I thought, but the "inactive transaction branch" surprised me.<BR/><BR/>I'm going to study your suggestions.<BR/><BR/>Thanks,<BR/>Angel.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-20612393.post-90569436726966486332009-03-05T01:14:00.000+07:002009-03-05T01:14:00.000+07:00i don't think so... you should use Execution P...i don't think so... you should use Execution Plan to check SQL... (Check SQL statements and then Tune SQL Statements.)<BR/><BR/>read metalink:34559.1<BR/><BR/>Or <BR/><BR/>http://surachartopun.com/2008/04/db-file-sequential-read.html<BR/><BR/>Example: use Execution Plan <BR/><BR/>SQL> set autot trace explain<BR/>SQL> select * from xxxx .........<BR/><BR/>Or You can use "oradebug&Surachart Opunhttps://www.blogger.com/profile/05646896104906516714noreply@blogger.comtag:blogger.com,1999:blog-20612393.post-37513088758811248872009-03-05T00:17:00.000+07:002009-03-05T00:17:00.000+07:00So, if I have this in a statspack report: Top 5 Ti...So, if I have this in a statspack report: <BR/><BR/>Top 5 Timed Events<BR/>~~~~~~~~~~~~~~~~~~ % Total<BR/>Event Waits Time (s) Ela Time<BR/>-------------------------------------------- ------------ ----------- --------<BR/>db file sequential read 3,690,752 18,608 Anonymousnoreply@blogger.com