Oracle Database In-Memory Valuable Features

PS
Sr Quality Engineer at Optum

The solution has a simplicity that makes it very easy to use. 

The scalability is very good. 

View full review »
Jelena Bandic - PeerSpot reviewer
Database Administrator at a government with 10,001+ employees

The automated aspect of this solution is highly valuable, and its current effective performance meets our needs satisfactorily.

View full review »
Yossi Belitasky - PeerSpot reviewer
BI manager at Clarivate Analytics

The solution's most valuable feature is its ability to manage database memory using various methods.

View full review »
Buyer's Guide
Embedded Database
March 2024
Find out what your peers are saying about Oracle, SAP, Progress Software and others in Embedded Database. Updated: March 2024.
765,386 professionals have used our research since 2012.
RU
Senior Consultant at Tata Consultancy

Oracle Database In-Memory is a suite of features that improves performance for real-time analytics and mixed workloads.

View full review »
Md Al-Amin - PeerSpot reviewer
Senior System Analyst at Thakral

The most valuable features of the solution stem from Oracle Real Application Clusters. Oracle Real Application Clusters help our company deal with the missing two-node or three-node clusters. The product helps divide the workload into three nodes, which increases the performance of the tool for more than 5,000 to 7,000 users, who are simultaneously connected to the database. Oracle Real Application Clusters gives users multiple nodes, which helps balance the use of load.

View full review »
PY
IT Consultant at a computer software company with 1,001-5,000 employees

I like Oracle because it is a backward-compatible solution. When I changed from an In-Memory database to a non-In-Memory database, all I had to do was configure and restart. I did not have to change the coding at all. But it takes a bit more time to transform from non-In-Memory into In-Memory when using a MySQL server.

View full review »
Anand-Shah - PeerSpot reviewer
Software Architect at Iskraemeco

Oracle Database In-Memory has a valuable transaction feature. It efficiently handles low-code data and supports read-and-write operations for clustering.

View full review »
MK
Senior Database Consultant at Performing Databases

In recent versions, Oracle implemented storing the In-Memory column store contents in the database, to resurrect the IMCS quicker and in a repeatable way.

View full review »
it_user521652 - PeerSpot reviewer
Senior Oracle Consultant at a retailer with 1,001-5,000 employees

Ours is a DW environment, ETL extracts data from SAP and loads into the reporting database. The DBA objective was optimal performance for both nightly batch and reporting. We used the below features which significantly helped improve he performance.

We used HCC with query high to compress all the fact tables, Interval partition the fact tables with daily partitions.

Most of the financial reports go back to maximum 2 months so we scheduled a stored procedure to load last 60 days partitions in to IN-MEMORY. We have also loaded highly used dimention tables as well in to IN-MEMORY.

Extended stats was the key to performance, we could achieve good performance of the reports by gathering extended stats. Histograms too were helpful, but extended stants and histograms dont go well together. in our testing phase, we had tested and chose the best one. Over the period when data changed, we switch between the two.

DMRM, was another key to make sure all the consumer groups get the required resources.

Forcing the optimizer to use BloomFilters, boosted the performance to a significant extent. We could achieve this by getting rid of quite a few indexes, parallel processing and optimizer statistics.

Tablespaces with NOLOGGING option. The nightly batch process also has a great performance with nologging tablespaces, parallel DML and insert append (direct path load).

Dynamic sampling set to 4 was. This was the value which gave us consistent performance across most of the reporting.

Disabling optimizer_adaptive_features. This feature turned on, flickered the performance of the reports. We could achieve consistent performance by turning this off.

Cognos Dynamic Cubing, This is a feature used at the cognos layer which helped increase the performance of the reports.

View full review »
Paresh-Nayak - PeerSpot reviewer
Enterprise Data Architect at Link Group (LNK), Digital Solutions

The most valuable feature is that Database In-Memory is more consistent and faster than traditional databases as it requires fewer CPUs to process instructions. Another valuable feature is that we can zero data loss with this solution because there is no data loss when there is a loss of power or the RAM crashes, as with traditional databases.

View full review »
it_user452352 - PeerSpot reviewer
Strategic Solutions Architect at OnX Enterprise Solutions

I'm going to be discussing Database In-Memory and Multitenant in Oracle 12c. 

The multitenant features offer some really excellent flexibility, especially for an organization that's looking to consolidate their databases from smaller servers, especially smaller servers, possibly to desiloize, as I like to say, and bring their databases up under one larger database instance. It also makes it really easy to clone a database, either for read-only purposes or for read/write purposes extremely quickly, usually in less than a few seconds.

Database In-Memory, to me, is the most compelling reason to go to Oracle 12c, release 1. 12.1.0.2 is the beginning release for that. Database In-Memory offers the ability for analytic queries to run extremely quickly because essentially, it's employing what's called the columnar format. We've never had that in Oracle until 12.1.0.2. The idea behind that, especially if you have a table that's really wide and with several hundred million or even billions of rows, you can scan that table and filter it extremely quickly, even in a data warehousing environment, essentially join it extremely quickly from a fact table to multiple dimension tables in unbelievable speed. The idea there is that, because it's in a columnar format instead of a row major format, you can access the data much more quickly, especially if you have a very wide table because you can eliminate a lot of the intervening columns.

View full review »
SG
Solution Architect at ixtel

The warehouse is the solution's most valuable aspect.

The solution is very fast.

View full review »
it_user522219 - PeerSpot reviewer
IT Director at a manufacturing company with 1,001-5,000 employees

Performance. That's probably the number one.

When we use it for OLTP, which is the Online Transaction Processing, the response for the end-user is pretty fast, which is a good thing, especially if the user is looking at a website, the response time is really micro milliseconds as opposed to waiting a few seconds for that page to load.

View full review »
it_user521976 - PeerSpot reviewer
Sr Architect at a insurance company with 1,001-5,000 employees

The most valuable features are the performance and speed.

View full review »
MD
Database Administrator at a energy/utilities company

Normally, every database server uses hard disks. In-Memory has a feature, apart from its database, which is very good. When we start our server, all your data needs loading memory. We can use that. It's a very good feature. I think they added this feature in 2019. We can mount memory in the partition, create partitions in there, and create tablespace from that spot to share. It's a really good feature. We use it a lot.

View full review »
it_user436422 - PeerSpot reviewer
Owner - Consultant at a tech services company with 51-200 employees

Oracle has a lot of features embedded. In my opinion, Oracle In-Memory offers a lot of improvements in database performance specially for data warehouses and analytics workloads. Combined with Exadata, it makes a solution that will deliver the best performance related to the volume of data.

As I’m very involved in database security, I can tell say that Advanced Security Option and Database Vault are most valuable features for me because I can propose them to my customers to deliver the best security options for their databases.

View full review »
JS
Oracle ACE, DBA at Goodus,inc

Overall, it's a very good solution.

The application development is very user-friendly. 

The SQL is great in Oracle. If you use other databases, you often have to find another syntax and develop in other languages.

The user interface is great.

View full review »
it_user521634 - PeerSpot reviewer
PeopleSoft Infrastructure & Operations Manager at City & County of San Francisco

I cannot imagine IT today without Oracle databases. Oracle has basically delivered their data revolution with relational databases and their constant development and innovation going into the cloud.

View full review »
NT
CEO & Board member at Barsa Novin Ray

Security is the most valuable feature. 

View full review »
it_user1209981 - PeerSpot reviewer
Technical Leader at European Commission

The stability of the platform is the most valuable feature. The solution can support large amounts of data once the architecture is in place.

View full review »
it_user522027 - PeerSpot reviewer
Project Director at a university with 1,001-5,000 employees

The Oracle database is easier to program and manage, and is secure. It’s a stable, dependable product. It can handle any size database. Reliability is one of the key features necessary for a database product.

View full review »
PN
Oracle Cloud Infra Architect at Sterlite Technologies Ltd

The most valuable aspects of this solution are:

  • Fast caching
  • Improved database performance
View full review »
it_user119625 - PeerSpot reviewer
Director at a tech vendor with 10,001+ employees

The most valuable features are its real time performance and consistency.

View full review »
it_user436134 - PeerSpot reviewer
Database Consultant at a financial services firm with 1,001-5,000 employees

The most valuable feature of Database In-Memory is that it's really fast. We need very fast transactions that occur in the milliseconds. We've had a lot of traditional solutions that we've had to throw out, losing a lot of money in the process, in deciding to go with Database In-Memory. For us, it's proven to be very fast.

View full review »
Buyer's Guide
Embedded Database
March 2024
Find out what your peers are saying about Oracle, SAP, Progress Software and others in Embedded Database. Updated: March 2024.
765,386 professionals have used our research since 2012.