Database Consolidation using Oracle Autonomous Database with fractional OCPU and granular (GB) storage allocation

• 
• 
• 

PrevNext

Oracle Autonomous Database is a self-managing database that delivers end-to-end automation of tasks traditionally performed by DBAs. It is available in two infrastructure choices, Shared Exadata Infrastructure and Dedicated Exadata Infrastructure. With Shared, as the name implies, multiple tenants share the same Exadata machine. With Dedicated, customers have...

Continue reading

What we found: Oracle Analytics COVID-19 analysis

• 
• 

PrevNext

This analysis was conducted in the context of the 2021 Gartner BI Bake-Off. All data used is publicly available, and insights highlighted result from ingesting, preparing, and analyzing that data. This does not represent the opinions of Oracle Corporation and should be used strictly as a demonstration of...

Continue reading

Create Graph Databases with Graph Studio

• 
• 

PrevNext

Graph Studio Now Available with Oracle Autonomous DatabaseGraphs are amazing. You can model data in a new way that lets you understand relationships, discover patterns and anomalies, and classify and analyze connected data. This lets you answer questions such as who the most important customers and suppliers are,...

Continue reading

Simple Oracle Document Access (SODA) for PL/SQL in Oracle Database 18c

• 
• 

PrevNext

This article gives an overview of the Simple Oracle Document Access (SODA) for PL/SQL functionality in Oracle Database 18c.◉ Create a Test Database UserWe need a new database user for our testing.CONN / AS SYSDBAALTER SESSION SET CONTAINER=pdb1;DROP USER sodauser CASCADE;CREATE USER sodauser IDENTIFIED BY sodauser1  DEFAULT TABLESPACE...

Continue reading

LISTAGG DISTINCT in Oracle Database 19c

The LISTAGG function was introduced in Oracle 11gR2 to make string aggregation simpler. In Oracle 12cR2 it was extended to include overflow error handling. Oracle 19c includes the ability to remove duplicates from the LISTAGG results by including the DISTINCT keyword.1. SetupThe examples in this article use the...

Continue reading

Graph Database Use Cases for Financial Services Companies

• 
• 

PrevNext

For as long as financial services companies have existed, criminals have tried to defraud them of their earnings. In today’s world, this game of company-versus-fraudster has become more complicated than ever. Criminals are savvier, more inventive, and more audacious, and financial services firms see their reputation and massive...

Continue reading

Shell Commands From PL/SQL

• 
• 

PrevNext

Using a Java stored procedure it is possible to perform shell commands from PL/SQL.◉ Create the Java Stored ProcedureFirst we need to create the Java class to perform the shell command.CONN test/testCREATE OR REPLACE AND COMPILE JAVA SOURCE NAMED "Host" ASimport java.io.*;public class Host {  public static void...

Continue reading

FTP From PL/SQL

Sometimes it's preferable to trigger FTP jobs directly from PL/SQL rather than rely on CRON or AT. This article contains a brief description of the two methods I use.◉ Shell ScriptThe first method relies on a java stored procedure, described in Shell Commands From PL/SQL, which can be...

Continue reading

Custom Database Software Images now available on Gen2 Exadata Cloud@Customer

• 
• 
• 
• 
• 
• 
• 
• 

PrevNext

We are pleased to announce the General Availability (GA) of custom Database Software Images on Gen 2 Exadata Cloud@Customer. Today, Exadata Cloud@Customer users patch and provision their Oracle Database Homes using standard Oracle published images. With this release, you can create custom Database Software Images by specifying the...

Continue reading