Vous pouvez d'abord v\u00e9rifier la p\u00e9riode de conservation des donn\u00e9es AWR dans Oracle en proc\u00e9dant comme suit<\/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\nVous pouvez constater que l'intervalle est de toutes les heures et que la dur\u00e9e de conservation n'est que de 8 jours.<\/p>\n\n\n\n
Vous pouvez modifier la dur\u00e9e de conservation en la ramenant \u00e0 30 jours gr\u00e2ce \u00e0 la formule suivante (30*24*60)<\/p>\n\n\n
\nexecute dbms_workload_repository.modify_snapshot_settings(retention => 43200);\n<\/pre><\/div>\n\n\nSi vous souhaitez \u00e9galement modifier la valeur de SNAP_INTERVAL, vous pouvez le faire comme suit pour prendre des photos toutes les 30 minutes<\/p>\n\n\n
\nexecute dbms_workload_repository.modify_snapshot_settings(interval => 30);\n<\/pre><\/div>\n\n\n<\/p>","protected":false},"excerpt":{"rendered":"
Vous pouvez d'abord v\u00e9rifier la p\u00e9riode de r\u00e9tention des AWR dans Oracle avec ceci Vous pouvez voir que l'intervalle est toutes les heures et que la r\u00e9tention est de 8 jours seulement. Vous pouvez changer la r\u00e9tention \u00e0 30 jours avec ceci (30*24*60) Si vous voulez aussi changer le SNAP_INTERVAL, vous pouvez le changer comme ceci pour prendre ... <\/p>\n
Continuer la lecture de \" Comment modifier la p\u00e9riode de r\u00e9tention des AWR dans la base de donn\u00e9es Oracle \"<\/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\/fr\/wp-json\/wp\/v2\/posts\/970","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/comments?post=970"}],"version-history":[{"count":7,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/posts\/970\/revisions"}],"predecessor-version":[{"id":990,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/posts\/970\/revisions\/990"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/media\/2921"}],"wp:attachment":[{"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/media?parent=970"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/categories?post=970"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/tags?post=970"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}