Edition Based Redifinition - The key to online application upgrade
Download the demo EBR zip file
Posts
DBMS_PARALLEL_EXECUTE - base table to be broken down into smaller chunks which can be run in parallel
DBMS_PARALLEL_EXECUTE package contains API's to chunk a table into smaller units and execute those chunks in parallel. The DBMS_PARALLEL_EXECUTE package allows a workload associated with a base table to be broken down into smaller chunks which can be run in parallel. This process involves several distinct stages. I was forgotten the power of this " Do-it- yourself (DIY) parallelism by Asktom " now available as package "DBMS_PARALLEL_EXECUTE "since version 11g
Secure External Password Store (SEPS) - keeping the password secret from other users on the client OS.
One of the problem is hard coded oracle passwords in batch scripts executed by schedulers. Often used is using function to get a password from a file located on the system. This file could be encrypted or plain text. With this function it is possible to hide the password in script and on OS platform. Do you know Secure External Password Store
Create Database using dbca result: TNS-04612: Null RHS for service_name
When creating a (cluster) database using DBCA it can result into an error. One of those errors can be TNS-04404, TNS-04414 & TNS-04612 errors. Testing the service with tnsping or sqlplus works fine. TNS-04414: File error caused by: TNS-04612: Null RHS for “service_name”