Oracle Database In Memory provides a unique dual format design that enables tables to be instantaneously represented in memory using traditional row format and a new in memory column format. The Oracle SQL Optimizer by design routes analytic queries to the column format and OLTP queries to the row format, transparently delivering best of both worlds performance. Oracle Database automatically maintains full transactional uniformity between the row and the column formats, just as it maintains uniformity between tables and indexes today. The new column format is a pure in memory format and is not persistent on disk, so there are no additional storage costs or storage synchronization issues.
by Vijay Kumar Tiwari "Oracle in Memory Configuration"
Published in International Journal of Trend in Scientific Research and Development (ijtsrd), ISSN: 2456-6470, Volume-5 | Issue-1 , December 2020,
URL: https://www.ijtsrd.com/papers/ijtsrd38275.pdf
Paper URL : https://www.ijtsrd.com/computer-science/database/38275/oracle-in-memory-configuration/vijay-kumar-tiwari
peerreviewedjournals, reviewpapers, callforpaperhealthscience
No comments:
Post a Comment