tag:blogger.com,1999:blog-3890970057024318255.post4682029469304140630..comments2024-03-15T08:36:23.954+03:00Comments on Database Administration Tips: Gathering Fixed Objects StatisticsMahmmoud ADELhttp://www.blogger.com/profile/15299387537990081025noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-3890970057024318255.post-45384723850558023042020-01-05T15:12:43.914+03:002020-01-05T15:12:43.914+03:00Thanks for your comment;
DBA_EXTENTS is querying X...Thanks for your comment;<br />DBA_EXTENTS is querying X$KTFBUE which is not covered by gather_fixed_objects_stats procedure; you have to gather the statistics separately on this table using the following:<br /><br />SQL> EXEC DBMS_STATS.GATHER_TABLE_STATS ('SYS','X$KTFBUE');<br /><br />It's recommended to flush the shared pool to get the new statistics take effect immediately:<br />SQL> ALTER SYSTEM FLUSH SHARED_POOL;<br /><br />I've updated the article with the same.Mahmmoud ADELhttps://www.blogger.com/profile/15299387537990081025noreply@blogger.comtag:blogger.com,1999:blog-3890970057024318255.post-54402838042808938332019-12-30T18:44:40.015+03:002019-12-30T18:44:40.015+03:00I came across your article to gather fixed objects...I came across your article to gather fixed objects stats in order to tune the queries against DBA_EXTENTS without any luck, querying DBA_EXTENTS to check the size of any object no matter it's big or small still takes very long time, gathaering fixed object stats didn't make any improvement! Any idea?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3890970057024318255.post-88527776333895524112014-02-05T21:21:58.187+03:002014-02-05T21:21:58.187+03:00Hello again,
I know a lot of time has passed but I...Hello again,<br />I know a lot of time has passed but I purged the recycle_bin and the queries on fixed objects have run a lot faster.<br />I also tried to gather new statistics on peak hours, as you say on your post. However, I didn't notice any difference, so I imported the old stats back.<br />Thanks! :)Pedrohttps://www.blogger.com/profile/03125597782467751132noreply@blogger.comtag:blogger.com,1999:blog-3890970057024318255.post-28889108128019979712013-07-24T09:46:57.571+03:002013-07-24T09:46:57.571+03:00Gathering fixed objects stats may help, I suggest ...Gathering fixed objects stats may help, I suggest you to do this practice on a test DB first before going production, try first to export the fixed stats on a table, test the performance on the fixed objects, at the end try to import old stats back.<br />Could you please tell me how many object you have in DBA_RECYCLEBIN? <br />select count(*) from dba_recyclebin;<br />Having too many objects in the dba_recyclebin may cause the same scenario you have, specially if your applications are heavily depend on temporary tables. if so I suggest you to purge it unless you need the recycled objects.Mahmmoud ADELhttps://www.blogger.com/profile/15299387537990081025noreply@blogger.comtag:blogger.com,1999:blog-3890970057024318255.post-1552834407699858612013-07-22T08:22:39.490+03:002013-07-22T08:22:39.490+03:00Hi there,
I just read your post regarding the fixe...Hi there,<br />I just read your post regarding the fixed objects statistics gathering.<br />I'd like to ask for your opinion for this:<br />I have a production database running on a 2-node RAC. Both instances are running really slow when joining for example, V$SQL and V$SESSION by SQL_ID.<br />Do you think gathering the statistics on peak hours will improve the performance?<br />Also, if I get bad results, will it be a good idea running dbms_stats.delete_fixed_object_stats? Statistics for fixed objects have never been gathered and the database has been running for 2+ years.<br /><br />Thanks in advance :)Anonymousnoreply@blogger.com