Viscosity
logo-black
  • Solutions
    • Database Professional Services
      • Microsoft SQL Server Services
    • Cloud Service and Solutions
      • Viscosity Edge Cloud
      • Hybrid Cloud
      • Public Cloud
    • Application Development
    • Managed Services
      • Engineered Systems
    • Oracle Technology Solutions
  • Resources
    • Case Studies
    • Data Sheets
    • Whitepapers
    • Publications
  • Events
  • Blogs
  • About
    • Clients
    • Partnerships
    • Contact
    • Careers
Contact Us

Oracle Database 12c , DBA

On the Ninth day of 12.2, my DBA gave to me...

By Viscosity North America
April 20, 2022

An In-memory expression, or “hot” expression, enables frequently evaluated query expressions to be materialized in the In-Memory Column Store, for subsequent reuse. By default, the procedure DBMS_INMEMORY_ADMIN.IME_CAPTURE_EXPRESSIONS identifies and populates IM expressions.

Populating the materialized values of frequently used query expressions, into the In-Memory Column Store, greatly reduces the system resources required to execute queries, allowing for better scalability. The procedure, IME_CAPTURE_EXPRESSIONS, will capture and populate the 20 “hottest” expressions in the database for a specified time range.

 

In-Memory Virtual Columns

An IM virtual column, is a value derived by evaluating an expression. IM virtual columns improve query performance by avoiding repeated calculations. Also, the database can scan and filter IM virtual columns, using techniques such as SIMD vector processing.

 

In-Memory FastStart

Before 12.2, the columnar format was only available In-Memory, meaning that after a database restart, the In-Memory Column Store would have to be populated. This multiple step process, converted traditional, row formatted data into the compressed columnar format and placed in-memory.
Now, In-Memory Column Store optimizes the compressed columnar population of database objects (tables, partitions, and subpartitions) in the...

 

[hr width=”1px” color=”#16a085″ style=”dashed”][/hr]

[link_button link=”https://viscosityna.com/resources/dba-resources/twelve-days-12-2/day-9-in-memory/” size=”small” color=”#1CC6DA” align=”left”]Get Full Version[/link_button]

All posts
About Author
Viscosity North America

You might also like
Upgrading To 18c / 19c / 20c: How do I get There?
Upgrading To 18c / 19c / 20c: How do I get There?
April 20, 2022
Upgrading To 18c / 19c / 20c: What Are My Options?
Upgrading To 18c / 19c / 20c: What Are My Options?
April 20, 2022
SUBMIT YOUR COMMENT

Subscribe

Subscribe to our newsletter & stay updated

logo fondo oscuro 2-01
 
Viscosity is a recognized niche Oracle and Microsoft consulting firm providing expertise in cloud, Oracle Exadata, Azure, RAC, Linux, and DBA consulting with near-zero downtime and near-zero risk.
Headquarters
3016 Communications Parkway, Suite 200
Plano TX 75093
Contacts
sales@viscosityna.com
Copyright 2022. All Rights Reserved by Viscosity North America.