ORACLE-BASE - Oracle DBA and development articles, scripts, HOWTOs and forums (8i, 9i, 10g, 11g, 12c

Time 2020-11-05 11:03:46

Web Name: ORACLE-BASE - Oracle DBA and development articles, scripts, HOWTOs and forums (8i, 9i, 10g, 11g, 12c

WebSite: http://oracle-base.com

ID:105696

Keywords:

development,and,scripts,oracle,19c,18c,13c,12c,11g,10g,9i,8i,dba,development,art

Description:

Latest Articles Oracle REST Data Services (ORDS) : Database API - Data Pump The Oracle REST Data Services (ORDS) database API allows us to create Data Pump export and import jobs via REST web service calls. Data Pump API for PL/SQL (DBMS_DATAPUMP) The DBMS_DATAPUMP package provides a PL/SQL API, allowing us to define Data Pump operations programmatically. This article provides a few examples to get you started. Oracle REST Data Services (ORDS) : Database API - Setup The Oracle REST Data Services (ORDS) database API allows us to perform some database administration via REST web service calls. This article covers the basic setup. Oracle REST Data Services (ORDS) : Database API - PDB Lifecyle Management The Oracle REST Data Services (ORDS) database API allows us to manage the lifecycle of PDBs via REST web service calls. Multitenant : Dynamic CPU Scaling - Resource Manager Control of CPU using CPU_COUNT and CPU_MIN_COUNT Resource Manager can control CPU usage in PDBs using the CPU_COUNT and CPU_MIN_COUNT parameters. Oracle call this Dynamic CPU Scaling. Oracle Cloud : Autonomous JSON Database (AJD) - Create Service This article provides a run through of creating a new Autonomous JSON Database (AJD) service on the Oracle Cloud. SQLcl : Simple Oracle Document Access (SODA) for SQLcl This article gives an overview of the integration of Simple Oracle Document Access (SODA) in SQLcl. Real-Time Statistics in Oracle Database 19c Oracle database 19c introduced real-time statistics to reduce the chances that stale statistics will adversely affect optimizer decisions when generating execution plans. Liquibase and Source Control : Changes to Scripts Over Time A discussion of how to manage changes to scripts over time with Liquibase. SQL Quarantine in Oracle Database 19c Oracle Database 19c introduced an extension of Runaway Query Management called SQL Quarantine. Oracle Databases and CI/CD Pipelines This article contains a general discussion about how Oracle Databases can fit into CI/CD pipelines. SQLcl : Deploying Oracle Application Express (APEX) Applications using the SQLcl implementation of Liquibase This article demonstrates how to deploy Oracle Application Express (APEX) applications using the SQLcl implementation of Liquibase. Hybrid Partitioned Tables in Oracle Database 19c This article shows how to combine internal and external partitions into a single Hybrid Partitioned Table in Oracle Database 19c. Liquibase : Deploying Oracle Application Express (APEX) Applications This article demonstrates how to deploy Oracle Application Express (APEX) applications using Liquibase. APEX_DATA_PARSER : Convert simple CSV, JSON, XML and XLSX data to rows and columns. The APEX_DATA_PARSER package allows you to easily convert simple CSV, JSON, XML and XLSX data into rows and columns from SQL. Podman : Generate and Play Kubernetes YAML Files Podman can generate Kubernetes YAML files from existing pod definitions, and use the generated YAML files to fire up new pods.

TAGS:development and scripts oracle 19c 18c 13c 12c 11g 10g 9i 8i dba development art

<<< Thank you for your visit >>>

ORACLE-BASE - Oracle DBA and development articles, scripts, HOWTOs and forums (8i, 9i, 10g, 11g, 12c, 13c, 18c, 19c)

Hot Websites