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