tag:blogger.com,1999:blog-4924761592080147339.post7452621740105343955..comments2023-09-12T07:08:02.095-07:00Comments on Ric Ramblings: Run time SQL Statistics in Production with SQL Patch Ric Van Dykehttp://www.blogger.com/profile/13372723714711916938noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-4924761592080147339.post-68631966175606856732017-11-21T10:20:08.193-08:002017-11-21T10:20:08.193-08:00This comment has been removed by a blog administrator.Bloggerhttps://www.blogger.com/profile/07287821785570247118noreply@blogger.comtag:blogger.com,1999:blog-4924761592080147339.post-82645676065467874502017-01-03T13:07:47.244-08:002017-01-03T13:07:47.244-08:00Agreed, might be helpful to have that goal explici...Agreed, might be helpful to have that goal explicitly stated in the blog post :)vbarunhttps://www.blogger.com/profile/14748871375863136442noreply@blogger.comtag:blogger.com,1999:blog-4924761592080147339.post-30244360255005183412017-01-03T12:47:03.684-08:002017-01-03T12:47:03.684-08:00First it requires Enterprise Edition and the Diagn...First it requires Enterprise Edition and the Diagnostics and Tuning option, I try to show examples that anyone can use without any "extra" licensing. Second it's easier to use DISPLAY_CURSOR in SQL Plus. Yes you can use the DBMS_SQLTUNE package but you still need to be licensed for it. If you have all that then sure, use it! Ric Van Dykehttps://www.blogger.com/profile/13372723714711916938noreply@blogger.comtag:blogger.com,1999:blog-4924761592080147339.post-22013560518852416542016-12-16T13:25:51.077-08:002016-12-16T13:25:51.077-08:00Hm, why not use sql monitor as it provides more da...Hm, why not use sql monitor as it provides more data than display_cursor and is automatically gathered for queries taking >=5s.vbarunhttps://www.blogger.com/profile/14748871375863136442noreply@blogger.com