Saturday, June 27, 2020

19c New Features: Same table enabled for both memoptimized read and write


SQL> select memoptimize_read,memoptimize_write from dba_tables where table_name='TEST_FAST_INGEST';

MEMOPTIM MEMOPTIM
-------- --------
ENABLED  ENABLED

SQL> alter table test_fast_ingest no memoptimize for read;

Table altered.


SQL> alter table test_fast_ingest no memoptimize for write;

Table altered.


SQL> select memoptimize_read,memoptimize_write from dba_tables where table_name='TEST_FAST_INGEST';

MEMOPTIM MEMOPTIM
-------- --------
DISABLED DISABLED

SQL> alter table test_fast_ingest memoptimize for read;

Table altered.

SQL> alter table test_fast_ingest memoptimize for write;

Table altered.

SQL> select memoptimize_read,memoptimize_write from dba_tables where table_name='TEST_FAST_INGEST';

MEMOPTIM MEMOPTIM
-------- --------
ENABLED  ENABLED


No comments:

Post a Comment