{"id":461,"date":"2024-08-03T08:24:47","date_gmt":"2024-08-03T08:24:47","guid":{"rendered":"https:\/\/humtechno.com\/intro\/?p=461"},"modified":"2024-08-03T08:25:59","modified_gmt":"2024-08-03T08:25:59","slug":"oracle-check-archiving-generating","status":"publish","type":"post","link":"https:\/\/humtechno.com\/intro\/2024\/08\/03\/oracle-check-archiving-generating\/","title":{"rendered":"Oracle Check Archiving Generating"},"content":{"rendered":"\n\n\n\n

Check how much Archive Files Generate During Specific Period of Time<\/strong><\/p>\n\n

SELECT TRUNC (first_time) “Date”, inst_id, TO_CHAR (first_time, ‘Dy’) “Day”,
COUNT (1) “Total”,
SUM (DECODE (TO_CHAR (first_time, ‘hh24′), ’00’, 1, 0)) “h0”,
SUM (DECODE (TO_CHAR (first_time, ‘hh24′), ’01’, 1, 0)) “h1”,
SUM (DECODE (TO_CHAR (first_time, ‘hh24′), ’02’, 1, 0)) “h2”,
SUM (DECODE (TO_CHAR (first_time, ‘hh24′), ’03’, 1, 0)) “h3”,
SUM (DECODE (TO_CHAR (first_time, ‘hh24′), ’04’, 1, 0)) “h4”,
SUM (DECODE (TO_CHAR (first_time, ‘hh24′), ’05’, 1, 0)) “h5”,
SUM (DECODE (TO_CHAR (first_time, ‘hh24′), ’06’, 1, 0)) “h6”,
SUM (DECODE (TO_CHAR (first_time, ‘hh24′), ’07’, 1, 0)) “h7”,
SUM (DECODE (TO_CHAR (first_time, ‘hh24′), ’08’, 1, 0)) “h8”,
SUM (DECODE (TO_CHAR (first_time, ‘hh24′), ’09’, 1, 0)) “h9”,
SUM (DECODE (TO_CHAR (first_time, ‘hh24′), ’10’, 1, 0)) “h10”,
SUM (DECODE (TO_CHAR (first_time, ‘hh24′), ’11’, 1, 0)) “h11”,
SUM (DECODE (TO_CHAR (first_time, ‘hh24′), ’12’, 1, 0)) “h12”,
SUM (DECODE (TO_CHAR (first_time, ‘hh24′), ’13’, 1, 0)) “h13”,
SUM (DECODE (TO_CHAR (first_time, ‘hh24′), ’14’, 1, 0)) “h14”,
SUM (DECODE (TO_CHAR (first_time, ‘hh24′), ’15’, 1, 0)) “h15”,
SUM (DECODE (TO_CHAR (first_time, ‘hh24′), ’16’, 1, 0)) “h16”,
SUM (DECODE (TO_CHAR (first_time, ‘hh24′), ’17’, 1, 0)) “h17”,
SUM (DECODE (TO_CHAR (first_time, ‘hh24′), ’18’, 1, 0)) “h18”,
SUM (DECODE (TO_CHAR (first_time, ‘hh24′), ’19’, 1, 0)) “h19”,
SUM (DECODE (TO_CHAR (first_time, ‘hh24′), ’20’, 1, 0)) “h20”,
SUM (DECODE (TO_CHAR (first_time, ‘hh24′), ’21’, 1, 0)) “h21”,
SUM (DECODE (TO_CHAR (first_time, ‘hh24′), ’22’, 1, 0)) “h22”,
SUM (DECODE (TO_CHAR (first_time, ‘hh24′), ’23’, 1, 0)) “h23”,
ROUND (COUNT (1) \/ 24, 2) “Avg”
FROM gv$log_history
WHERE thread# = inst_id
AND first_time > sysdate -7
GROUP BY TRUNC (first_time), inst_id, TO_CHAR (first_time, ‘Dy’)
ORDER BY 1,2;<\/p>\n\n


<\/p>\n\n\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":2,"featured_media":333,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"pagelayer_contact_templates":[],"_pagelayer_content":"","footnotes":""},"categories":[3],"tags":[56,55],"class_list":["post-461","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle","tag-archiving-generation-trend","tag-oracle-archiving-generating"],"_links":{"self":[{"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/posts\/461","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/comments?post=461"}],"version-history":[{"count":2,"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/posts\/461\/revisions"}],"predecessor-version":[{"id":463,"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/posts\/461\/revisions\/463"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/media\/333"}],"wp:attachment":[{"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/media?parent=461"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/categories?post=461"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/tags?post=461"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}