AWS Lambda
Description: AWS Lambda is a serverless compute service that runs your code in response to events and automatically manages the ...
Database
Insights and Experiences from Doyensys’ Database Administrators.
Oracle Multitenant in Database 12c Enterprise Edition
Description: Oracle Multitenant – an Oracle Database 12c Enterprise Edition option – introduces a new architecture that enables customers to easily ...
Generate DDL source code using Oracle SQL
Introduction Customer asks us to generate all the DDL source code for some database objects. So I just found the little piece of code to create DDL source. ...
Oracle Always Free cloud services
Databases Our choice of Autonomous Transaction Processing or Autonomous Data Warehouse. 2 databases total, each with 1 OCPU and 20 GB storage. Note:-We ...
RMAN is hung or it is very slow / Clearing RMAN repository / Troubleshoot RMAN-06214 error
This Post describes about RMAN is hung or it is very slow / Clearing RMAN repository / Troubleshoot RMAN-06214 error RMAN> DELETE FORCE NOPROMPT ...
AWS Lambda
Description: AWS Lambda is a serverless compute service that runs your code in response to events and automatically manages the underlying compute resources for you. You ...
Oracle Multitenant in Database 12c Enterprise Edition
Description: Oracle Multitenant – an Oracle Database 12c Enterprise Edition option – introduces a new architecture that enables customers to easily consolidate multiple databases into a ...
Generate DDL source code using Oracle SQL
Introduction Customer asks us to generate all the DDL source code for some database objects. So I just found the little piece of code to create DDL source. Database Objects are, ...
Oracle Always Free cloud services
Databases Our choice of Autonomous Transaction Processing or Autonomous Data Warehouse. 2 databases total, each with 1 OCPU and 20 GB storage. Note:-We need choose Always free while database ...
RMAN is hung or it is very slow / Clearing RMAN repository / Troubleshoot RMAN-06214 error
This Post describes about RMAN is hung or it is very slow / Clearing RMAN repository / Troubleshoot RMAN-06214 error RMAN> DELETE FORCE NOPROMPT OBSOLETE DEVICE TYPE DISK; If error ...
Script to determine the high water mark of tables
TO CHECK THE HIGH WATER MARK LEVEL OF TABLES set verify off col table_name for a20; column owner format a10 column alcblks heading ‘Allocated|Blocks’ just c column usdblks heading ...
ORA-01741: illegal zero-length identifier
Posted by : Saravanan Introduction This Post demonstrates about error ORA-01741 : illegal zero-length identifier Scenario While adding multiple schemas to a single workspace, we get the ...
Installing various Database Components
Posted by : Mahe This Post describes about Installing various Database Components col COMP_ID for a20 col VERSION for a15 col STATUS for a10 col COMP_NAME for a40 select COMP_ID, ...
Oracle Cloud Infrastructure New Feature – Block Volume user-defined backup policies
Oracle introduced new feature/functionality to Oracle cloud infrastructure Block Volume services scheduled backups feature – User defined Backup policies. Using this feature we can create our ...
Configuring APEX to use BI Publisher
Introduction We will see about how to configuring apex to use bi publisher in Details with steps to follow. Steps To Follow To use BI Publisher as your Report Server, first, ...