DBA가 되고 싶은 병아리

Enterprise Manager and Other Tools Use EM Express Use OUI, DBCA for installation and configuration Basics of Multitenant Container Database (CDB) Identify the benefits of the multitenant container database Explain root and multitenant architecture Configuring and Creating CDBs and PDBs Create and configure a CDB Create and configure a PDB Migrate a non-CDB to a PDB database Managing CDBs and PDB..

Overview of the Automatic Database Diagnostic MonitorWhen problems occur with a database, it is important to perform accurate and timely diagnosis of the problem before making any changes. Often a database administrator (DBA) simply looks at the symptoms and immediately starts changing the system to fix those symptoms. However, an accurate diagnosis of the actual problem in the initial stage sig..

Oracle Database 12c Multitenant shared resource 1. Background Process2. Redo log files3. Memory4. Control files5. Oracle metadata6. Temporary tablespace7. Undo tablespace

This example illustrates online redefinition of a table by adding new columns and adding partitioning.The original table, named emp_redef, is defined in the hr schema as follows: Name Type --------- ---------------------------- EMPNO NUMBER(5) 'hr', tname =>'emp_redef', options_flag => DBMS_REDEFINITION.CONS_USE_PK); END; / Create an interim table hr.int_emp_redef.CREATE TABLE hr.int_emp_redef (..

뉴피쳐를 공부하다보니 이전에 모르던 기능이 있다는 것을 알게되었다. 바로 Database Replay라는 것인데 http://www.dummies.com/how-to/content/basics-of-oracle-12cs-database-replay.html 의 링크를 통해서 간단하게 테스트가 가능하도록 설명이 되어 있었다. https://docs.oracle.com/database/121/RATUG/toc.htm RAC나 OS 업그레이드 등으로 변경되는 사항을 테스팅 하는 내용인듯 한데 확인이 필요할 듯 하다.