Posts

Showing posts from 2013

Presentation and visual documents of Oracle 12C Database Administration

Guys below are the very good materials  to learn many new features of oracle 12 C....Walk around it and I'm sure you will love it....... click here to access the presentation material. Below are some important links relevant to this subject: Installing Oracle Database Software and Creating a Database : https://apex.oracle.com/pls/apex/f?p=44785:24:110997252215321:::24:P24_CONTENT_ID,P24_ PROD_SECTION_GRP_ID,P24_PREV_PAGE:6281,,24 Tutorials:- Managing Pluggable Databases using SQL Developer https://apex.oracle.com/pls/apex/f?p=44785:24:0::NO:24:P24_CONTENT_ID, P24_PREV_PAGE:7649,1 Redaction Management in Oracle SQL Developer https://apex.oracle.com/pls/apex/f?p=44785:24:0::NO::P24_CONTENT_ID,P24 _PREV_PAGE:7650,2 Monitoring and Tuning the Database https://apex.oracle.com/pls/apex/f?p=44785:24:0::NO::P24_CONTENT_ID,P24 _PREV_PAGE:6283,2 https://apex.oracle.com/pls/apex/f?p=44785:24:0::NO::P24_CONTENT_ID,P24 _PREV_PAGE:6290,2 You can also download the ...

Oracle 12C database New Features

Pluggable Databases create a container database(root db) and plug many database inside it ..... what's the question in your mind now? why oracle making it so complicated, first create container db then create plugable db? Obviously managing them will require lots of effors... The Benefit whcih we get , all these databases then share the exact same oracle server processes (aka background processes) and memory (Unlike in the previous versions where each database got its own set of background processes and shared memory allocation). Means You will have only one pmon and can create many instance on a single server. Isn't it sounds extraordinary?

ORACLE 12C Database New Features

Online Data-file Move Online Datafile Move is the very helpful technique implemented by oracle corporation in its 12C release.You need not to be worry about taking the tablespace offline to move the datfile... wowla!!!  Lets see how this magic work... SELECT file_id, file_name FROM dba_data_files ORDER BY file_id; FILE_ID FILE_NAME ---------- ---------------------------------------------------------------------- 1 /u01/app/oracle/oradata/cdb1/system01.dbf 3 /u01/app/oracle/oradata/cdb1/sysaux01.dbf 4 /u01/app/oracle/oradata/cdb1/undotbs01.dbf 6 /u01/app/oracle/oradata/cdb1/users01.dbf SQL> ALTER DATABASE MOVE DATAFILE '/u01/app/oracle/oradata/cdb1/system01.dbf' TO '/tmp/system01.dbf'; Database altered. SQL>   SQL> SELECT file_id, file_name FROM dba_data_files WHERE file_id = 1; FILE_ID FILE_NAME ---------- ---------------------------------------------------------------------- 1 /tmp/system01.dbf SQL...