tag:blogger.com,1999:blog-20612393.post6245209039940128147..comments2023-09-29T21:26:11.876+07:00Comments on Surachart Opun's Blog: Just learn more from V$LOCKSurachart Opunhttp://www.blogger.com/profile/05646896104906516714noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-20612393.post-38399260438825960392012-04-19T12:24:31.349+07:002012-04-19T12:24:31.349+07:00Check execution plan :)
It's changed after exe...Check execution plan :)<br />It's changed after executed dbms_stats.GATHER_FIXED_OBJECTS_STATS<br /><br />SQL> exec dbms_stats.GATHER_FIXED_OBJECTS_STATS<br /><br />PL/SQL procedure successfully completed.<br /><br />Elapsed: 00:01:35.72<br /><br />SQL> explain plan for select * from v$lock;<br /><br />Explained.<br /><br />Elapsed: 00:00:00.01<br />SQL> select * from table(Surachart Opunhttps://www.blogger.com/profile/05646896104906516714noreply@blogger.comtag:blogger.com,1999:blog-20612393.post-72913113016955421922012-04-19T12:11:47.104+07:002012-04-19T12:11:47.104+07:00I found out on Oracle support.
Query Against v$l...I found out on Oracle support. <br /><br />Query Against v$lock Run from OEM Performs Slowly [ID 1328789.1]<br /><br />They talk about solution by using "dbms_stats.GATHER_FIXED_OBJECTS_STATS"<br /><br />SQL> select count(*) from v$lock;<br /><br /> COUNT(*)<br />----------<br /> 45<br /><br />1 row selected.<br /><br />Elapsed: 00:00:00.30<br />SQL> exec Surachart Opunhttps://www.blogger.com/profile/05646896104906516714noreply@blogger.comtag:blogger.com,1999:blog-20612393.post-53091173072049843222011-08-21T19:52:37.562+07:002011-08-21T19:52:37.562+07:00thank you for your comment.
don't just say it...thank you for your comment.<br /><br />don't just say it's slowly - <br /><br />In the real world, when someone saw the issue... example: sql got slow or ... <br />they have never tested why it slow... or what is happened?<br /><br />So, I mean we should test it or find out more ...Surachart Opunhttps://www.blogger.com/profile/05646896104906516714noreply@blogger.comtag:blogger.com,1999:blog-20612393.post-11441689183372105942011-08-21T19:27:07.282+07:002011-08-21T19:27:07.282+07:00Hi
This is the very interesting study on v$lock. ...Hi<br /><br />This is the very interesting study on v$lock. How you said, "don´t just say it´s slowly" is need prove.<br /><br />For me is work very good, using the ORDERED hint.<br /><br />Thanks<br /><br />Flávio Soares<br />From BrazilFlávio Soareshttp://www.flaviosoares.comnoreply@blogger.com