<?xml version="1.0" encoding="UTF-8"?><rss version="2.0"
	xmlns:content="http://purl.org/rss/1.0/modules/content/"
	xmlns:wfw="http://wellformedweb.org/CommentAPI/"
	xmlns:dc="http://purl.org/dc/elements/1.1/"
	xmlns:atom="http://www.w3.org/2005/Atom"
	xmlns:sy="http://purl.org/rss/1.0/modules/syndication/"
	xmlns:slash="http://purl.org/rss/1.0/modules/slash/"
	>

<channel>
	<title>Database Management and Performance &#8211; OraNA :: Oracle News Aggregator</title>
	<atom:link href="http://orana.info/category/dba/feed/" rel="self" type="application/rss+xml" />
	<link>http://orana.info</link>
	<description>Read and monitor Oracle related blogs and news sources, all in one place.</description>
	<lastBuildDate>Wed, 20 May 2020 07:02:35 +0000</lastBuildDate>
	<language>en-US</language>
	<sy:updatePeriod>hourly</sy:updatePeriod>
	<sy:updateFrequency>1</sy:updateFrequency>
	<generator>https://wordpress.org/?v=4.9.16</generator>
	<item>
		<title>Oracle Database 19c on Fedora 32</title>
		<link>http://orana.info/2020/05/20/oracle-database-19c-on-fedora-32/</link>
		<pubDate>Wed, 20 May 2020 07:02:35 +0000</pubDate>
		<dc:creator><![CDATA[Tim...]]></dc:creator>
				<category><![CDATA[Database Applications Development]]></category>
		<category><![CDATA[Database Management and Performance]]></category>
		<category><![CDATA[f32]]></category>
		<category><![CDATA[19c]]></category>
		<category><![CDATA[32]]></category>
		<category><![CDATA[fedora]]></category>
		<category><![CDATA[linux]]></category>
		<category><![CDATA[Oracle]]></category>

		<guid isPermaLink="false">https://oracle-base.com/blog/?p=9844</guid>
		<description><![CDATA[Fedora 32 was released at the end of April (see here). Here comes the standard warning. Do not install Oracle on Fedora before reading this! Here are the usual things I do when a new version of Fedora comes out. Fedora 32 (F32) InstallationOracle Database 19c Installation On Fedora 32 (F32) I pushed a Vagrant [&#8230;]]]></description>
<enclosure url="" length="0" type="" />
		</item>
		<item>
		<title>Rename Table During DataPump Import</title>
		<link>http://orana.info/2020/05/19/rename-table-during-datapump-import/</link>
		<pubDate>Tue, 19 May 2020 23:07:44 +0000</pubDate>
		<dc:creator><![CDATA[mdinh]]></dc:creator>
				<category><![CDATA[Database Applications Development]]></category>
		<category><![CDATA[Database Management and Performance]]></category>
		<category><![CDATA[18c]]></category>
		<category><![CDATA[datapump]]></category>

		<guid isPermaLink="false">http://mdinh.wordpress.com/?p=5795</guid>
		<description><![CDATA[At source perform export for tables=SCOTT.SALES, SCOTT.ORDERS $ expdp \&#34;/ as sysdba\&#34; directory=DATA_PUMP_DIR tables=SCOTT.SALES,SCOTT.ORDERS dumpfile=SCOTT.dmp logfile=SCOTT.log Preference is to use parameter file vs having to take into consideration and dealing with slash. Import will rename table SALES to SALES_BACKUP and ORDERS to ORDERS_BACKUP for SCOTT schema. $ cat impdp_table.par userid=&#34;/ as sysdba&#34; directory=DATA_PUMP_DIR dumpfile=SCOTT.dmp remap_table=SCOTT.SALES:SALES_BACKUP [&#8230;]]]></description>
<enclosure url="https://1.gravatar.com/avatar/4d1ef2bcc7abd1b06749f347bfbc0add?s=96&#038;d=identicon&#038;r=G" length="0" type="" />
		</item>
		<item>
		<title>Slow Exadata Compute Node Upgrades to Oracle Linux 7</title>
		<link>http://orana.info/2020/05/19/slow-exadata-compute-node-upgrades-to-oracle-linux-7/</link>
		<pubDate>Tue, 19 May 2020 14:22:50 +0000</pubDate>
		<dc:creator><![CDATA[acolvin]]></dc:creator>
				<category><![CDATA[Database Applications Development]]></category>
		<category><![CDATA[Database Management and Performance]]></category>
		<category><![CDATA[exadata]]></category>
		<category><![CDATA[OL7]]></category>
		<category><![CDATA[Oracle Linux]]></category>
		<category><![CDATA[Patching]]></category>
		<category><![CDATA[Upgrades]]></category>

		<guid isPermaLink="false">https://blog.oracle-ninja.com/?p=985</guid>
		<description><![CDATA[One of the cool things that Oracle has done with Exadata is give users the ability to upgrade from Oracle Linux 6 to Oracle Linux 7 with an in-place upgrade process.  This comes automatically when you upgrade the Exadata compute image from 18c to 19c.  Upgrading the compute nodes to 19c give you the ability [&#8230;]]]></description>
<enclosure url="" length="0" type="" />
		</item>
		<item>
		<title>ACFS Mystery</title>
		<link>http://orana.info/2020/05/18/acfs-mystery/</link>
		<pubDate>Mon, 18 May 2020 22:49:10 +0000</pubDate>
		<dc:creator><![CDATA[mdinh]]></dc:creator>
				<category><![CDATA[Database Applications Development]]></category>
		<category><![CDATA[Database Management and Performance]]></category>
		<category><![CDATA[12.2]]></category>
		<category><![CDATA[ACFS]]></category>

		<guid isPermaLink="false">http://mdinh.wordpress.com/?p=5779</guid>
		<description><![CDATA[From ACFS Support On OS Platforms (Certification Matrix). (Doc ID 1369107.1) ACFS and AFD 12.2.0.1 Supported Platforms Vendor : RedHat Linux Version : 7 Update / Kernel : Update 6 3.10.0-957 and later / 3.10.0 Red Hat kernels X86_64 ACFS Bug or PSU : 12.2.0.1.191015 (Base Bug 29963428) Where: “Base” (at the “Bug or PSU” [&#8230;]]]></description>
<enclosure url="https://1.gravatar.com/avatar/4d1ef2bcc7abd1b06749f347bfbc0add?s=96&#038;d=identicon&#038;r=G" length="0" type="" />
		</item>
		<item>
		<title>Video : NTH_VALUE : Problem Solving using Analytic Functions</title>
		<link>http://orana.info/2020/05/18/video-nth_value-problem-solving-using-analytic-functions/</link>
		<pubDate>Mon, 18 May 2020 07:10:09 +0000</pubDate>
		<dc:creator><![CDATA[Tim...]]></dc:creator>
				<category><![CDATA[analytic]]></category>
		<category><![CDATA[Database Applications Development]]></category>
		<category><![CDATA[Database Management and Performance]]></category>
		<category><![CDATA[nth_value]]></category>
		<category><![CDATA[windowing]]></category>
		<category><![CDATA[Functions]]></category>
		<category><![CDATA[Oracle]]></category>
		<category><![CDATA[Oracle Database]]></category>
		<category><![CDATA[video]]></category>

		<guid isPermaLink="false">https://oracle-base.com/blog/?p=9841</guid>
		<description><![CDATA[Today&#8217;s video is a demonstration of the NTH_VALUE analytic function. This is based on this article. NTH_VALUE Analytic Function You might find these useful also. Analytic Functions : IntroductionAnalytic Functions : All ArticlesAnalytic Functions : YouTube Playlist The star of today’s video is Connor McDonald. This is his second visit to the channel. I&#8217;m sure [&#8230;]]]></description>
<enclosure url="" length="0" type="" />
		</item>
		<item>
		<title>Cross-account AWS Glue Data Catalog access with Glue ETL</title>
		<link>http://orana.info/2020/05/16/cross-account-aws-glue-data-catalog-access-with-glue-etl/</link>
		<pubDate>Sat, 16 May 2020 21:20:35 +0000</pubDate>
		<dc:creator><![CDATA[Anand]]></dc:creator>
				<category><![CDATA[Database Applications Development]]></category>
		<category><![CDATA[Database Management and Performance]]></category>
		<category><![CDATA[Glue Catalog]]></category>
		<category><![CDATA[glue etl]]></category>
		<category><![CDATA[aws]]></category>
		<category><![CDATA[cross account]]></category>
		<category><![CDATA[glue]]></category>
		<category><![CDATA[IAM]]></category>

		<guid isPermaLink="false">http://aprakash.wordpress.com/?p=3997</guid>
		<description><![CDATA[To process data in AWS Glue ETL, DataFrame or DynamicFrame is required. A DataFrame is similar to a table and supports functional-style (map/reduce/filter/etc.) along with SQL operations. The AWS Glue DynamicFrame is similar to DataFrame, except that each record is self-describing, so no schema is required initially. It computes a schema on-the-fly when required, and [&#8230;]]]></description>
<enclosure url="https://2.gravatar.com/avatar/edf349b3b768e9552b9c865916d00691?s=96&#038;d=identicon&#038;r=G" length="0" type="" />
<enclosure url="https://aprakash.files.wordpress.com/2020/05/screen-shot-2020-04-27-at-3.55.43-pm-1.png?w=700" length="0" type="" />
		</item>
		<item>
		<title>VirtualBox 6.1.8</title>
		<link>http://orana.info/2020/05/16/virtualbox-6-1-8/</link>
		<pubDate>Sat, 16 May 2020 13:14:57 +0000</pubDate>
		<dc:creator><![CDATA[Tim...]]></dc:creator>
				<category><![CDATA[6.1.8]]></category>
		<category><![CDATA[Database Applications Development]]></category>
		<category><![CDATA[Database Management and Performance]]></category>
		<category><![CDATA[Oracle]]></category>
		<category><![CDATA[virtualBox]]></category>

		<guid isPermaLink="false">https://oracle-base.com/blog/?p=9837</guid>
		<description><![CDATA[I&#8217;m in the middle of doing loads of Vagrant builds and I got a message to say VirtualBox 6.1.8 has been released. The downloads and changelog are in the usual places. I&#8217;ve installed it on Windows 10, macOS Catalina and Oracle Linux 7 hosts without any problems. I&#8217;ve resumed with the Vagrant builds now. So [&#8230;]]]></description>
<enclosure url="" length="0" type="" />
		</item>
		<item>
		<title>Social Distancing : My Experience</title>
		<link>http://orana.info/2020/05/16/social-distancing-my-experience/</link>
		<pubDate>Sat, 16 May 2020 09:33:39 +0000</pubDate>
		<dc:creator><![CDATA[Tim...]]></dc:creator>
				<category><![CDATA[Database Applications Development]]></category>
		<category><![CDATA[Database Management and Performance]]></category>
		<category><![CDATA[social distancing]]></category>
		<category><![CDATA[Misc]]></category>

		<guid isPermaLink="false">https://oracle-base.com/blog/?p=9810</guid>
		<description><![CDATA[The UK has started to relax *some* of the lock-down conditions, so I thought I would write down some of my thoughts related to social distancing&#8230; The Good First and foremost, social isolation and social distancing is predominantly a good thing for me. I live alone, and as I&#8217;ve said many times before I like [&#8230;]]]></description>
<enclosure url="" length="0" type="" />
		</item>
		<item>
		<title>Oracle database migration to cloud with Zero Downtime Migration (ZDM)</title>
		<link>http://orana.info/2020/05/15/oracle-database-migration-to-cloud-with-zero-downtime-migration-zdm/</link>
		<pubDate>Fri, 15 May 2020 21:46:00 +0000</pubDate>
		<dc:creator><![CDATA[The Human Fly]]></dc:creator>
				<category><![CDATA[Database Applications Development]]></category>
		<category><![CDATA[Database Management and Performance]]></category>

		<guid isPermaLink="false">http://orana.info/?guid=d33c5283b0b5cdee9cdec5f7b64d882b</guid>
		<description><![CDATA[I wrote this article on my LN page, visit the link below to read it.https://www.linkedin.com/pulse/on-premise-oracle-db-migration-cloud-zero-downtime-zdm-hussain/?published=t]]></description>
<enclosure url="" length="0" type="" />
		</item>
		<item>
		<title>APEX 20 patch</title>
		<link>http://orana.info/2020/05/15/apex-20-patch/</link>
		<pubDate>Fri, 15 May 2020 09:27:59 +0000</pubDate>
		<dc:creator><![CDATA[Connor McDonald]]></dc:creator>
				<category><![CDATA[Database Applications Development]]></category>
		<category><![CDATA[Database Management and Performance]]></category>
		<category><![CDATA[Application Express]]></category>
		<category><![CDATA[Misc]]></category>
		<category><![CDATA[Patching]]></category>
		<category><![CDATA[Upgrade]]></category>

		<guid isPermaLink="false">http://connormcdonald.wordpress.com/?p=3095</guid>
		<description><![CDATA[I&#8217;ve been debugging an issue within an APEX application and wanted to make sure that my local installation was at the same version as apex.oracle.com. So I logged on to my workspace and ran queries on APEX_RELEASE and APEX_PATCHES and discovered that there was a patch available for 20.1. That patch is 30990551 and you [&#8230;]]]></description>
<enclosure url="https://connormcdonald.files.wordpress.com/2019/04/apex.png" length="0" type="" />
<enclosure url="https://2.gravatar.com/avatar/2903ecfd61caf221b8b8d5df39962891?s=96&#038;d=identicon&#038;r=G" length="0" type="" />
<enclosure url="https://connormcdonald.files.wordpress.com/2020/05/wlemoticon-smile-2.png" length="0" type="" />
		</item>
		<item>
		<title>Oracle Linux 8 (OL8) : Podman</title>
		<link>http://orana.info/2020/05/15/oracle-linux-8-ol8-podman/</link>
		<pubDate>Fri, 15 May 2020 07:09:32 +0000</pubDate>
		<dc:creator><![CDATA[Tim...]]></dc:creator>
				<category><![CDATA[Database Applications Development]]></category>
		<category><![CDATA[Database Management and Performance]]></category>
		<category><![CDATA[Podman]]></category>
		<category><![CDATA[docker]]></category>
		<category><![CDATA[linux]]></category>
		<category><![CDATA[ol8]]></category>
		<category><![CDATA[Oracle]]></category>
		<category><![CDATA[Oracle Linux]]></category>

		<guid isPermaLink="false">https://oracle-base.com/blog/?p=9828</guid>
		<description><![CDATA[When Oracle Linux 8 (OL8) was released, one of the first things I did was check for the Oracle supplied Docker engine. Nothing. Not to worry I thought. They are probably waiting for UEK6 to ship before they worry about the Docker engine. I pretty much left it at that. I wasn&#8217;t really in much [&#8230;]]]></description>
<enclosure url="" length="0" type="" />
		</item>
		<item>
		<title>Migration methods to Autonomous Database (ADB) &#8211; Part IV (DBMS_CLOUD.COPY_DATA)</title>
		<link>http://orana.info/2020/05/14/migration-methods-to-autonomous-database-adb-part-iv-dbms_cloud-copy_data/</link>
		<pubDate>Thu, 14 May 2020 22:30:00 +0000</pubDate>
		<dc:creator><![CDATA[The Human Fly]]></dc:creator>
				<category><![CDATA[Database Applications Development]]></category>
		<category><![CDATA[Database Management and Performance]]></category>

		<guid isPermaLink="false">http://orana.info/?guid=35769c24f91c52b9e3356f076aecc78c</guid>
		<description><![CDATA[In this part of Migration methods to Autonomous Database (ADB) article series, we will see how to load data into ADB database using the DBMS_CLOUD package.Assuming you have an ADB database up &#38; running and you wanna load data from the file stored in any of the supported object storage. The image below from Oracle [&#8230;]]]></description>
<enclosure url="" length="0" type="" />
		</item>
		<item>
		<title>RMAN Restore From Tape</title>
		<link>http://orana.info/2020/05/13/rman-restore-from-tape/</link>
		<pubDate>Thu, 14 May 2020 03:56:03 +0000</pubDate>
		<dc:creator><![CDATA[mdinh]]></dc:creator>
				<category><![CDATA[Database Applications Development]]></category>
		<category><![CDATA[Database Management and Performance]]></category>
		<category><![CDATA[11g]]></category>
		<category><![CDATA[recovery]]></category>
		<category><![CDATA[rman]]></category>

		<guid isPermaLink="false">http://mdinh.wordpress.com/?p=5758</guid>
		<description><![CDATA[In my previous post, Testing RMAN Restore Validate From Tape , now I will perform actual restore. There is requirement to test backup to the new tape library before implementing in production by restoring the database from tape backup. Database resides on file system. Instead of drop database, shutdown abort, delete data files and control [&#8230;]]]></description>
<enclosure url="https://1.gravatar.com/avatar/4d1ef2bcc7abd1b06749f347bfbc0add?s=96&#038;d=identicon&#038;r=G" length="0" type="" />
		</item>
		<item>
		<title>Migration methods to Autonomous Database (ADB) &#8211; Part III (SQL Developer)</title>
		<link>http://orana.info/2020/05/13/migration-methods-to-autonomous-database-adb-part-iii-sql-developer/</link>
		<pubDate>Wed, 13 May 2020 23:05:00 +0000</pubDate>
		<dc:creator><![CDATA[The Human Fly]]></dc:creator>
				<category><![CDATA[Database Applications Development]]></category>
		<category><![CDATA[Database Management and Performance]]></category>
		<category><![CDATA[Autonomous Database (ADB)]]></category>
		<category><![CDATA[migration]]></category>
		<category><![CDATA[sql developer]]></category>

		<guid isPermaLink="false">http://orana.info/?guid=1be39bedbb912c3fb6497aae05d568ea</guid>
		<description><![CDATA[In part III article series of Migration methods to Autonomous Database we will see how to migrate or load data into ADB using SQL Developer.Below slide from Oracle presentation depicts SQL Developer different use cases to migrate or load data into ADB:Following screenshots walk through data loading scenario from an excel sheet into an existing [&#8230;]]]></description>
<enclosure url="" length="0" type="" />
		</item>
		<item>
		<title>Did You Know #36 – List All Active Roles</title>
		<link>http://orana.info/2020/05/13/did-you-know-36-list-all-active-roles/</link>
		<pubDate>Wed, 13 May 2020 15:38:00 +0000</pubDate>
		<dc:creator><![CDATA[Liron Amitzi]]></dc:creator>
				<category><![CDATA[Database Applications Development]]></category>
		<category><![CDATA[Database Management and Performance]]></category>
		<category><![CDATA[database security]]></category>
		<category><![CDATA[Did you know]]></category>
		<category><![CDATA[infrastructure]]></category>

		<guid isPermaLink="false">https://gotodba.com/?p=9584</guid>
		<description><![CDATA[When granting roles to users we need to remember two things: Any child role of the granted role is granted to the user as well (and this is hierarchical) You can turn on and off roles in your session using the SET ROLE command So now comes the question, how can I see ALL roles [&#8230;]]]></description>
<enclosure url="" length="0" type="" />
		</item>
		<item>
		<title>Oracle Linux 8 (OL8) : Vagrant and Docker builds for 19c Database</title>
		<link>http://orana.info/2020/05/13/oracle-linux-8-ol8-vagrant-and-docker-builds-for-19c-database/</link>
		<pubDate>Wed, 13 May 2020 07:33:34 +0000</pubDate>
		<dc:creator><![CDATA[Tim...]]></dc:creator>
				<category><![CDATA[Database Applications Development]]></category>
		<category><![CDATA[Database Management and Performance]]></category>
		<category><![CDATA[19c]]></category>
		<category><![CDATA[database]]></category>
		<category><![CDATA[ol8]]></category>
		<category><![CDATA[Oracle]]></category>
		<category><![CDATA[Vagrant]]></category>

		<guid isPermaLink="false">https://oracle-base.com/blog/?p=9821</guid>
		<description><![CDATA[A couple of days ago I mentioned the certification of Oracle database 19c on Oracle Linux 8 (OL8) with UEK6. I&#8217;ve had a bunch of OL8 articles and builds for a while, but up until now they&#8217;ve included warnings to say they weren&#8217;t certified. Over the last couple of evenings I&#8217;ve made some changes, so [&#8230;]]]></description>
<enclosure url="" length="0" type="" />
		</item>
		<item>
		<title>Mumbai blog moved</title>
		<link>http://orana.info/2020/05/12/mumbai-blog-moved/</link>
		<pubDate>Wed, 13 May 2020 05:19:30 +0000</pubDate>
		<dc:creator><![CDATA[Marcus]]></dc:creator>
				<category><![CDATA[Database Applications Development]]></category>
		<category><![CDATA[Database Management and Performance]]></category>
		<category><![CDATA[Mumbai]]></category>

		<guid isPermaLink="false">https://www.marcusmoennig.de/blog/?p=805</guid>
		<description><![CDATA[In preparation for me starting as an Oracle freelancer, my Mumbai blog is moving here (https://www.marcusmoennig.de/blog/). Please update your bookmarks. If you signed up for email notifications about updates on the old blog hosted at wordpress.com, these update emails will no longer be available on this new blog to keep the GDPR/DSGVO setup simple. Please [&#8230;]]]></description>
<enclosure url="" length="0" type="" />
		</item>
		<item>
		<title>APEX upgrade – don’t forget your CDN</title>
		<link>http://orana.info/2020/05/12/apex-upgrade-dont-forget-your-cdn/</link>
		<pubDate>Wed, 13 May 2020 03:02:07 +0000</pubDate>
		<dc:creator><![CDATA[Connor McDonald]]></dc:creator>
				<category><![CDATA[Database Applications Development]]></category>
		<category><![CDATA[Database Management and Performance]]></category>
		<category><![CDATA[Application Express]]></category>
		<category><![CDATA[Misc]]></category>
		<category><![CDATA[Upgrade]]></category>

		<guid isPermaLink="false">http://connormcdonald.wordpress.com/?p=3077</guid>
		<description><![CDATA[I haven&#8217;t dug too deep into this one, so what follows may be just coincidental but I thought I would blog it out just in case it happens to anyone else. While testing AskTOM as part of our Application Express upgrade to version 20.1, I got a bit of a shock when I fired up [&#8230;]]]></description>
<enclosure url="https://connormcdonald.files.wordpress.com/2019/07/whats-apex.png" length="0" type="" />
<enclosure url="https://2.gravatar.com/avatar/2903ecfd61caf221b8b8d5df39962891?s=96&#038;d=identicon&#038;r=G" length="0" type="" />
<enclosure url="https://connormcdonald.files.wordpress.com/2020/04/wlemoticon-smile-2.png" length="0" type="" />
<enclosure url="https://connormcdonald.files.wordpress.com/2020/04/image_thumb.png" length="0" type="" />
<enclosure url="https://connormcdonald.files.wordpress.com/2020/04/image_thumb-1.png" length="0" type="" />
<enclosure url="https://connormcdonald.files.wordpress.com/2020/04/image_thumb-2.png" length="0" type="" />
		</item>
		<item>
		<title>Migration methods to Autonomous Database (ADB) &#8211; Part II (MV2ADB)</title>
		<link>http://orana.info/2020/05/12/migration-methods-to-autonomous-database-adb-part-ii-mv2adb/</link>
		<pubDate>Tue, 12 May 2020 21:37:00 +0000</pubDate>
		<dc:creator><![CDATA[The Human Fly]]></dc:creator>
				<category><![CDATA[Database Applications Development]]></category>
		<category><![CDATA[Database Management and Performance]]></category>
		<category><![CDATA[MV2ADB]]></category>
		<category><![CDATA[Autonomous Database (ADB)]]></category>
		<category><![CDATA[migration]]></category>

		<guid isPermaLink="false">http://orana.info/?guid=97fa0ed7b03ebf7c98475562cf233d1d</guid>
		<description><![CDATA[In part II of migration methods to ADB blog series, we will look into MV2ADB tool details and usage. If you haven't read the Part I, I would encourage you to read it to get basic knowledge on various solutions offered by Oracle and some of the prerequisites for on-premise database migration to ADB.Move to [&#8230;]]]></description>
<enclosure url="" length="0" type="" />
		</item>
		<item>
		<title>Creating PDFs in APEX after ORDS 19.1</title>
		<link>http://orana.info/2020/05/12/creating-pdfs-in-apex-after-ords-19-1/</link>
		<pubDate>Tue, 12 May 2020 15:39:50 +0000</pubDate>
		<dc:creator><![CDATA[Jakub Granieczny]]></dc:creator>
				<category><![CDATA[Database Applications Development]]></category>
		<category><![CDATA[Database Management and Performance]]></category>

		<guid isPermaLink="false">http://orana.info/?guid=d0509883d362c2d484852a24131ced7f</guid>
		<description><![CDATA[Creating PDFs in APEX after ORDS 19.1 Until 19.1 ORDS provided a built-in printing engine based on Apache FOP which allowed you to download a PDF version of your reports and XLS-FO templates in a very easy manner. However in ORDS 18.4.0 release notes we could find information that this feature is deprecated and will be [&#8230;]]]></description>
<enclosure url="" length="0" type="" />
		</item>
		<item>
		<title>from$_subquery$_NNN</title>
		<link>http://orana.info/2020/05/12/from_subquery_nnn/</link>
		<pubDate>Tue, 12 May 2020 15:26:37 +0000</pubDate>
		<dc:creator><![CDATA[Jonathan Lewis]]></dc:creator>
				<category><![CDATA[Database Applications Development]]></category>
		<category><![CDATA[Database Management and Performance]]></category>
		<category><![CDATA[Execution plans]]></category>
		<category><![CDATA[Oracle]]></category>

		<guid isPermaLink="false">http://jonathanlewis.wordpress.com/?p=22496</guid>
		<description><![CDATA[This is a reference note for a question that came up as a comment on a lengthy note I wrote about reading execution plans. How do you interpret something like: from$_subquery$_001@SEL$1 in the Query Block Name / Object Alias section of an execution plan. The simple answer is that if you&#8217;ve got an inline view [&#8230;]]]></description>
<enclosure url="https://2.gravatar.com/avatar/54b25954048c9f2599fe1356a254fe84?s=96&#038;d=https://2.gravatar.com/avatar/ad516503a11cd5ca435acc9bb6523536?s=96&#038;r=G" length="0" type="" />
		</item>
		<item>
		<title>Testing RMAN Restore Validate From Tape</title>
		<link>http://orana.info/2020/05/12/testing-rman-restore-validate-from-tape/</link>
		<pubDate>Tue, 12 May 2020 13:17:51 +0000</pubDate>
		<dc:creator><![CDATA[mdinh]]></dc:creator>
				<category><![CDATA[Database Applications Development]]></category>
		<category><![CDATA[Database Management and Performance]]></category>
		<category><![CDATA[rman]]></category>

		<guid isPermaLink="false">http://mdinh.wordpress.com/?p=5744</guid>
		<description><![CDATA[Short and simple method to validate backup. oracle@hawk:/home/oracle$ rman checksyntax @ restore_validate_idpa_ddbea.rman Recovery Manager: Release 11.2.0.4.0 - Production on Tue May 12 07:24:57 2020 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. RMAN&#62; set echo on 2&#62; connect target; 3&#62; show all; 4&#62; list backup summary; 5&#62; report schema; 6&#62; run { [&#8230;]]]></description>
<enclosure url="https://1.gravatar.com/avatar/4d1ef2bcc7abd1b06749f347bfbc0add?s=96&#038;d=identicon&#038;r=G" length="0" type="" />
		</item>
		<item>
		<title>Arbitrary length addition and subtraction</title>
		<link>http://orana.info/2020/05/11/arbitrary-length-addition-and-subtraction/</link>
		<pubDate>Tue, 12 May 2020 06:18:25 +0000</pubDate>
		<dc:creator><![CDATA[Connor McDonald]]></dc:creator>
				<category><![CDATA[Database Applications Development]]></category>
		<category><![CDATA[Database Management and Performance]]></category>
		<category><![CDATA[Misc]]></category>
		<category><![CDATA[nested table]]></category>
		<category><![CDATA[pl/sql]]></category>
		<category><![CDATA[raw]]></category>

		<guid isPermaLink="false">http://connormcdonald.wordpress.com/?p=3088</guid>
		<description><![CDATA[This one just for fun today. An AskTOM question came in about arbitrary length arithmetic because &#8220;NUMBER(38) was not enough&#8221;. After some back-and-forth discussions it turned out that the business need under the requirement was managing bit strings. The implementation was currently converting the bits to decimals, hence the need for potentially very large number [&#8230;]]]></description>
<enclosure url="https://connormcdonald.files.wordpress.com/2020/05/abacus-3288079_1920.jpg" length="0" type="" />
<enclosure url="https://2.gravatar.com/avatar/2903ecfd61caf221b8b8d5df39962891?s=96&#038;d=identicon&#038;r=G" length="0" type="" />
<enclosure url="https://connormcdonald.files.wordpress.com/2020/05/wlemoticon-smile-1.png" length="0" type="" />
		</item>
		<item>
		<title>Oracle 19c Automatic Indexing: Dropping Automatic Indexes (Fall Dog Bombs The Moon)</title>
		<link>http://orana.info/2020/05/11/oracle-19c-automatic-indexing-dropping-automatic-indexes-fall-dog-bombs-the-moon/</link>
		<pubDate>Tue, 12 May 2020 04:19:03 +0000</pubDate>
		<dc:creator><![CDATA[Richard Foote]]></dc:creator>
				<category><![CDATA[Database Applications Development]]></category>
		<category><![CDATA[Database Management and Performance]]></category>
		<category><![CDATA[19c]]></category>
		<category><![CDATA[19c New Features]]></category>
		<category><![CDATA[Automatic Indexing]]></category>
		<category><![CDATA[Drop Index]]></category>
		<category><![CDATA[Index Rebuild]]></category>
		<category><![CDATA[Oracle Indexes]]></category>

		<guid isPermaLink="false">http://richardfoote.wordpress.com/?p=6188</guid>
		<description><![CDATA[Julian Dontcheff recently wrote a nice article on the new Automatic Index Optimization feature available in the upcoming Oracle Database 20c release (I&#8217;ll of course blog about this new 20c feature in the near future). Within the article, Julian mentioned a clever method of how to effectively drop Automatic Indexes that I thought would be [&#8230;]]]></description>
<enclosure url="https://richardfoote.files.wordpress.com/2020/05/reality.jpg" length="0" type="" />
<enclosure url="https://1.gravatar.com/avatar/d665f0bedd1b771fb94defcaae359a7e?s=96&#038;d=identicon&#038;r=G" length="0" type="" />
		</item>
		<item>
		<title>Service Battery warning on macOS</title>
		<link>http://orana.info/2020/05/11/service-battery-warning-on-macos/</link>
		<pubDate>Mon, 11 May 2020 19:23:14 +0000</pubDate>
		<dc:creator><![CDATA[Natalka]]></dc:creator>
				<category><![CDATA[battery]]></category>
		<category><![CDATA[Database Applications Development]]></category>
		<category><![CDATA[Database Management and Performance]]></category>
		<category><![CDATA[smc]]></category>
		<category><![CDATA[MACOS]]></category>
		<category><![CDATA[Tech]]></category>

		<guid isPermaLink="false">http://rdbms-insight.com/wp/?p=722</guid>
		<description><![CDATA[Scene: INT. LATE NIGHT. NATALKA is typing on a MACBOOK AIR. Suddenly, the screen goes dark. Silence. The MACBOOK AIR has shut down with no warning. Once upon a time, my laptop was well-behaved. It warned me politely when it was nearly out of power and shutdown was imminent. Image ganked from someone who still [&#8230;]]]></description>
<enclosure url="" length="0" type="" />
		</item>
		<item>
		<title>Exadata Virtualized DB node restore</title>
		<link>http://orana.info/2020/05/11/exadata-virtualized-db-node-restore/</link>
		<pubDate>Mon, 11 May 2020 16:01:43 +0000</pubDate>
		<dc:creator><![CDATA[Sidhu]]></dc:creator>
				<category><![CDATA[Database Applications Development]]></category>
		<category><![CDATA[Database Management and Performance]]></category>
		<category><![CDATA[exadata]]></category>
		<category><![CDATA[OneCommand]]></category>
		<category><![CDATA[ovs]]></category>
		<category><![CDATA[restore]]></category>

		<guid isPermaLink="false">https://amardeepsidhu.com/blog/?p=695</guid>
		<description><![CDATA[There are two common scenarios when we may need this: An existing DB node has crashed and is unrecoverable (due to some failure and non-availability of any backups. Though some of the things may need to be done even if the backups were available).We have an existing Exadata rack that is virtualized. Now there is [&#8230;]]]></description>
<enclosure url="" length="0" type="" />
		</item>
		<item>
		<title>Oracle Linux 8 (OL8) : Updates – UEK6, Podman, Database 19c Certification</title>
		<link>http://orana.info/2020/05/11/oracle-linux-8-ol8-updates-uek6-podman-database-19c-certification/</link>
		<pubDate>Mon, 11 May 2020 12:19:03 +0000</pubDate>
		<dc:creator><![CDATA[Tim...]]></dc:creator>
				<category><![CDATA[Database Applications Development]]></category>
		<category><![CDATA[Database Management and Performance]]></category>
		<category><![CDATA[Oracle Linux 8]]></category>
		<category><![CDATA[19c]]></category>
		<category><![CDATA[certification]]></category>
		<category><![CDATA[ol8]]></category>
		<category><![CDATA[Oracle]]></category>

		<guid isPermaLink="false">https://oracle-base.com/blog/?p=9816</guid>
		<description><![CDATA[Last week I had a quick email exchange with Simon Coter from Oracle about a few things related to Oracle Linux 8. I&#8217;ve been a little out of the loop over the last few weeks because of some important world event or another, so I had a bit of catching up to do. UEK6 Went [&#8230;]]]></description>
<enclosure url="" length="0" type="" />
		</item>
		<item>
		<title>Silent installation: Oracle Restart 19c, ASM Filter Driver, UEK 5 edition</title>
		<link>http://orana.info/2020/05/11/silent-installation-oracle-restart-19c-asm-filter-driver-uek-5-edition/</link>
		<pubDate>Mon, 11 May 2020 11:05:55 +0000</pubDate>
		<dc:creator><![CDATA[Martin Bach]]></dc:creator>
				<category><![CDATA[Database Applications Development]]></category>
		<category><![CDATA[Database Management and Performance]]></category>
		<category><![CDATA[19c]]></category>
		<category><![CDATA[Automatic Storage Management]]></category>
		<category><![CDATA[KVM]]></category>

		<guid isPermaLink="false">http://martincarstenbach.wordpress.com/?p=6318</guid>
		<description><![CDATA[As promised in an earlier post here are my notes about installing Oracle Restart with ASM Filter Driver (ASMFD) 19c on Oracle Linux 7 using UEK 5. Since the approach you are about to read isn&#8217;t explicitly covered in the documentation I suggest you ask Oracle Support whether it is supported before using this outside [&#8230;]]]></description>
<enclosure url="https://1.gravatar.com/avatar/ac1dc15a1881a84c0bd660ce1e239534?s=96&#038;d=https://1.gravatar.com/avatar/ad516503a11cd5ca435acc9bb6523536?s=96&#038;r=G" length="0" type="" />
		</item>
		<item>
		<title>Video : NTILE : Problem Solving using Analytic Functions</title>
		<link>http://orana.info/2020/05/10/video-ntile-problem-solving-using-analytic-functions/</link>
		<pubDate>Mon, 11 May 2020 05:57:41 +0000</pubDate>
		<dc:creator><![CDATA[Tim...]]></dc:creator>
				<category><![CDATA[Database Applications Development]]></category>
		<category><![CDATA[Database Management and Performance]]></category>
		<category><![CDATA[Misc]]></category>

		<guid isPermaLink="false">https://oracle-base.com/blog/?p=9813</guid>
		<description><![CDATA[In today&#8217;s video we work through some examples of using the NTILE analytic function to solve some specific problems. The video is based on the following article. NTILE Analytic Function You might find these useful also. Analytic Functions : IntroductionAnalytic Functions : All ArticlesAnalytic Functions : YouTube Playlist The star of today&#8217;s video is Alex [&#8230;]]]></description>
<enclosure url="" length="0" type="" />
		</item>
		<item>
		<title>Migration methods to Autonomous Database (ADB)  &#8211; Part I (Data Pump)</title>
		<link>http://orana.info/2020/05/10/migration-methods-to-autonomous-database-adb-part-i-data-pump/</link>
		<pubDate>Sun, 10 May 2020 22:35:00 +0000</pubDate>
		<dc:creator><![CDATA[The Human Fly]]></dc:creator>
				<category><![CDATA[Database Applications Development]]></category>
		<category><![CDATA[Database Management and Performance]]></category>
		<category><![CDATA[Autonomous Database (ADB)]]></category>
		<category><![CDATA[cloud migration]]></category>
		<category><![CDATA[Data migration]]></category>
		<category><![CDATA[migration]]></category>

		<guid isPermaLink="false">http://orana.info/?guid=226c76886146a60667d4b369d4220ab7</guid>
		<description><![CDATA[In this part of on-premise Oracle database migration to ADB series, we will focus on set of tools to migrate your on-prime database to Autonomies database (ADB). We will briefly discuss about various migration solutions offered by Oracle and walk through data pumps migration pre-requisites and procedure.Database cloud migration requires a good amount of knowledge [&#8230;]]]></description>
<enclosure url="" length="0" type="" />
		</item>
		<item>
		<title>nohup vs screen</title>
		<link>http://orana.info/2020/05/10/nohup-vs-screen/</link>
		<pubDate>Sun, 10 May 2020 20:12:32 +0000</pubDate>
		<dc:creator><![CDATA[mdinh]]></dc:creator>
				<category><![CDATA[Database Applications Development]]></category>
		<category><![CDATA[Database Management and Performance]]></category>
		<category><![CDATA[linux]]></category>
		<category><![CDATA[shell scripting]]></category>

		<guid isPermaLink="false">http://mdinh.wordpress.com/?p=5729</guid>
		<description><![CDATA[While I have played a little with screen , my preference is nohup since the output from screen is so ugly. With that being said, it would be nice for application designs to be resumable, e.g. Shocking opatchauto resume works after auto-logout There were discussions about running many SQLs where each SQL is run manually, check [&#8230;]]]></description>
<enclosure url="https://1.gravatar.com/avatar/4d1ef2bcc7abd1b06749f347bfbc0add?s=96&#038;d=identicon&#038;r=G" length="0" type="" />
		</item>
		<item>
		<title>Oracle EUS authentication with LSA activated on AD</title>
		<link>http://orana.info/2020/05/09/oracle-eus-authentication-with-lsa-activated-on-ad/</link>
		<pubDate>Sat, 09 May 2020 17:30:00 +0000</pubDate>
		<dc:creator><![CDATA[Martin Berger]]></dc:creator>
				<category><![CDATA[Database Applications Development]]></category>
		<category><![CDATA[Database Management and Performance]]></category>
		<category><![CDATA[LSA]]></category>
		<category><![CDATA[oidpwdcn.dll]]></category>
		<category><![CDATA[signtool.exe]]></category>
		<category><![CDATA[EUS]]></category>
		<category><![CDATA[OUD]]></category>

		<guid isPermaLink="false">http://orana.info/?guid=74be1a49d88d4ac251a0d3fd6b513815</guid>
		<description><![CDATA[Are there to many abbrevations in a posts title possible? If you think so, you might see this post a good example.&#160;The setting I'm talking about is an Oracle Universal Directory (OUD) which works as a proxy between Oracle databases and Active Directory (AD) where the users are managed. Unfortunately it stopped working. Even when [&#8230;]]]></description>
<enclosure url="" length="0" type="" />
		</item>
		<item>
		<title>Advanced Oracle SQL Tuning Training</title>
		<link>http://orana.info/2020/05/08/advanced-oracle-sql-tuning-training/</link>
		<pubDate>Sat, 09 May 2020 02:11:52 +0000</pubDate>
		<dc:creator><![CDATA[Tanel Poder Consulting]]></dc:creator>
				<category><![CDATA[Database Applications Development]]></category>
		<category><![CDATA[Database Management and Performance]]></category>

		<guid isPermaLink="false">https://tanelpoder.com/seminar/advanced-oracle-sql-tuning-training/</guid>
		<description><![CDATA[When I delivered a previous version of this class last, it was year 2013 and the latest Oracle version was 11.2. Since plenty of people have asked if I ever do this training again - and now that Oracle 18c is out with a lot of new (and adaptive) stuff added since version 11, I&#8217;ve [&#8230;]]]></description>
<enclosure url="" length="0" type="" />
		</item>
		<item>
		<title>Practical Linux Performance and Application Troubleshooting Training</title>
		<link>http://orana.info/2020/05/08/practical-linux-performance-and-application-troubleshooting-training/</link>
		<pubDate>Sat, 09 May 2020 02:11:51 +0000</pubDate>
		<dc:creator><![CDATA[Tanel Poder Consulting]]></dc:creator>
				<category><![CDATA[Database Applications Development]]></category>
		<category><![CDATA[Database Management and Performance]]></category>

		<guid isPermaLink="false">https://tanelpoder.com/seminar/practical-linux-performance-application-troubleshooting-training/</guid>
		<description><![CDATA[Training overview The emphasis of this class is on practical application troubleshooting and Linux OS performance tuning techniques. We’ll be using scripts and tools that you can use on any Linux machine whenever a problem happens, without having to first install a complex layer of monitoring tools. At the same time, we will go way [&#8230;]]]></description>
<enclosure url="" length="0" type="" />
		</item>
		<item>
		<title>Confirmation</title>
		<link>http://orana.info/2020/05/08/confirmation/</link>
		<pubDate>Sat, 09 May 2020 02:11:51 +0000</pubDate>
		<dc:creator><![CDATA[Tanel Poder Consulting]]></dc:creator>
				<category><![CDATA[Database Applications Development]]></category>
		<category><![CDATA[Database Management and Performance]]></category>

		<guid isPermaLink="false">https://tanelpoder.com/seminar/success/</guid>
		<description><![CDATA[Success! Thanks for signing up for my class! You will receive an email with the payment receipt from Paypal that confirms your attendance. If you don&#8217;t see this email, please check your spam folder. In case of any questions, please email: seminars@poderc.com I will send out the slides, scripts and webinar joining instructions on the [&#8230;]]]></description>
<enclosure url="" length="0" type="" />
		</item>
		<item>
		<title>Hacking Session: Oracle SQL Monitoring &#8211; Understanding the Execution Timeline column and CPU usage</title>
		<link>http://orana.info/2020/05/08/hacking-session-oracle-sql-monitoring-understanding-the-execution-timeline-column-and-cpu-usage/</link>
		<pubDate>Fri, 08 May 2020 21:00:00 +0000</pubDate>
		<dc:creator><![CDATA[Tanel Poder Consulting]]></dc:creator>
				<category><![CDATA[Database Applications Development]]></category>
		<category><![CDATA[Database Management and Performance]]></category>

		<guid isPermaLink="false">https://tanelpoder.com/posts/hacking-session-oracle-sql-monitoring-timeline-column-and-cpu-usage/</guid>
		<description><![CDATA[I will run another hacking session that has been in my mind for a while. It will be a pretty narrow deep-dive into one of the SQL Monitoring report&#8217;s columns that is not well explained: Oracle SQL Monitoring - Understanding the Execution Timeline column In this hacking session, I will explain how to read the [&#8230;]]]></description>
<enclosure url="" length="0" type="" />
		</item>
		<item>
		<title>Oracle 20c DBCA</title>
		<link>http://orana.info/2020/05/07/oracle-20c-dbca/</link>
		<pubDate>Fri, 08 May 2020 00:47:13 +0000</pubDate>
		<dc:creator><![CDATA[Liron Amitzi]]></dc:creator>
				<category><![CDATA[Database Applications Development]]></category>
		<category><![CDATA[Database Management and Performance]]></category>
		<category><![CDATA[20c]]></category>
		<category><![CDATA[cloud]]></category>
		<category><![CDATA[Features]]></category>
		<category><![CDATA[infrastructure]]></category>
		<category><![CDATA[OCI]]></category>

		<guid isPermaLink="false">https://gotodba.com/?p=9566</guid>
		<description><![CDATA[As you probably know, Oracle 20c is available only as a preview on the cloud. If you&#8217;d like to create a new server on Oracle Cloud with 20c, here is a post with the instructions. However, I thought of a way to still check the new dbca and it&#8217;s quite simple. Once you have a [&#8230;]]]></description>
<enclosure url="" length="0" type="" />
		</item>
		<item>
		<title>Cloud Vanity: A Weekly Carnival of AWS, GCP and Azure &#8211; Edition 1</title>
		<link>http://orana.info/2020/05/07/cloud-vanity-a-weekly-carnival-of-aws-gcp-and-azure-edition-1/</link>
		<pubDate>Thu, 07 May 2020 23:46:00 +0000</pubDate>
		<dc:creator><![CDATA[Fahd Mirza]]></dc:creator>
				<category><![CDATA[AWS Blogs]]></category>
		<category><![CDATA[Azure Blogs]]></category>
		<category><![CDATA[Cloud Blog Aggregator]]></category>
		<category><![CDATA[Cloud Carnival]]></category>
		<category><![CDATA[Cloud Vanity]]></category>
		<category><![CDATA[Database Applications Development]]></category>
		<category><![CDATA[Database Management and Performance]]></category>
		<category><![CDATA[GCP Blogs]]></category>
		<category><![CDATA[aws]]></category>
		<category><![CDATA[Azure]]></category>
		<category><![CDATA[GCP]]></category>

		<guid isPermaLink="false">http://orana.info/?guid=8f19bcb812d422fbc2f95ad7da3fb097</guid>
		<description><![CDATA[This is the first edition of this weekly collection about what is happening in the rapidly evolving cloud sphere. This will mainly focus on news, blogs, articles, tidbits, and views from AWS, Azure and GCP but will also include other Cloud providers from time to time. Enjoy Reading!!!AWS:Amazon Relational Database Service (RDS) for SQL Server [&#8230;]]]></description>
<enclosure url="" length="0" type="" />
		</item>
		<item>
		<title>OEDA Virtualized Cluster Discovery With SSH Keys</title>
		<link>http://orana.info/2020/05/07/oeda-virtualized-cluster-discovery-with-ssh-keys/</link>
		<pubDate>Thu, 07 May 2020 21:04:22 +0000</pubDate>
		<dc:creator><![CDATA[acolvin]]></dc:creator>
				<category><![CDATA[Database Applications Development]]></category>
		<category><![CDATA[Database Management and Performance]]></category>
		<category><![CDATA[/Discovery]]></category>
		<category><![CDATA[exadata]]></category>
		<category><![CDATA[installation]]></category>
		<category><![CDATA[OEDA]]></category>
		<category><![CDATA[Patching]]></category>
		<category><![CDATA[Upgrades]]></category>

		<guid isPermaLink="false">https://blog.oracle-ninja.com/?p=969</guid>
		<description><![CDATA[As part of the Oracle Exadata Deployment Assistant (&#8220;OEDA&#8221;), Oracle includes a command line utility to read and modify the XML files used for deployment of an Exadata cluster.  Typical use cases are to install additional Oracle database versions, or to create multiple databases before deployment.  There are several additional features included for virtualized clusters, [&#8230;]]]></description>
<enclosure url="" length="0" type="" />
		</item>
		<item>
		<title>Build an HVR Hub without underlying database</title>
		<link>http://orana.info/2020/05/07/build-an-hvr-hub-without-underlying-database/</link>
		<pubDate>Thu, 07 May 2020 18:57:16 +0000</pubDate>
		<dc:creator><![CDATA[dbasolved]]></dc:creator>
				<category><![CDATA[Database Applications Development]]></category>
		<category><![CDATA[Database Management and Performance]]></category>
		<category><![CDATA[heterogenous replication]]></category>
		<category><![CDATA[HVR]]></category>
		<category><![CDATA[hvr gui]]></category>
		<category><![CDATA[locations]]></category>
		<category><![CDATA[12c]]></category>
		<category><![CDATA[18c]]></category>
		<category><![CDATA[19c]]></category>
		<category><![CDATA[channels]]></category>
		<category><![CDATA[cloud]]></category>
		<category><![CDATA[goldengate migrations]]></category>
		<category><![CDATA[gui]]></category>
		<category><![CDATA[infrastructure]]></category>
		<category><![CDATA[Migrations]]></category>
		<category><![CDATA[Oracle]]></category>
		<category><![CDATA[Replication]]></category>

		<guid isPermaLink="false">https://www.dbasolved.com/?p=2264</guid>
		<description><![CDATA[In recent years, the data integration/replication space has stared to become crowded.  Products like Oracle GoldenGate have become stables inside of organizations, but companies like HVR are chipping away at that marketshare.  Since I left Oracle, I’ve been evaluating and looking at some of these data integration/replication tools and I like HVR.  HVR provides some [&#8230;]]]></description>
<enclosure url="" length="0" type="" />
		</item>
		<item>
		<title>Versioning for your local Vagrant boxes: handling updates</title>
		<link>http://orana.info/2020/05/07/versioning-for-your-local-vagrant-boxes-handling-updates/</link>
		<pubDate>Thu, 07 May 2020 08:46:22 +0000</pubDate>
		<dc:creator><![CDATA[Martin Bach]]></dc:creator>
				<category><![CDATA[Database Applications Development]]></category>
		<category><![CDATA[Database Management and Performance]]></category>
		<category><![CDATA[automation]]></category>
		<category><![CDATA[linux]]></category>

		<guid isPermaLink="false">http://martincarstenbach.wordpress.com/?p=6434</guid>
		<description><![CDATA[In my last post I summarised how to enable versioning for Vagrant box outside Vagrant&#8217;s cloud. In this part I&#8217;d like to share how to update a box. My environment The environment hasn&#8217;t changed compared to the first post. In summary I&#8217;m using Ubuntu 20.04 LTSVirtualbox 6.1.6Vagrant 2.2.7 Updating a box Let&#8217;s assume it&#8217;s time [&#8230;]]]></description>
<enclosure url="https://1.gravatar.com/avatar/ac1dc15a1881a84c0bd660ce1e239534?s=96&#038;d=https://1.gravatar.com/avatar/ad516503a11cd5ca435acc9bb6523536?s=96&#038;r=G" length="0" type="" />
		</item>
		<item>
		<title>Implementing Glue ETL job with Job Bookmarks</title>
		<link>http://orana.info/2020/05/07/implementing-glue-etl-job-with-job-bookmarks/</link>
		<pubDate>Thu, 07 May 2020 07:42:03 +0000</pubDate>
		<dc:creator><![CDATA[Anand]]></dc:creator>
				<category><![CDATA[Database Applications Development]]></category>
		<category><![CDATA[Database Management and Performance]]></category>
		<category><![CDATA[glue etl]]></category>
		<category><![CDATA[incremental processing]]></category>
		<category><![CDATA[job bookmark]]></category>
		<category><![CDATA[aws]]></category>
		<category><![CDATA[aws glue]]></category>
		<category><![CDATA[ETL]]></category>
		<category><![CDATA[serverless]]></category>

		<guid isPermaLink="false">http://aprakash.wordpress.com/?p=3996</guid>
		<description><![CDATA[AWS Glue is a fully managed ETL service to load large amounts of datasets from various sources for analytics and data processing with Apache Spark ETL jobs. In this post I will discuss the use of AWS Glue Job Bookmarks feature in the following architecture. AWS Glue Job Bookmarks help Glue maintain state information of [&#8230;]]]></description>
<enclosure url="https://2.gravatar.com/avatar/edf349b3b768e9552b9c865916d00691?s=96&#038;d=identicon&#038;r=G" length="0" type="" />
<enclosure url="https://aprakash.files.wordpress.com/2020/05/for_blog.jpg" length="0" type="" />
<enclosure url="https://aprakash.files.wordpress.com/2020/05/screen-shot-2020-04-25-at-1.43.59-am.png?w=1024" length="0" type="" />
<enclosure url="https://aprakash.files.wordpress.com/2020/05/image-1.png?w=1024" length="0" type="" />
		</item>
		<item>
		<title>Video : SQLcl : Format Query Results</title>
		<link>http://orana.info/2020/05/07/video-sqlcl-format-query-results/</link>
		<pubDate>Thu, 07 May 2020 07:05:41 +0000</pubDate>
		<dc:creator><![CDATA[Tim...]]></dc:creator>
				<category><![CDATA[Database Applications Development]]></category>
		<category><![CDATA[Database Management and Performance]]></category>
		<category><![CDATA[format]]></category>
		<category><![CDATA[Oracle]]></category>
		<category><![CDATA[query]]></category>
		<category><![CDATA[results]]></category>
		<category><![CDATA[sqlcl]]></category>
		<category><![CDATA[sqlformat]]></category>
		<category><![CDATA[video]]></category>

		<guid isPermaLink="false">https://oracle-base.com/blog/?p=9807</guid>
		<description><![CDATA[In today&#8217;s video we demonstrate how to format query results in SQLcl using query comments and the SQLFORMAT setting. For those of you that prefer to read, the video is based on this article. SQLcl : Format Query Results with the SET SQLFORMAT Command The star of today&#8217;s video is Charles Wilson, who I got [&#8230;]]]></description>
<enclosure url="" length="0" type="" />
		</item>
		<item>
		<title>Understanding RTO &#038; RPO&#8230;.</title>
		<link>http://orana.info/2020/05/06/understanding-rto-rpo/</link>
		<pubDate>Thu, 07 May 2020 04:42:20 +0000</pubDate>
		<dc:creator><![CDATA[AristaDBA&#039;s Oracle Blog….]]></dc:creator>
				<category><![CDATA[Database Applications Development]]></category>
		<category><![CDATA[Database Management and Performance]]></category>
		<category><![CDATA[genernal]]></category>

		<guid isPermaLink="false">http://blog.aristadba.com/?p=593</guid>
		<description><![CDATA[Disaster recovery is one of the most critical aspects to look into when you are designing a system. It becomes even more prominent while architecting a cloud solution. Two key concepts that must be taken into consideration are Recovery Time Objective(RTO) and Recovery Point Objective(RPO). Let&#8217;s understand these in this post.   RTO means how [&#8230;]]]></description>
<enclosure url="" length="0" type="" />
		</item>
		<item>
		<title>Notes on SQL Profiles vs SQL Plan Baselines</title>
		<link>http://orana.info/2020/05/06/notes-on-sql-profiles-vs-sql-plan-baselines/</link>
		<pubDate>Wed, 06 May 2020 22:48:43 +0000</pubDate>
		<dc:creator><![CDATA[mdinh]]></dc:creator>
				<category><![CDATA[Database Applications Development]]></category>
		<category><![CDATA[Database Management and Performance]]></category>
		<category><![CDATA[performance]]></category>

		<guid isPermaLink="false">http://mdinh.wordpress.com/?p=5724</guid>
		<description><![CDATA[It&#8217;s possible to have both SQL Profiles and SQL Plan Baselines. SQL PROFILES    : Adjust Optimizer cardinality estimations SPM BASELINES : Direct SQL to follow specific execution plan Researh on SQL Profiles and SQL Plan Baselines What is the difference between SQL Profiles and SQL Plan Baselines? (June 17, 2017) Nice table comparision between [&#8230;]]]></description>
<enclosure url="https://1.gravatar.com/avatar/4d1ef2bcc7abd1b06749f347bfbc0add?s=96&#038;d=identicon&#038;r=G" length="0" type="" />
		</item>
		<item>
		<title>Oracle 19c Automatic Indexing: Mixing Manual and Automatic Indexes Part II (Stay)</title>
		<link>http://orana.info/2020/05/06/oracle-19c-automatic-indexing-mixing-manual-and-automatic-indexes-part-ii-stay/</link>
		<pubDate>Wed, 06 May 2020 07:49:49 +0000</pubDate>
		<dc:creator><![CDATA[Richard Foote]]></dc:creator>
				<category><![CDATA[Database Applications Development]]></category>
		<category><![CDATA[Database Management and Performance]]></category>
		<category><![CDATA[19c]]></category>
		<category><![CDATA[19c New Features]]></category>
		<category><![CDATA[Add Column To Existing Index]]></category>
		<category><![CDATA[Automatic Indexing]]></category>
		<category><![CDATA[Oracle Indexes]]></category>

		<guid isPermaLink="false">http://richardfoote.wordpress.com/?p=6174</guid>
		<description><![CDATA[&#160; In my previous post, I discussed how Automatic Indexing did not recognise there was already an existing logically equivalent manually created index and so created effectively a redundant Automatic Index. I also discussed previously how Automatic Indexing was clever enough to logically add new columns to existing Automatic Indexes if it determined such a [&#8230;]]]></description>
<enclosure url="https://richardfoote.files.wordpress.com/2020/05/stay-single.jpg" length="0" type="" />
<enclosure url="https://1.gravatar.com/avatar/d665f0bedd1b771fb94defcaae359a7e?s=96&#038;d=identicon&#038;r=G" length="0" type="" />
		</item>
		<item>
		<title>Versioning for your local Vagrant boxes: adding a new box</title>
		<link>http://orana.info/2020/05/05/versioning-for-your-local-vagrant-boxes-adding-a-new-box/</link>
		<pubDate>Tue, 05 May 2020 13:45:59 +0000</pubDate>
		<dc:creator><![CDATA[Martin Bach]]></dc:creator>
				<category><![CDATA[Database Applications Development]]></category>
		<category><![CDATA[Database Management and Performance]]></category>
		<category><![CDATA[automation]]></category>
		<category><![CDATA[linux]]></category>

		<guid isPermaLink="false">http://martincarstenbach.wordpress.com/?p=6411</guid>
		<description><![CDATA[I have been using Vagrant for quite some time now can&#8217;t tell you how much of a productivity boost it has been. All the VMs I have on my laptop are either powered by Vagrant, or feed into the Vagrant workflow. One thing I haven&#8217;t worked out though is how to use versioning outside of [&#8230;]]]></description>
<enclosure url="https://1.gravatar.com/avatar/ac1dc15a1881a84c0bd660ce1e239534?s=96&#038;d=https://1.gravatar.com/avatar/ad516503a11cd5ca435acc9bb6523536?s=96&#038;r=G" length="0" type="" />
		</item>
		<item>
		<title>Execution Plans</title>
		<link>http://orana.info/2020/05/05/execution-plans-5/</link>
		<pubDate>Tue, 05 May 2020 11:36:38 +0000</pubDate>
		<dc:creator><![CDATA[Jonathan Lewis]]></dc:creator>
				<category><![CDATA[Database Applications Development]]></category>
		<category><![CDATA[Database Management and Performance]]></category>
		<category><![CDATA[Execution plans]]></category>
		<category><![CDATA[Oracle]]></category>
		<category><![CDATA[performance]]></category>
		<category><![CDATA[troubleshooting]]></category>
		<category><![CDATA[tuning]]></category>

		<guid isPermaLink="false">http://jonathanlewis.wordpress.com/?p=22424</guid>
		<description><![CDATA[In a comment to a recent post on reading a non-trivial execution someone asked me to repeat the exercise using a plan I had published a few days previously in a post about tweaking the hints in an outline. The query in question involved a number of subqueries and transformations of different types, which means [&#8230;]]]></description>
<enclosure url="https://2.gravatar.com/avatar/54b25954048c9f2599fe1356a254fe84?s=96&#038;d=https://2.gravatar.com/avatar/ad516503a11cd5ca435acc9bb6523536?s=96&#038;r=G" length="0" type="" />
		</item>
		<item>
		<title>Create Student User</title>
		<link>http://orana.info/2020/05/04/create-student-user/</link>
		<pubDate>Tue, 05 May 2020 02:01:54 +0000</pubDate>
		<dc:creator><![CDATA[maclochlainn]]></dc:creator>
				<category><![CDATA[Database Applications Development]]></category>
		<category><![CDATA[Database Management and Performance]]></category>
		<category><![CDATA[Oracle]]></category>
		<category><![CDATA[Oracle 11g]]></category>
		<category><![CDATA[Oracle 12c]]></category>
		<category><![CDATA[Oracle 18c]]></category>
		<category><![CDATA[Oracle DBA]]></category>
		<category><![CDATA[Oracle Developer]]></category>
		<category><![CDATA[PL SQL]]></category>
		<category><![CDATA[SQL]]></category>

		<guid isPermaLink="false">http://blog.mclaughlinsoftware.com/?p=11672</guid>
		<description><![CDATA[It&#8217;s amazing how old some of my students&#8217; computers are. The oldest with least memory are the foreign students. Fortunately, I kept copies of the old Oracle Database 10g XE. I give it to some students who need to run the smallest possible option. Then, again I have students who get emotional about having to [&#8230;]]]></description>
<enclosure url="" length="0" type="" />
		</item>
		<item>
		<title>Installing SnowSQL, Testing and using Auto-Login</title>
		<link>http://orana.info/2020/05/04/installing-snowsql-testing-and-using-auto-login/</link>
		<pubDate>Mon, 04 May 2020 21:46:05 +0000</pubDate>
		<dc:creator><![CDATA[dbasolved]]></dc:creator>
				<category><![CDATA[config file]]></category>
		<category><![CDATA[Database Applications Development]]></category>
		<category><![CDATA[Database Management and Performance]]></category>
		<category><![CDATA[automatic]]></category>
		<category><![CDATA[cloud]]></category>
		<category><![CDATA[config]]></category>
		<category><![CDATA[login]]></category>
		<category><![CDATA[Snowflake]]></category>

		<guid isPermaLink="false">https://www.dbasolved.com/?p=2256</guid>
		<description><![CDATA[SHOUT OUT &#8211; Need to give Danny Bryant (@dbaontap) a huge thanks for taking my call today and setting me on the right path when dealing with Snowflake.  Thanks buddy!!! Today I’ve been reviewing and playing with Snowflake through their developer platform (https://developer.snowflake.com). Getting setup was pretty painless other than having to provide contact information; [&#8230;]]]></description>
<enclosure url="" length="0" type="" />
		</item>
		<item>
		<title>Capture DDL statements in Oracle DB</title>
		<link>http://orana.info/2020/05/03/capture-ddl-statements-in-oracle-db/</link>
		<pubDate>Sun, 03 May 2020 15:38:48 +0000</pubDate>
		<dc:creator><![CDATA[Arun Gupta]]></dc:creator>
				<category><![CDATA[Database Applications Development]]></category>
		<category><![CDATA[Database Management and Performance]]></category>
		<category><![CDATA[articles]]></category>
		<category><![CDATA[Oracle 12c]]></category>

		<guid isPermaLink="false">http://oracle-help.com/?p=7435</guid>
		<description><![CDATA[There are many cases where we need to capture the ddl statements in our production environment where application team have direct access for create or drop any object in the application schema in the production database . What is DDL ?? DDL (Data Definition Language) is a language used by a database management system that allows users to define the database and specify data types, structures [&#8230;]]]></description>
<enclosure url="" length="0" type="" />
		</item>
		<item>
		<title>glogin.sql for Data Guard Environment</title>
		<link>http://orana.info/2020/05/02/glogin-sql-for-data-guard-environment/</link>
		<pubDate>Sat, 02 May 2020 22:19:21 +0000</pubDate>
		<dc:creator><![CDATA[mdinh]]></dc:creator>
				<category><![CDATA[Database Applications Development]]></category>
		<category><![CDATA[Database Management and Performance]]></category>
		<category><![CDATA[dataguard]]></category>

		<guid isPermaLink="false">http://mdinh.wordpress.com/?p=5719</guid>
		<description><![CDATA[I got tired for seeing for db_name vs db_unique_name for sql prompt connecting with sqlplus for Data Guard environment. Update $ORACLE_HOME/sqlplus/admin/glogin.sql column NAME_COL_PLUS_SHOW_PARAM format a40 wrap column VALUE_COL_PLUS_SHOW_PARAM format a80 wrap set lines 200 echo on trimsp on tab off pages 10000 serverout on size 1000000 feedback off verify off term off echo off arraysize [&#8230;]]]></description>
<enclosure url="https://1.gravatar.com/avatar/4d1ef2bcc7abd1b06749f347bfbc0add?s=96&#038;d=identicon&#038;r=G" length="0" type="" />
		</item>
		<item>
		<title>tfactl summary as HTML (really tricky)</title>
		<link>http://orana.info/2020/05/02/tfactl-summary-as-html-really-tricky/</link>
		<pubDate>Sat, 02 May 2020 17:05:54 +0000</pubDate>
		<dc:creator><![CDATA[spa]]></dc:creator>
				<category><![CDATA[Database Applications Development]]></category>
		<category><![CDATA[Database Management and Performance]]></category>
		<category><![CDATA[exadata]]></category>
		<category><![CDATA[TFACTL]]></category>

		<guid isPermaLink="false">http://stefanpanek.wordpress.com/?p=1945</guid>
		<description><![CDATA[I read an interesting article from Michael Schulze, Optiz Consulting in the actual &#8222;Red Stack Magazin / April 2020&#8220;, about Tools for the daily Exadata maintenance but it is not so easy as described. Since some time ago AHF (Autonomous Health Framework) is the tool for checks of any kind on the Exadata. I have [&#8230;]]]></description>
<enclosure url="https://1.gravatar.com/avatar/7c92b689df7cf34f5ffc20242843ff7c?s=96&#038;d=&#038;r=G" length="0" type="" />
<enclosure url="https://stefanpanek.files.wordpress.com/2019/10/bildschirmfoto-2019-10-28-um-19.36.24.png?w=300" length="0" type="" />
<enclosure url="https://stefanpanek.files.wordpress.com/2020/05/bildschirmfoto-2020-05-02-um-18.38.43.png?w=300" length="0" type="" />
		</item>
		<item>
		<title>When To Use dgmgrl / vs dgmgrl sys@tns</title>
		<link>http://orana.info/2020/05/02/when-to-use-dgmgrl-vs-dgmgrl-systns/</link>
		<pubDate>Sat, 02 May 2020 15:41:34 +0000</pubDate>
		<dc:creator><![CDATA[mdinh]]></dc:creator>
				<category><![CDATA[Database Applications Development]]></category>
		<category><![CDATA[Database Management and Performance]]></category>
		<category><![CDATA[12c]]></category>
		<category><![CDATA[dataguard]]></category>
		<category><![CDATA[dgmgrl]]></category>

		<guid isPermaLink="false">http://mdinh.wordpress.com/?p=5711</guid>
		<description><![CDATA[There&#8217;s been discussion on twitter about using dgmgrl / vs dgmgrl sys@tns. For the most part, I typically use dgmgrl sys@tns only for switch over and fail over. Update: Should use dgmgrl sys@tns when there is an update to the database role, i.e. switch over, fail over, convert Even Oracle&#8217;s documentation (Doc ID 278641.1) uses [&#8230;]]]></description>
<enclosure url="https://1.gravatar.com/avatar/4d1ef2bcc7abd1b06749f347bfbc0add?s=96&#038;d=identicon&#038;r=G" length="0" type="" />
		</item>
		<item>
		<title>In-memory opportunities abound</title>
		<link>http://orana.info/2020/05/01/in-memory-opportunities-abound/</link>
		<pubDate>Fri, 01 May 2020 15:30:50 +0000</pubDate>
		<dc:creator><![CDATA[Connor McDonald]]></dc:creator>
				<category><![CDATA[Database Applications Development]]></category>
		<category><![CDATA[Database Management and Performance]]></category>
		<category><![CDATA[19c]]></category>
		<category><![CDATA[20c]]></category>
		<category><![CDATA[Compression]]></category>
		<category><![CDATA[in-memory]]></category>
		<category><![CDATA[Misc]]></category>
		<category><![CDATA[performance]]></category>

		<guid isPermaLink="false">http://connormcdonald.wordpress.com/?p=3082</guid>
		<description><![CDATA[There has always been a bit of a Catch-22 with some of the really cool options in the Oracle Database. You want to explore the value of them, but you don&#8217;t want to draw the ire of any licensing implications of doing so. Of course, you can use XE or a trial version of the [&#8230;]]]></description>
<enclosure url="https://connormcdonald.files.wordpress.com/2020/05/coupon-1828620_1280.jpg" length="0" type="" />
<enclosure url="https://2.gravatar.com/avatar/2903ecfd61caf221b8b8d5df39962891?s=96&#038;d=identicon&#038;r=G" length="0" type="" />
<enclosure url="https://connormcdonald.files.wordpress.com/2020/05/image_thumb.png" length="0" type="" />
<enclosure url="https://connormcdonald.files.wordpress.com/2020/05/wlemoticon-smile.png" length="0" type="" />
		</item>
		<item>
		<title>Execution Plans</title>
		<link>http://orana.info/2020/05/01/execution-plans-4/</link>
		<pubDate>Fri, 01 May 2020 12:58:58 +0000</pubDate>
		<dc:creator><![CDATA[Jonathan Lewis]]></dc:creator>
				<category><![CDATA[Database Applications Development]]></category>
		<category><![CDATA[Database Management and Performance]]></category>
		<category><![CDATA[Oracle]]></category>

		<guid isPermaLink="false">http://jonathanlewis.wordpress.com/?p=22315</guid>
		<description><![CDATA[In previous articles on reading execution plans I&#8217;ve made the point that the optimizer is very &#8220;keen&#8221; to transform complex queries into queries consisting of a single query block and that there&#8217;s a simple &#8220;First Child First (FCF)&#8221; rule for reading the plan for a single query block. I&#8217;ve then pointed out that when the [&#8230;]]]></description>
<enclosure url="https://2.gravatar.com/avatar/54b25954048c9f2599fe1356a254fe84?s=96&#038;d=https://2.gravatar.com/avatar/ad516503a11cd5ca435acc9bb6523536?s=96&#038;r=G" length="0" type="" />
		</item>
		<item>
		<title>Hint hacking</title>
		<link>http://orana.info/2020/05/01/hint-hacking/</link>
		<pubDate>Fri, 01 May 2020 07:49:25 +0000</pubDate>
		<dc:creator><![CDATA[Jonathan Lewis]]></dc:creator>
				<category><![CDATA[Database Applications Development]]></category>
		<category><![CDATA[Database Management and Performance]]></category>
		<category><![CDATA[Execution plans]]></category>
		<category><![CDATA[Hints]]></category>
		<category><![CDATA[Oracle]]></category>

		<guid isPermaLink="false">http://jonathanlewis.wordpress.com/?p=22395</guid>
		<description><![CDATA[How do you work out what hints you need to tweak an execution plan into the shape you want? Here&#8217;s a &#8220;case study&#8221; that&#8217;s been playing out over a few weeks on the Oracle Developer Community (here and here) and most recently ended up (in one of its versions) as a comment on one of [&#8230;]]]></description>
<enclosure url="https://2.gravatar.com/avatar/54b25954048c9f2599fe1356a254fe84?s=96&#038;d=https://2.gravatar.com/avatar/ad516503a11cd5ca435acc9bb6523536?s=96&#038;r=G" length="0" type="" />
		</item>
		<item>
		<title>Oracle Tidbits – April 2020 #OraTidbit</title>
		<link>http://orana.info/2020/04/30/oracle-tidbits-april-2020-oratidbit/</link>
		<pubDate>Fri, 01 May 2020 04:17:30 +0000</pubDate>
		<dc:creator><![CDATA[biju.thomas]]></dc:creator>
				<category><![CDATA[Database Applications Development]]></category>
		<category><![CDATA[Database Management and Performance]]></category>
		<category><![CDATA[oratidbit]]></category>
		<category><![CDATA[TidBits]]></category>

		<guid isPermaLink="false">https://bijoos.com/oraclenotes/?p=2567</guid>
		<description><![CDATA[“Oracle *daily* TidBits” (#oratidbit) published on Facebook &#38;Twitter, during weekdays in April 2020. I hope you find these helpful to learn something new or to remind you of its existence and use. #OraTidbit #db20c Oracle Data Guard Broker provides early detection of fast-start failover (FSFO) configuration issues and reports those misconfigurations allowing administrators to take action prior [&#8230;]]]></description>
<enclosure url="" length="0" type="" />
		</item>
		<item>
		<title>12.1 Dataguard Multiple Standby Databases Switchover Using DGMGRL</title>
		<link>http://orana.info/2020/04/30/12-1-dataguard-multiple-standby-databases-switchover-using-dgmgrl/</link>
		<pubDate>Fri, 01 May 2020 02:28:50 +0000</pubDate>
		<dc:creator><![CDATA[mdinh]]></dc:creator>
				<category><![CDATA[Database Applications Development]]></category>
		<category><![CDATA[Database Management and Performance]]></category>
		<category><![CDATA[12c]]></category>
		<category><![CDATA[dataguard]]></category>
		<category><![CDATA[dgmgrl]]></category>

		<guid isPermaLink="false">http://mdinh.wordpress.com/?p=5700</guid>
		<description><![CDATA[Followup from How To Create New Standby Using Active Standby Duplication From Existing Standby There are too many contents to post to blog. Note: 12c = 12.1 and 12.2 Access 12c Dataguard Multiple Standby Databases Switchover Using DGMGRL for more details. Thanks to CrossMyP4th on Twitter about Password file not syncing between primary and standby. As of [&#8230;]]]></description>
<enclosure url="https://1.gravatar.com/avatar/4d1ef2bcc7abd1b06749f347bfbc0add?s=96&#038;d=identicon&#038;r=G" length="0" type="" />
		</item>
		<item>
		<title>Did You Know #35 – New Child Cursor Creation Reason</title>
		<link>http://orana.info/2020/04/30/did-you-know-35-new-child-cursor-creation-reason/</link>
		<pubDate>Thu, 30 Apr 2020 16:06:03 +0000</pubDate>
		<dc:creator><![CDATA[Liron Amitzi]]></dc:creator>
				<category><![CDATA[Database Applications Development]]></category>
		<category><![CDATA[Database Management and Performance]]></category>
		<category><![CDATA[database tuning]]></category>
		<category><![CDATA[Did you know]]></category>
		<category><![CDATA[parse]]></category>
		<category><![CDATA[performance]]></category>
		<category><![CDATA[SQL]]></category>
		<category><![CDATA[SQL tuning]]></category>
		<category><![CDATA[troubleshooting]]></category>

		<guid isPermaLink="false">https://gotodba.com/?p=9571</guid>
		<description><![CDATA[In many cases we see a new child cursor for existing SQL. You can see the children and their information in V$SQL (where CHILD_NUMBER identifies the child). To see the child execution plan, use the DBMS_XPLAN package: SELECT * FROM TABLE(DBMS_XPLAN.DISPLAY_CURSOR('&#60;SQL_ID&#62;',&#60;CHILD_NUMBER&#62;)); However, sometimes we want to know why Oracle has created the new child. This [&#8230;]]]></description>
<enclosure url="" length="0" type="" />
		</item>
		<item>
		<title>Oracle Autonomous Database Cloud 2019 Specialist : My Thoughts</title>
		<link>http://orana.info/2020/04/30/oracle-autonomous-database-cloud-2019-specialist-my-thoughts/</link>
		<pubDate>Thu, 30 Apr 2020 07:14:26 +0000</pubDate>
		<dc:creator><![CDATA[Tim...]]></dc:creator>
				<category><![CDATA[Database Applications Development]]></category>
		<category><![CDATA[Database Management and Performance]]></category>
		<category><![CDATA[Misc]]></category>

		<guid isPermaLink="false">https://oracle-base.com/blog/?p=9796</guid>
		<description><![CDATA[You&#8217;ve probably heard that Oracle have made some training and certifications free in recent times (here). We are approaching the end of that period now. Only about 15 more days to go. Initially I thought I might try and do all the certifications, but other factors got in the way, so I just decided to [&#8230;]]]></description>
<enclosure url="" length="0" type="" />
		</item>
		<item>
		<title>Adding columns to external tables…idiocy?</title>
		<link>http://orana.info/2020/04/29/adding-columns-to-external-tablesidiocy/</link>
		<pubDate>Thu, 30 Apr 2020 03:04:27 +0000</pubDate>
		<dc:creator><![CDATA[Connor McDonald]]></dc:creator>
				<category><![CDATA[Database Applications Development]]></category>
		<category><![CDATA[Database Management and Performance]]></category>
		<category><![CDATA[19c]]></category>
		<category><![CDATA[External Table]]></category>
		<category><![CDATA[hybrid]]></category>
		<category><![CDATA[Misc]]></category>
		<category><![CDATA[partitioning]]></category>

		<guid isPermaLink="false">http://connormcdonald.wordpress.com/?p=3065</guid>
		<description><![CDATA[Let me start with the idiotic part first. That part would be&#8230;. me! I&#8217;ll create an external table which reads some customer sales data from a flat file. SQL&#62; create table sales_ext 2 ( 3 cust_id varchar2(10) not null, 4 product_id int not null, 5 amt number, 6 dte date 7 ) 8 organization external [&#8230;]]]></description>
<enclosure url="https://connormcdonald.files.wordpress.com/2020/04/spider-2913761_960_720.jpg" length="0" type="" />
<enclosure url="https://2.gravatar.com/avatar/2903ecfd61caf221b8b8d5df39962891?s=96&#038;d=identicon&#038;r=G" length="0" type="" />
<enclosure url="https://connormcdonald.files.wordpress.com/2020/04/wlemoticon-smile-1.png" length="0" type="" />
		</item>
		<item>
		<title>A (Not So) Brief But (Very) Accurate History of PL/SQL</title>
		<link>http://orana.info/2020/04/29/a-not-so-brief-but-very-accurate-history-of-pl-sql/</link>
		<pubDate>Wed, 29 Apr 2020 22:29:03 +0000</pubDate>
		<dc:creator><![CDATA[Oracle Internals]]></dc:creator>
				<category><![CDATA[Database Applications Development]]></category>
		<category><![CDATA[Database Management and Performance]]></category>
		<category><![CDATA[databases]]></category>
		<category><![CDATA[PL SQL]]></category>

		<guid isPermaLink="false">http://oracle-internals.com/blog/?p=261</guid>
		<description><![CDATA[Preface PL/SQL is one of the&#160;top twenty programming languages&#160;in the world. While I&#8217;m no&#160;Matthew Symonds, and this is no&#160;Softwar, the history of PL/SQL deserves a helluva lot more than, &#8220;Oracle 7 had an advanced architecture and, like Sybase, was fully programmable via its elegant new PL/SQL programming language.&#8221; That&#8217;s why, during the process working on [&#8230;]]]></description>
<enclosure url="" length="0" type="" />
		</item>
		<item>
		<title>AutoUpgrade What I Did Not Know</title>
		<link>http://orana.info/2020/04/29/autoupgrade-what-i-did-not-know/</link>
		<pubDate>Wed, 29 Apr 2020 17:51:22 +0000</pubDate>
		<dc:creator><![CDATA[mdinh]]></dc:creator>
				<category><![CDATA[Database Applications Development]]></category>
		<category><![CDATA[Database Management and Performance]]></category>
		<category><![CDATA[Upgrade]]></category>

		<guid isPermaLink="false">http://mdinh.wordpress.com/?p=5682</guid>
		<description><![CDATA[Deploy and Upgrade Postupgrade Checks and Fixes After an upgrade completes with either Deploy or Upgrade modes, AutoUpgrade performs postupgrade checks. It provides a process where you can enable your custom scripts to be run on each of the upgraded databases, in accordance with the configuration instructions you provide in the AutoUpgrade configuration file, and [&#8230;]]]></description>
<enclosure url="https://1.gravatar.com/avatar/4d1ef2bcc7abd1b06749f347bfbc0add?s=96&#038;d=identicon&#038;r=G" length="0" type="" />
		</item>
		<item>
		<title>Update on creating wallet</title>
		<link>http://orana.info/2020/04/29/update-on-creating-wallet/</link>
		<pubDate>Wed, 29 Apr 2020 13:00:56 +0000</pubDate>
		<dc:creator><![CDATA[mathias]]></dc:creator>
				<category><![CDATA[Database Applications Development]]></category>
		<category><![CDATA[Database Management and Performance]]></category>
		<category><![CDATA[Wallet]]></category>

		<guid isPermaLink="false">http://oradbdev.mathiasmagnusson.com/?p=1208</guid>
		<description><![CDATA[I held a live stream for SWEOUG that presented what my last two blogs covered. It was my first ever and while it was a bit uncomfortable to set up to not see your audience it worked well. In fact it was really enjoyable and I look forward to doing more. In the stream Ilmar Kerm made [&#8230;]]]></description>
<enclosure url="" length="0" type="" />
		</item>
		<item>
		<title>Execution Plans</title>
		<link>http://orana.info/2020/04/29/execution-plans-3/</link>
		<pubDate>Wed, 29 Apr 2020 12:52:49 +0000</pubDate>
		<dc:creator><![CDATA[Jonathan Lewis]]></dc:creator>
				<category><![CDATA[Database Applications Development]]></category>
		<category><![CDATA[Database Management and Performance]]></category>
		<category><![CDATA[Execution plans]]></category>
		<category><![CDATA[Hints]]></category>
		<category><![CDATA[Oracle]]></category>

		<guid isPermaLink="false">http://jonathanlewis.wordpress.com/?p=22363</guid>
		<description><![CDATA[A couple of days ago I discussed an execution plan that displayed some variation in the way it handled subqueries and even threw in a little deception by displaying an anti-join that was the result of transforming a &#8220;not exists&#8221; subquery and a semi-join that looked at first sight as if it were going to [&#8230;]]]></description>
<enclosure url="https://2.gravatar.com/avatar/54b25954048c9f2599fe1356a254fe84?s=96&#038;d=https://2.gravatar.com/avatar/ad516503a11cd5ca435acc9bb6523536?s=96&#038;r=G" length="0" type="" />
		</item>
		<item>
		<title>The Unsung Hero Support of WFH, Our Pets</title>
		<link>http://orana.info/2020/04/27/the-unsung-hero-support-of-wfh-our-pets/</link>
		<pubDate>Mon, 27 Apr 2020 21:13:58 +0000</pubDate>
		<dc:creator><![CDATA[dbakevlar]]></dc:creator>
				<category><![CDATA[Database Applications Development]]></category>
		<category><![CDATA[Database Management and Performance]]></category>
		<category><![CDATA[Pets]]></category>
		<category><![CDATA[WFH]]></category>
		<category><![CDATA[DBA Life]]></category>
		<category><![CDATA[microsoft]]></category>

		<guid isPermaLink="false">https://dbakevlar.com/?p=9258</guid>
		<description><![CDATA[A week ago, Friday was my 13 year-old Cattle Dog/Jack Russell mix, DaVinci’s time to go to doggo heaven.  He was a great flurry of tri-color energy, wrapped up in a small package.                                     DaVinci at 4 Yrs [&#8230;]]]></description>
<enclosure url="" length="0" type="" />
		</item>
		<item>
		<title>The Oracle database museum: running old versions of the Oracle database</title>
		<link>http://orana.info/2020/04/27/the-oracle-database-museum-running-old-versions-of-the-oracle-database/</link>
		<pubDate>Mon, 27 Apr 2020 18:09:30 +0000</pubDate>
		<dc:creator><![CDATA[Frits Hoogland]]></dc:creator>
				<category><![CDATA[ancient]]></category>
		<category><![CDATA[classic versions]]></category>
		<category><![CDATA[Database Applications Development]]></category>
		<category><![CDATA[Database Management and Performance]]></category>
		<category><![CDATA[old]]></category>
		<category><![CDATA[database]]></category>
		<category><![CDATA[History]]></category>
		<category><![CDATA[linux]]></category>
		<category><![CDATA[Oracle]]></category>
		<category><![CDATA[Oracle EE]]></category>

		<guid isPermaLink="false">http://fritshoogland.wordpress.com/?p=2718</guid>
		<description><![CDATA[All Oracle database professionals know the current versions of the Oracle database (12.2, 18, 19, 20 at the moment of writing), and we also know the pace Oracle corporation keeps is so high that a lot of companies are having a hard time keeping up with the current versions. A prominent one is Oracle corporation [&#8230;]]]></description>
<enclosure url="https://2.gravatar.com/avatar/ef533d5ad1a803c04c522ea834c78052?s=96&#038;d=identicon&#038;r=G" length="0" type="" />
		</item>
		<item>
		<title>Fresh install: Autonomous Health Framework for single instance Oracle 19c</title>
		<link>http://orana.info/2020/04/27/fresh-install-autonomous-health-framework-for-single-instance-oracle-19c/</link>
		<pubDate>Mon, 27 Apr 2020 15:38:36 +0000</pubDate>
		<dc:creator><![CDATA[Martin Bach]]></dc:creator>
				<category><![CDATA[AHF]]></category>
		<category><![CDATA[Database Applications Development]]></category>
		<category><![CDATA[Database Management and Performance]]></category>
		<category><![CDATA[19c]]></category>
		<category><![CDATA[linux]]></category>

		<guid isPermaLink="false">http://martincarstenbach.wordpress.com/?p=6393</guid>
		<description><![CDATA[I have been deploying Tracefile Anlyzer (TFA) to every system I&#8217;m looking after, whenever possible. Going back in the history of this weblog I created quite a few posts about how you can do so, too. When writing these posts back in 2018, TFA was available on its own. In the meantime TFA has been [&#8230;]]]></description>
<enclosure url="https://1.gravatar.com/avatar/ac1dc15a1881a84c0bd660ce1e239534?s=96&#038;d=https://1.gravatar.com/avatar/ad516503a11cd5ca435acc9bb6523536?s=96&#038;r=G" length="0" type="" />
		</item>
		<item>
		<title>Extended Support Fee Waiver for Oracle Database 12.1 and 11.2 for Oracle E-Business Suite</title>
		<link>http://orana.info/2020/04/27/extended-support-fee-waiver-for-oracle-database-12-1-and-11-2-for-oracle-e-business-suite/</link>
		<pubDate>Mon, 27 Apr 2020 11:14:01 +0000</pubDate>
		<dc:creator><![CDATA[Mohamed Azar]]></dc:creator>
				<category><![CDATA[Database Applications Development]]></category>
		<category><![CDATA[Database Management and Performance]]></category>
		<category><![CDATA[EBS]]></category>

		<guid isPermaLink="false">http://mohamedazar.com/?p=2532</guid>
		<description><![CDATA[refer : https://blogs.oracle.com/ebs/extended-support-fee-waiver-for-oracle-database-121-and-112-for-oracle-e-business-suite &#160;]]></description>
<enclosure url="https://1.gravatar.com/avatar/7f2d7d8ad4e62707d0d8d7778792ba7f?s=96&#038;d=https://s0.wp.com/i/mu.gif&#038;r=G" length="0" type="" />
		</item>
		<item>
		<title>Execution Plans</title>
		<link>http://orana.info/2020/04/27/execution-plans-2/</link>
		<pubDate>Mon, 27 Apr 2020 10:57:10 +0000</pubDate>
		<dc:creator><![CDATA[Jonathan Lewis]]></dc:creator>
				<category><![CDATA[Database Applications Development]]></category>
		<category><![CDATA[Database Management and Performance]]></category>
		<category><![CDATA[Execution plans]]></category>
		<category><![CDATA[Oracle]]></category>

		<guid isPermaLink="false">http://jonathanlewis.wordpress.com/?p=22279</guid>
		<description><![CDATA[In a recent blog note I made the point that there is a very simple rule (&#8220;first child first&#8221;) for reading execution plans if the query (as written or after transformation by the optimizer) consists of a single &#8220;query block&#8221;. However, if you have a plan that is reporting multiple query blocks you have to [&#8230;]]]></description>
<enclosure url="https://2.gravatar.com/avatar/54b25954048c9f2599fe1356a254fe84?s=96&#038;d=https://2.gravatar.com/avatar/ad516503a11cd5ca435acc9bb6523536?s=96&#038;r=G" length="0" type="" />
		</item>
		<item>
		<title>Video : View Expansion : DBMS_UTILITY.EXPAND_SQL_TEXT</title>
		<link>http://orana.info/2020/04/27/video-view-expansion-dbms_utility-expand_sql_text/</link>
		<pubDate>Mon, 27 Apr 2020 07:30:22 +0000</pubDate>
		<dc:creator><![CDATA[Tim...]]></dc:creator>
				<category><![CDATA[Database Applications Development]]></category>
		<category><![CDATA[Database Management and Performance]]></category>
		<category><![CDATA[expand_sql_text]]></category>
		<category><![CDATA[DBMS_UTILITY]]></category>
		<category><![CDATA[Oracle]]></category>
		<category><![CDATA[video]]></category>

		<guid isPermaLink="false">https://oracle-base.com/blog/?p=9793</guid>
		<description><![CDATA[Today&#8217;s video demonstrates how to expand SQL references to views using the DBMS_UTILITY.EXPAND_SQL_TEXT procedure. This functionality was introduced in Oracle 12.1. The video was based on this article. DBMS_UTILITY.EXPAND_SQL_TEXT : Expand SQL References to Views in Oracle Database 12c Release 1 (12.1) The stars of today&#8217;s video are Sanjay Kumar, Baljeet Bhasin and Jagjeet Singh, [&#8230;]]]></description>
<enclosure url="" length="0" type="" />
		</item>
		<item>
		<title>What’s new with Oracle database 19.7 versus 19.6</title>
		<link>http://orana.info/2020/04/24/whats-new-with-oracle-database-19-7-versus-19-6/</link>
		<pubDate>Fri, 24 Apr 2020 15:50:23 +0000</pubDate>
		<dc:creator><![CDATA[Frits Hoogland]]></dc:creator>
				<category><![CDATA[Database Applications Development]]></category>
		<category><![CDATA[Database Management and Performance]]></category>
		<category><![CDATA[exadata]]></category>
		<category><![CDATA[Oracle]]></category>
		<category><![CDATA[Oracle EE]]></category>
		<category><![CDATA[oracle-xe]]></category>

		<guid isPermaLink="false">http://fritshoogland.wordpress.com/?p=2705</guid>
		<description><![CDATA[This blogpost takes a look at the technical differences between Oracle database 19 PSU 6 (january 2020) and 7 (april 2020). This gives technical specialists an idea of the differences, and gives them the ability to assess if the PSU impacts anything. Functions code symbol names unique in version 19.6 versus 19.7 (top 5) keb [&#8230;]]]></description>
<enclosure url="https://2.gravatar.com/avatar/ef533d5ad1a803c04c522ea834c78052?s=96&#038;d=identicon&#038;r=G" length="0" type="" />
		</item>
		<item>
		<title>Friday Philosophy: The Intersecting Worlds Around Oracle</title>
		<link>http://orana.info/2020/04/24/friday-philosophy-the-intersecting-worlds-around-oracle/</link>
		<pubDate>Fri, 24 Apr 2020 14:09:24 +0000</pubDate>
		<dc:creator><![CDATA[mwidlake]]></dc:creator>
				<category><![CDATA[Database Applications Development]]></category>
		<category><![CDATA[Database Management and Performance]]></category>
		<category><![CDATA[behaviour]]></category>
		<category><![CDATA[conference]]></category>
		<category><![CDATA[Friday Philosophy]]></category>
		<category><![CDATA[humour]]></category>
		<category><![CDATA[private]]></category>
		<category><![CDATA[user group]]></category>
		<category><![CDATA[User Groups]]></category>

		<guid isPermaLink="false">http://mwidlake.wordpress.com/?p=3699</guid>
		<description><![CDATA[Some of you may have noticed something about the Oracle Community: How certain other aspects of human nature, factors, and outside activities are unusually common.  An abiding love of the works of Douglas Adams (If you have never read &#8220;The Hitch Hikers Guide To The Galaxy&#8221; you should question if you are right for this [&#8230;]]]></description>
<enclosure url="https://1.gravatar.com/avatar/71518fe903d8f40e558541c20ae75281?s=96&#038;d=identicon&#038;r=G" length="0" type="" />
<enclosure url="https://mwidlake.files.wordpress.com/2020/04/screenhunter_-384.jpg?w=460" length="0" type="" />
		</item>
		<item>
		<title>Conversion Errors</title>
		<link>http://orana.info/2020/04/24/conversion-errors/</link>
		<pubDate>Fri, 24 Apr 2020 10:03:08 +0000</pubDate>
		<dc:creator><![CDATA[Jonathan Lewis]]></dc:creator>
				<category><![CDATA[Database Applications Development]]></category>
		<category><![CDATA[Database Management and Performance]]></category>
		<category><![CDATA[Oracle]]></category>

		<guid isPermaLink="false">http://jonathanlewis.wordpress.com/?p=22257</guid>
		<description><![CDATA[I&#8217;ve been meaning to write this note for at least three years and was prompted to write up my draft notes this morning as a follow-up to yesterday&#8217;s note on the perils of applying a to_date() function to a date column. But then I took a look at the most recent questions on the Oracle [&#8230;]]]></description>
<enclosure url="https://2.gravatar.com/avatar/54b25954048c9f2599fe1356a254fe84?s=96&#038;d=https://2.gravatar.com/avatar/ad516503a11cd5ca435acc9bb6523536?s=96&#038;r=G" length="0" type="" />
		</item>
	</channel>
</rss>
