E.g: CREATE TABLESPACE securespace DATAFILE ‘/u01/app/oracle/oradata/techdatabasket/secure01.dbf’ SIZE 100M ENCRYPTION USING ‘AES256’ DEFAULT STORAGE(ENCRYPT); VIEWS: V$ENCRYPTED_TABLESPACE DBA_TABLESPACES USER_TABLESPACES Database Administration -> Database Administrator’s Guide -> 13.2.5 Encrypted Tablespaces Oracle Database Administrator’s Guide -> 20 Managing Tables -> 20.2.13 Consider Encrypting Columns That Contain Sensitive Data brunorsHi! I am Bruno, a Brazilian born and bred. Former Oracle ACE, Computer Scientist, MSc in Data Science, over ten years of experience in companies such as IBM, Epico Tech, and Playtech based in three different countries (Brazil, Hungary, and Sweden) and joined projects remotely in…
Day: March 26, 2019
[OCM 12C] Managing additional buffer cache
“The In-Memory Column Store (IM column store) is an optional portion of the system global area (SGA) that stores copies of tables, table partitions, and other database objects. In the IM column store, data is populated by column rather than row as it is in other parts of the SGA, and data is optimized for rapid scans. The IM column store is included with the Oracle Database In-Memory option.” Configure the database to use IM Column Store; (https://www.techdatabasket.com/enabling-oracle-database-in-memory-database-in-memory-option-in-oracle-database-12c-release-1/) Setup some tables to use the IM Column Store; (https://www.techdatabasket.com/enabling-and-disabling-table-for-the-im-column-store-in-oracle-12c/) Datapump from…