Primero puede comprobar el Periodo de Retenci\u00f3n AWR en Oracle con esto<\/p>\n\n\n
\nset lines 200\ncol SNAP_INTERVAL format a20\ncol RETENTION format a20\ncol SRC_DBNAME format a20\n\nselect * from dba_hist_wr_control;\n\n DBID SNAP_INTERVAL RETENTION TOPNSQL CON_ID SRC_DBID SRC_DBNAME\n---------- -------------------- -------------------- ---------- ---------- ---------- --------------------\n3847XX0535 +00000 01:00:00.0 +00008 00:00:00.0 DEFAULT 0 3847XX0535\n<\/pre><\/div>\n\n\nPuede ver que el intervalo es cada hora y la retenci\u00f3n es de s\u00f3lo 8 d\u00edas.<\/p>\n\n\n\n
Puede cambiar la retenci\u00f3n a 30 d\u00edas con esto (30*24*60)<\/p>\n\n\n
\nexecute dbms_workload_repository.modify_snapshot_settings(retention => 43200);\n<\/pre><\/div>\n\n\nSi tambi\u00e9n quieres cambiar el SNAP_INTERVAL, puedes cambiarlo as\u00ed para tomar snaps cada 30 mins<\/p>\n\n\n
\nexecute dbms_workload_repository.modify_snapshot_settings(interval => 30);\n<\/pre><\/div>\n\n\n<\/p>","protected":false},"excerpt":{"rendered":"
Primero puede comprobar el Periodo de Retenci\u00f3n AWR en Oracle con esto Puede ver que el intervalo es cada hora y la retenci\u00f3n es de s\u00f3lo 8 d\u00edas. Puede cambiar la retenci\u00f3n a 30 d\u00edas con esto (30*24*60) Si tambi\u00e9n quiere cambiar el SNAP_INTERVAL, puede cambiarlo as\u00ed para tomar ... <\/p>\n
Seguir leyendo \"C\u00f3mo cambiar el periodo de retenci\u00f3n de AWR en Oracle Database\"<\/span><\/a><\/p>","protected":false},"author":1,"featured_media":2921,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"rank_math_focus_keyword":"","rank_math_title":"","rank_math_description":"Learn how to change the AWR retention period in Oracle Database for better performance analysis and monitoring.","rank_math_robots":"","rank_math_og_title":"","rank_math_og_description":"","jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[31],"tags":[57,58],"class_list":["post-970","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle","tag-awr","tag-retention"],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/rootfan.com\/wp-content\/uploads\/pexels-photo-220213.jpeg?fit=1880%2C1003&ssl=1","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/posts\/970","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/comments?post=970"}],"version-history":[{"count":7,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/posts\/970\/revisions"}],"predecessor-version":[{"id":990,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/posts\/970\/revisions\/990"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/media\/2921"}],"wp:attachment":[{"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/media?parent=970"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/categories?post=970"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/tags?post=970"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}