Oracle database 12c new features

It features new options of 12c

1. ORACLE DATABASE 12c NEW FEATURES PRESENTED BY RIDA ZAMAN RIDA FATIMA ABEER FATIMA SADAF RASHEED 1 MADE BY RIDA ZAMAN

2. What Is Oracle 12c Database? Oracle 12c is a latest version of oracle database Oracle 12c was released on 1 july 2013,here ”c” stands for cloud enabled It features a new multitenant option that helps companies to consolidate database into private or public cloud. 2 MADE BY RIDA ZAMAN

3. Reasons To Upgrade Oracle Database Consolidate your data information with pluggable database Simplifying information life cycle management with data tiering Increase performance across globaly distributed databases with GDS. 3 MADE BY RIDA ZAMAN

4. New Features Of Oracle 12c Database SQL Enhancement Backup and Recovery Database Management Enhancement Oracle Networking Enhancement Oracle Performance Tuning Oracle ASM New Features Oracle RAC New Features 4 MADE BY RIDA ZAMAN

5. 5 Sql enhancement MADE BY RIDA ZAMAN

6. SQL Enhancement( Truncate ) We have a new command TRUNCATE TABLE<TABLE_NAME>CASCADE; through this command we can truncate primary and dependent table data. We can use this command in table partition too 6 MADE BY RIDA ZAMAN

7. SQL Enhancement ( Invisible Column ) We can create invisible column in table Invisible column never shows in select * queries but it shows in results where mention column in select query SQL>CREATE TABLE TEST (TESTNO NUMBER,TNAME VARCHAR(30), T_DEPT NUMBER(2)INVISBLE ); After creating above test table you cant not see t_dept from select * query but we will be able to see it through this query: SELECT T_DEPT FROM TEST 7 MADE BY RIDA ZAMAN

8. Colinvisible command We can also use colinvisible command to show the invisible columns SQL>SET COLINVISIBLE ON 8 MADE BY RIDA ZAMAN

9. SQL Enhancement(Sequence) We can create session level sequence for testing which will be deleted after session log off CREATE SEQUENCE TEST SEQ START WITH 10 INCREAMENT BY 10 SESSION; We can also modify sequence by using alter command: ALTER SEQUENCE TEST_SEQ SESSION ; For removing session parameter: ALTER SEQUENCE TEST_SEQ GLOBAL 9 MADE BY RIDA ZAMAN

10. Extension Of Datatype You can extend data type of VARCHAR2 from 4000 bytes to 32,767 bytes. For using this feature change the initialize parameter MAX_STRING_SIZE=EXTENDED and restart database in upgrade mode, after that you need to execute SQL>@?/RDBMS/ADMIN/UTL32K.SQL 10 MADE BY RIDA ZAMAN

11. Multiple Indexes From oracle database 12c we can create multiple indexes on column This features is available for composite columns and single index both 11 MADE BY RIDA ZAMAN

12. 12 Backup and Recovery MADE BY RIDA ZAMAN

13. Backup and Recovery New backup privilege introduced called SYSBACKUP It means now there is no need to give SYSDBA privilege for performing backup and recovery tasks Sample command is following: $./rman target ”rman/rman as SYSBACKUP” 13 MADE BY RIDA ZAMAN

14. Backup and Recovery Real time apply redo log to data guard In previous release of oracle 12c default option was apply redo from archived log files on the standby database In oracle database 12c release , the default configuration is to use real-time apply so that redo is applied directly from the standby redo log file This new feature helps to maintain minimum or zero data loss 14 MADE BY RIDA ZAMAN

15. Backup and Recovery Active DATA GUARD is now accepting DML operations on global temporary tables Active standby database can be open in read only mode Active standby database is now supported DML operations on global temporary tables This feature enhance reporting facility and performance of primary database 15 MADE BY RIDA ZAMAN

16. Backup and Recovery Direct SQL statement execution in RMAN utility now no need of any prefix like”sql” in RMAN command line RMAN>SELECT sid , serial# , status fromv$session; 16 MADE BY RIDA ZAMAN

17. 17 Oracle Networking Enchancement MADE BY RIDA ZAMAN

18. Oracle Networking Enchancement In oracle 12c database, you can restore and recover data file over through net. Means you can restore data file from standby database to primary database vice versa using service option with following command in RMAN 18 MADE BY RIDA ZAMAN

19. 19 Database Management MADE BY RIDA ZAMAN

20. Database Management Now you can move active data file online without copying to another destination as following command ALTER DATABASE MOVE DATAFILE ‘/u01/data/test_tbs01.dbf’ TO ‘/u02/data/test_tbs01.dbf’; you can monitor above ongoing process using dynamic data dictionary view V$SESSION_LONGOPS 20 MADE BY RIDA ZAMAN

21. Database Management New feature called PLUGGABLE database and CONTAINER database introduced in oracle 12c Container database contains pluggable database .You can say database in database. Pluggable database plugs in to container database. You can plug in pluggable database into any container database . Single container database contains many pluggable database. 21 MADE BY RIDA ZAMAN

22. Database Management Now you can enable logging mode of every data definition language (DDL).every DDL command will be logged in trace file at operating system disk For enabling this feature ,you should need to enable parameter ENABLE_DDL_LOGGING=TRUE Trace files would be generating in following dictionary $ORACLE_BASE/ diag / rdms /DBNAME/LOG/DDL 22 MADE BY RIDA ZAMAN

23. Database Management You can add table partitions in single SQL command ALTER TABLE test_p ADD PARTITION PARTITION part11 VALUES LESS THAN(120000), PARTITION part12 VALUES LESS THAN(130000); 23 MADE BY RIDA ZAMAN

24. Database Management You can move table partition using following command ALTER TABLE table_name MOVE PARTATION|SUBPARTITION< partition_name >TO tablespace < tablespace_name >; 24 MADE BY RIDA ZAMAN

25. Database Management You can truncate/drop multiple partitions in single DDL command as following ALTER TABLE test_p DROP PARTITIONS part7,part9 ; ALTER TABLE test_p TRUNCATE PARTITIONS part7,part9; 25 MADE BY RIDA ZAMAN

26. Database Management Preupgrade script is now available in oracle 12c database for investigating preupgrade issues to fix Preupgrade script called preupgrd.sql is available in rdbms /admin folder Preupgrade_fixup.sql log file will be generated in $ORACLE_BASE/ cfgtoollogs directory This script helps to investigate of certain issues of upgrade process and we can easily resolve issue using preupgrade_fixupsql This feature can save our time of database upgrade activity 26 MADE BY RIDA ZAMAN

27. 27 THE END MADE BY RIDA ZAMAN