Steps to add ExaCS ExaCC Storage servers in to Oracle Enterprise Manager (OEM)

• 
• 
• 

PrevNext

Introduction:Oracle Enterprise Manager Cloud Control provides a complete cloud lifecycle management solution for Oracle Database Exadata Cloud Service (ExaCS) and Oracle Database Exadata Cloud at Customer (ExaCC). In this Blog, we will see step by step to add ExaCS Storage servers into OEM Monitoring. Same steps are applicable...

Continue reading

Oracle Database 21c (21.3) comes with full production support for Oracle Sharding on Kubernetes and Docker!

We are excited to announce that customers can now take advantage of Kubernetes and Docker based deployment for sharded databases starting with Oracle Database 21c (21.3).Oracle Sharding distributes segments of a data set across many databases (shards) on independent compute resources, on-premises, or in the cloud. It enables...

Continue reading

Announcing a New Sample Schema: Customer Orders

• 
• 

PrevNext

Calling all Oracle Database developers! There's a new sample schema in town!Customer OrdersCustomer Orders is a simple new schema for you to use in your presentations, demos, and blogs.Why Have We Created a New Schema?The current sample schemas (HR, SH, CO, PM, IX, & BI) were created in...

Continue reading

How to split comma separated value strings into rows in Oracle Database

• 
• 
• 
• 

PrevNext

Often you receive a CSV string that you need to convert to rows. To do this with SQL you need to:◉ Generate a row for each value◉ For each row N, extract the value at position N from the string◉ You can do this in Oracle Database with a query...

Continue reading

Free developer resources to help you get started with Oracle Database

• 
• 

PrevNext

Learn SQL with these free coursesOracle Dev Gym has many classes to help you learn Oracle technology. All the classes include a free certificate of completion.Databases for Developers: FoundationsLearn SQL in this FREE 12-part class. It covers the basics of SQL in Oracle Database, teaching you how to:◉...

Continue reading

Is TimesTen an Oracle Database Cache or a System of Record?

• 
• 
• 
• 

PrevNext

IntroductionThere seems to be some confusion on whether the Oracle TimesTen In-Memory Database is a cache or a system of record.I often hear comments like:◉ TimesTen can only be a cache as it has no persistence◉ TimesTen is only a cache for Oracle databases◉ TimesTen should only be used as...

Continue reading

Simplified TimesTen 18.1 Licensing

• 
• 
• 

PrevNext

Based on customer feedback, the Oracle TimesTen 18.1 licensing has been simplified:◉ TimesTen In-Memory Database can now also be used for caching◉ TimesTen Application Tier Database Cache can now also use TimesTen ScaleoutThe complete licensing document for TimesTen 18.1 is here.The relevant portion of the new licensing text is:Oracle TimesTen...

Continue reading