{"id":19,"date":"2011-09-26T05:59:00","date_gmt":"2011-09-26T05:59:00","guid":{"rendered":"https:\/\/bijoos.com\/oraclenotes\/?p=19"},"modified":"2026-02-07T14:43:41","modified_gmt":"2026-02-07T20:43:41","slug":"oracle11gr1-to-read","status":"publish","type":"post","link":"https:\/\/bijoos.com\/oraclenotes\/2011\/19\/","title":{"rendered":"Oracle11gR1 &#8211; To Read&#8230;"},"content":{"rendered":"<div dir=\"ltr\" trbidi=\"on\"><\/p>\n<div><span><span>\u00a0<\/span><\/span>Database Replay &#8211; <a href=\"http:\/\/www.oracle.com\/technology\/pub\/articles\/oracle-database-11g-top-features\/11g-replay.html\">OTN<\/a>\u00a0 <a href=\"http:\/\/download.oracle.com\/docs\/cd\/B28359_01\/server.111\/b28274\/wcr.htm#PFGRF033\">Documentation<\/a><\/div>\n<div><span><span>\u00a0<\/span><\/span>Interval and Reference Partitions \u2013 <a href=\"http:\/\/www.oracle.com\/technology\/products\/bi\/db\/11g\/pdf\/partitioning-11g-whitepaper.pdf\">Paper <\/a>\u00a0\u00a0<a href=\"http:\/\/download.oracle.com\/docs\/cd\/B28359_01\/server.111\/b32024\/part_admin.htm\">Documentation<\/a><\/div>\n<div><span><span>\u00a0<\/span><\/span>SQL Query Result Cache &#8211; <a href=\"http:\/\/www.oracle.com\/technology\/obe\/11gr1_db\/perform\/rescache\/res_cache.htm\">OTN <\/a>\u00a0\u00a0<a href=\"http:\/\/download.oracle.com\/docs\/cd\/B28359_01\/server.111\/b28274\/memory.htm#insertedID6\">Documentation<\/a><\/div>\n<div>SQL Performance Analyzer \u2013 <a href=\"http:\/\/www.oracle.com\/technology\/pub\/articles\/oracle-database-11g-top-features\/11g-spa.html\">OTN<\/a>\u00a0<a href=\"http:\/\/download.oracle.com\/docs\/cd\/B28359_01\/server.111\/b28274\/spia.htm\">Documentation<\/a><\/div>\n<div><span><span>\u00a0<\/span><\/span>SQL Plan Baseline \u2013 <a href=\"http:\/\/www.oracle.com\/technology\/obe\/11gr1_db\/manage\/spm\/spm.htm\">OTN<\/a>\u00a0 <a href=\"http:\/\/download.oracle.com\/docs\/cd\/B28359_01\/server.111\/b28274\/optplanmgmt.htm\">Documentation<\/a><\/div>\n<div>Automatic SQL Tuning Enhancements &#8211; <a href=\"http:\/\/download.oracle.com\/docs\/cd\/B28359_01\/server.111\/b28274\/sql_tune.htm\">Documentation<\/a><\/div>\n<div>Snapshot Standby &#8211; <a href=\"http:\/\/download.oracle.com\/docs\/cd\/B28359_01\/server.111\/b28294\/manage_ps.htm#BACIEJJI\">Documentation<\/a><\/div>\n<div>Active Data Guard (Real-time query) &#8211; <a href=\"http:\/\/download.oracle.com\/docs\/cd\/B28359_01\/server.111\/b28294\/manage_ps.htm#SBYDB00706\">Documentation<\/a><\/div>\n<div>OLTP Table Compression \u2013 <a href=\"http:\/\/www.oracle.com\/technology\/deploy\/performance\/pdf\/s291861.pdf\">OTN-OOW <\/a>\u00a0\u00a0<a href=\"http:\/\/download.oracle.com\/docs\/cd\/B28359_01\/server.111\/b28310\/tables002.htm#ADMIN11630\">Documentation<\/a><\/div>\n<div>AutoTask Infrastructure &#8211; <a href=\"http:\/\/download.oracle.com\/docs\/cd\/B28359_01\/server.111\/b28310\/tasks.htm#ADMIN0235\">Documentation<\/a><\/div>\n<div>Virtual Columns &#8211; <a href=\"http:\/\/download.oracle.com\/docs\/cd\/B28359_01\/server.111\/b28286\/statements_7002.htm#BABIJABG\">Documentation<\/a><\/div>\n<div>Flashback Data Archive (Oracle Total Recall) &#8211; <a href=\"http:\/\/www.oracle.com\/technology\/deploy\/availability\/pdf\/twp_data_repair_11gr1.pdf\">OTN<\/a><a href=\"http:\/\/download.oracle.com\/docs\/cd\/B28359_01\/appdev.111\/b28424\/adfns_flashback.htm#ADFNS01011\">Documentation<\/a><\/div>\n<div>Flashback Transaction &#8211; <a href=\"http:\/\/www.oracle.com\/technology\/deploy\/availability\/pdf\/twp_data_repair_11gr1.pdf\">OTN<\/a>\u00a0 <a href=\"http:\/\/download.oracle.com\/docs\/cd\/B28359_01\/appdev.111\/b28424\/adfns_flashback.htm#ADFNS1010\">Documentation<\/a><\/div>\n<div>Automatic Diagnostic Repository &#038; ADRCI &#8211; <a href=\"http:\/\/download.oracle.com\/docs\/cd\/B28359_01\/server.111\/b28310\/diag001.htm\">Documentation<\/a><\/div>\n<div>Data Recovery Advisor &#8211; <a href=\"http:\/\/www.oracle.com\/technology\/deploy\/availability\/pdf\/twp_data_repair_11gr1.pdf\">OTN<\/a>\u00a0 <a href=\"http:\/\/download.oracle.com\/docs\/cd\/B28359_01\/server.111\/b28310\/diag009.htm#CHDBHCFF\">Documentation<\/a><\/div>\n<div>Active DB Duplication &#8211; <a href=\"http:\/\/download.oracle.com\/docs\/cd\/B28359_01\/backup.111\/b28270\/rcmdupdb.htm#BGBHBIFE\">Documentation<\/a><\/div>\n<div>Multi-section backups &#8211; <a href=\"http:\/\/download.oracle.com\/docs\/cd\/B28359_01\/backup.111\/b28270\/rcmbckad.htm#BRADV89543\">Documentation<\/a><\/div>\n<div>Lightweight Jobs in Scheduler &#8211; <a href=\"http:\/\/download.oracle.com\/docs\/cd\/B28359_01\/server.111\/b28310\/schedover002.htm#i1106309\">Documentation<\/a><\/div>\n<div>Fine grained dependency tracking &#8211; <a href=\"http:\/\/download.oracle.com\/docs\/cd\/B28359_01\/server.111\/b28318\/dependencies.htm#CHDJIIFC\">Documentation<\/a><\/div>\n<div><\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u00a0Database Replay &#8211; OTN\u00a0 Documentation \u00a0Interval and Reference Partitions \u2013 Paper \u00a0\u00a0Documentation \u00a0SQL Query Result Cache &#8211; OTN \u00a0\u00a0Documentation SQL Performance Analyzer \u2013 OTN\u00a0Documentation \u00a0SQL Plan Baseline \u2013 OTN\u00a0 Documentation Automatic SQL Tuning Enhancements &#8211; Documentation Snapshot Standby &#8211; Documentation Active Data Guard (Real-time query) &#8211; Documentation OLTP Table Compression \u2013 OTN-OOW \u00a0\u00a0Documentation AutoTask Infrastructure &#8230; <a title=\"Oracle11gR1 &#8211; To Read&#8230;\" class=\"read-more\" href=\"https:\/\/bijoos.com\/oraclenotes\/2011\/19\/\" aria-label=\"Read more about Oracle11gR1 &#8211; To Read&#8230;\">Read more<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_hide_featured_image":false,"_jetpack_featured_image_duplicate_dismissed":0,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[133],"tags":[134],"class_list":["post-19","post","type-post","status-publish","format-standard","hentry","category-oracledb","tag-oracle-11g"],"acf":[],"jetpack-related-posts":[{"id":82,"url":"https:\/\/bijoos.com\/oraclenotes\/2013\/82\/","url_meta":{"origin":19,"position":0},"title":"Oracle Database 12c is now GA&#8230; (Finally!!)","author":"Biju","date":"June 25, 2013","format":false,"excerpt":"Oracle Database 12c is released today [June 25]... there is a wealth of new features in 12c database, most major ones were discussed by Oracle speakers in conferences since OOW 2012... The major feature is the introduction of container databases and pluggable databases. Database 12c software is available for download\u2026","rel":"","context":"In &quot;Oracle Database&quot;","block_context":{"text":"Oracle Database","link":"https:\/\/bijoos.com\/oraclenotes\/category\/oracledb\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1690,"url":"https:\/\/bijoos.com\/oraclenotes\/2016\/1690\/","url_meta":{"origin":19,"position":1},"title":"OTN Yathra 2016 &#8211; OTN #OracleACE Conference Tour","author":"Biju","date":"April 18, 2016","format":false,"excerpt":"Very happy and honored to speak in OTN Yathra 2016 tour, along with many Oracle ACE and ACE Directors. This is my first tour as ACED, and thank you AIOUG and OTN for having me. I am looking forward to meet many\u00a0of you, who I know only through twitter or\u2026","rel":"","context":"In &quot;Certification &amp; Learning&quot;","block_context":{"text":"Certification &amp; Learning","link":"https:\/\/bijoos.com\/oraclenotes\/category\/certification-learning\/"},"img":{"alt_text":"OTNYathra","src":"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2016\/04\/OTNYathra.jpg?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2016\/04\/OTNYathra.jpg?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2016\/04\/OTNYathra.jpg?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2016\/04\/OTNYathra.jpg?resize=700%2C400&ssl=1 2x"},"classes":[]},{"id":1765,"url":"https:\/\/bijoos.com\/oraclenotes\/2016\/1765\/","url_meta":{"origin":19,"position":2},"title":"OTN Appreciation Day: The ORAchk and EXAchk Tools #ThanksOTN","author":"Biju","date":"October 11, 2016","format":false,"excerpt":"Thanks Tim for coming up with this idea! Pretty neat... And THANK YOU\u00a0OTN!! There are quite a few features I like in the Oracle Database, but today I choose ORAchk (and EXAchk). Troubleshooting and diagnostics are\u00a0my favorite area and I was amazed by the enhancements Oracle made in integrating the\u2026","rel":"","context":"In &quot;Oracle E-Business Suite&quot;","block_context":{"text":"Oracle E-Business Suite","link":"https:\/\/bijoos.com\/oraclenotes\/category\/ebs\/"},"img":{"alt_text":"otnlogo","src":"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2016\/10\/otnlogo.gif?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":2049,"url":"https:\/\/bijoos.com\/oraclenotes\/2017\/2049\/","url_meta":{"origin":19,"position":3},"title":"Oracle Database 12c (12.2.0.1.0) on VirtualBox","author":"Biju","date":"March 31, 2017","format":false,"excerpt":"A new pre-built VirtualBox image is available for download\u00a0 from OTN (updated on March 27, 2017). Once you download, import and configure the VM, you can pretty much do whatever you want. But Roy and Mike have put together a very good lab environment and exercise for you to practice\u2026","rel":"","context":"In &quot;Oracle Database&quot;","block_context":{"text":"Oracle Database","link":"https:\/\/bijoos.com\/oraclenotes\/category\/oracledb\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1448,"url":"https:\/\/bijoos.com\/oraclenotes\/2014\/1448\/","url_meta":{"origin":19,"position":4},"title":"Oracle Open World 14 &#8211; A Diary","author":"Biju","date":"October 6, 2014","format":false,"excerpt":"I had the opportunity\u00a0to attend this year Open World conference in San Francisco. This was my 7th open world and each year my excitement only goes up. And, this year was special - first conference as Oracle ACE. I am thankful to Oracle Publishers Seminar (+\u00a0Oracle ACE program) and OneNeck\u2026","rel":"","context":"In &quot;Certification &amp; Learning&quot;","block_context":{"text":"Certification &amp; Learning","link":"https:\/\/bijoos.com\/oraclenotes\/category\/certification-learning\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1596,"url":"https:\/\/bijoos.com\/oraclenotes\/2015\/1596\/","url_meta":{"origin":19,"position":5},"title":"Oracle Database 12c Upgrade Hands On Lab","author":"Biju","date":"September 14, 2015","format":false,"excerpt":"Recently I tweeted the download link\u00a0for the Virtual Box OVA file for 12c upgrade Hands on Lab. https:\/\/twitter.com\/biju_thomas\/status\/642804903379927040 Since 11g free extended support is ending in the next few months, this is the time DBAs are busily planning to upgrade their 11g databases to 12c. The HOL OVA available in\u2026","rel":"","context":"In &quot;Oracle Database&quot;","block_context":{"text":"Oracle Database","link":"https:\/\/bijoos.com\/oraclenotes\/category\/oracledb\/"},"img":{"alt_text":"HOL1","src":"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2015\/09\/HOL1-1024x757.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2015\/09\/HOL1-1024x757.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2015\/09\/HOL1-1024x757.png?resize=525%2C300&ssl=1 1.5x"},"classes":[]}],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/19","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/comments?post=19"}],"version-history":[{"count":1,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/19\/revisions"}],"predecessor-version":[{"id":2950,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/19\/revisions\/2950"}],"wp:attachment":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/media?parent=19"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/categories?post=19"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/tags?post=19"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}