Oracle Tidbits – February 2019 #oratidbit

“Oracle *daily* TidBits” (#oratidbit) published on Facebook & Twitter, during weekdays in February 2019. Hope you find these helpful to learn something new or to remind you of its existence and use. #oratidbit In Oracle Database 18c, RMAN can recover a standby database using “FROM SERVICE” to perform an Active Data Guard synchronization and refresh the standby …

Oracle Tidbits – January 2019 #oratidbit

“Oracle *daily* TidBits” (#oratidbit) published on Facebook, Twitter, and Google+ during weekdays in January 2019. Hope you find these helpful to learn something new or to remind you of its existence and use. #oratidbit #goldengate Oracle Database 18c and later support replication of identity columns using Golden Gate. It requires usage of the Integrated Extract and Integrated Replicat or Integrated Parallel …

Oracle Tidbits – December 2018 #oratidbit

“Oracle *daily* TidBits” (#oratidbit) published on  Facebook, Twitter, and Google+ during weekdays in December 2018. The list is short as there were no #oratidbit during the Christmas holidays. Hope you find these helpful to learn something new or to remind you of its existence and use. HAPPY NEW YEAR 2019! #oratidbit #orcldb When you move the online data file using ALTER …

Oracle Tidbits – November 2018 #oratidbit

“Oracle *daily* TidBits” (#oratidbit) published on  Facebook, Twitter, and Google+ during weekdays in November 2018. Hope you find these helpful to learn something new or to remind you of its existence and use. #oratidbit #oraclecloud DBaaS Cloud Service Bare Metal is a dedicated instance with Oracle Database 11g, 12c, or 18c, including the multitenant option. Infrastructure ranges from virtual machines with …

Oracle Tidbits – October 2018 #oratidbit

“Oracle *daily* TidBits” (#oratidbit) published on  Facebook, Twitter, and Google+ during weekdays in October 2018. Hope you find these helpful to learn something new or to remind you of its existence and use. #oratidbit #db18c You can convert a conventional disk group (disk group created before Oracle ASM 18c) to an Oracle ASM flex disk group without using the restrictive mount …

ODC Appreciation Day: Two Useful Parameters in 18c #ThanksODC

Happy to be part of the #ThanksODC campaign in 2018. Often I learn something new related to Oracle from a forum or blog or a social media post or an article written by someone who loves to help the Oracle community. The Oracle community has helped me tremendously to do my job better. Kudos to …

Exploring Autonomous Databases – Client Credentials

The wallet zip file from ATP or ADW includes the connection information for all the ATP and ADW databases you have created under the cloud account, even though the credential zip file name is "wallet_.zip".

Exploring Autonomous Database – Init Parameters

ATP has a minimum number of initialization parameters configured, whereas ADW has several initialization parameters. Though my ATP and ADW databases are both 1 oCPU / 1 TB size, the SGA and PGA values are different. ADW has a bigger PGA, ATP has bigger SGA.

Exploring Autonomous Database – The CDB

Each instance of the ADW and ATP is a pluggable database. It appears that at the CDB level, both ATP and ADW have the same configuration. The differences are only in the PDB.

Oracle Tidbits – September 2018 #oratidbit

Oracle Tidbits #oratidbit are little technical nuggets related to Oracle technology. Published daily on Biju's Twitter / Facebook / Google+.