{"id":1294,"date":"2007-07-12T12:00:00","date_gmt":"2007-07-12T12:00:00","guid":{"rendered":"http:\/\/orcldoug.com\/blog\/?p=1294"},"modified":"2007-07-12T12:00:00","modified_gmt":"2007-07-12T12:00:00","slug":"oracle-11g-total-recall","status":"publish","type":"post","link":"http:\/\/orcldoug.com\/blog\/2007\/07\/12\/oracle-11g-total-recall\/","title":{"rendered":"Oracle 11g – Total Recall"},"content":{"rendered":"

I suppose most readers will be aware that Oracle held a big launch for 11g yesterday, including the release of various technical docs at OTN<\/a>. I’ve only managed a quick scan because I’m up to my eyeballs in some internal ASH\/AWR training I’m giving later today, but what particularly interested me was this paragraph in the New Features Overview<\/a>.<\/p>\n

\n
\u201cTime Travel\u201d with Oracle Flashback Data Archive
Oracle Database 11g
\nalso features Total Recall with Oracle Flashback Data Archive, which enables
\nyou to query data in selected tables \u201cas of\u201d earlier times in the past,
\nthereby providing an easy, practical way to add a time dimension to your data
\nfor change tracking, ILM, auditing, and compliance. Oracle Flashback Data
\nArchive provides automatic and efficient storage of \u201cchange\u201d data to enable
\nfast query access to old versions of the data.<\/div>\n

The DBA can set retention
\npolicies to automatically purge data when your system reaches specified age
\nthresholds\n<\/p><\/blockquote>\n

I’m not sure how much attention that might get because it sounds like just another minor Flashback feature, but I suspect it’s really Rob Squire’s stuff that I talked about here<\/a>. Definitely one for further investigation.<\/div>\n","protected":false},"excerpt":{"rendered":"

I suppose most readers will be aware that Oracle held a big launch for 11g yesterday, including the release of various technical docs at OTN. I’ve only managed a quick scan because I’m up to my eyeballs in some internal ASH\/AWR training I’m giving later today, but what particularly interested me was this paragraph in… Continue reading Oracle 11g – Total Recall<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-1294","post","type-post","status-publish","format-standard","hentry","category-uncategorized","entry"],"jetpack_featured_media_url":"","jetpack-related-posts":[{"id":1308,"url":"http:\/\/orcldoug.com\/blog\/2007\/08\/11\/does-anyone-know-when-11g-will-be-released\/","url_meta":{"origin":1294,"position":0},"title":"Does Anyone Know When 11g Will Be Released?","date":"August 11, 2007","format":false,"excerpt":"Sorry, I shouldn't be so sarcastic, but try to show some sympathy for my schedule.Thursday 9th August 22:30 BST - Go to bed, unusually early.Friday 10th 06:00 BST - Wake up, check Netvibes and noticed several 11g release blogs, including Eddie's initial notification and Howard's installation!07:30 BST - Leave for\u2026","rel":"","context":"With 4 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1374,"url":"http:\/\/orcldoug.com\/blog\/2008\/01\/08\/book-review-oracle-11g-new-features\/","url_meta":{"origin":1294,"position":1},"title":"Book Review – Oracle 11g New Features","date":"January 8, 2008","format":false,"excerpt":"I remember I said I wouldn't do this any more, but last October, someone from Oracle Press contacted me by email because they'd noticed the following words on my website. \"However, those aspects are well dealt with in Oracle Wait Interface: A Practical Guide to Performance Diagnostics and Tuning by\u2026","rel":"","context":"With 2 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1384,"url":"http:\/\/orcldoug.com\/blog\/2008\/02\/24\/book-reviews-again\/","url_meta":{"origin":1294,"position":2},"title":"Book Reviews Again","date":"February 24, 2008","format":false,"excerpt":"Remember I said that I'd requested a copy of the Oracle Press ASM book for review? Well I don't know what I was thinking, because the \"Oracle Database 11g DBA Handbook\" turned up instead the other week. I distinctly recall the ASM book being one of the ones I was\u2026","rel":"","context":"With 3 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1320,"url":"http:\/\/orcldoug.com\/blog\/2007\/09\/23\/parallel-query-and-11g-part-2\/","url_meta":{"origin":1294,"position":3},"title":"Parallel Query and 11g – Part 2","date":"September 23, 2007","format":false,"excerpt":"Now, that's weird. A little surprising might be more accurate and maybe I'm missing something.During the various tests with and without parallel hints and different parallel_io_cap_enabled settings, I expected the runs that didn't use parallelism to show up \"db file scattered read\" events in the trace files. For example, here's\u2026","rel":"","context":"With 10 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1310,"url":"http:\/\/orcldoug.com\/blog\/2007\/08\/14\/thats-more-like-it\/","url_meta":{"origin":1294,"position":4},"title":"That’s More Like It!","date":"August 14, 2007","format":false,"excerpt":"(and I'm writing this from a positive perspective)Now that the community is over the initial 'Look over, there! It's 11g!!!!', there are some genuinely interesting blogs kicking around. (Maybe we need to give these things a little time?) I'd better only talk about a couple, though, or Dave Edwards will\u2026","rel":"","context":"With 7 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1658,"url":"http:\/\/orcldoug.com\/blog\/2011\/11\/07\/upcoming-ukoug-conference\/","url_meta":{"origin":1294,"position":5},"title":"Upcoming UKOUG Conference","date":"November 7, 2011","format":false,"excerpt":"I always look forward to this time of year as the annual UKOUG conference in Birmingham approaches but this year I think I'm looking forward to it more than ever.As I'll have delivered both of my own presentations at previous events my slides will be done before I arrive and\u2026","rel":"","context":"With 8 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts\/1294","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/comments?post=1294"}],"version-history":[{"count":0,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts\/1294\/revisions"}],"wp:attachment":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/media?parent=1294"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/categories?post=1294"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/tags?post=1294"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}