Tagged: Oracle 12c

Oracle Database / Oracle Database 12 c

ORACLE 12C: Dataguard Far Sync

Oracle Dataguard Far Sync instance is a new feature introduced in Oracle Database 12c, which simply works like a archive/redo repeater.. Far sync instance is something different than the Oracle Database instance, as its mission is accepting redo from the primary database and then shipping that redo to other members of the Oracle Data Guard configuration.. Far Sync instance is an instance without a database.. Although; it has controlfile, and capability to read from standby redolog files and write them into its local archive log files, Far Sync instance does not map any database file, in other words, does not...

Oracle Database / Oracle Database 12 c

ORACLE 12 rel.2 – Partitioning new features

In Oracle 12c rel.2 a great number of enhancements to the Oracle database Partitioning option have been introduced. These include: Automatic List Partitioning Filtered Partition maintenance operations Multi-Column List Partitioning Online conversion of non-partitioned to partitioned table Read-only Partitions Partitioned External Tables Automatic List Partitioning: The ability to partition a table based on distinct values in a column has been around since quite some time, but what is new in Oracle database 12.2 is that we can initially partition the table based on values that are known and present in the column we would like to partition the table on....

Oracle Database

Oracle 12c release 2: new features

Oracle introduced the long awaited Database 12c Release 2 earlier this year at OracleOpen World. Oracle just released Oracle Database 12c Release 2 for on-premises Linux and Solaris. Find below an incomplete list of the main new features: 1. Multi-Instance Redo Apply : With Oracle 12c Release 2, you can apply redo logs to multiple instance at the same time to improve recovery time objective. 2. Oracle Database Sharding : With Oracle 12c Release 2, you can horizontally partitioned data across many databases and present them as a single logical database to application. 3. Creating Data Guard Standbys With Database Creation Assistant : You...

Oracle Database / Oracle Database 12 c

Oracle12C : Database Firewall

The Oracle Database Firewall enables organizations to protect their databases from internal and external attacks. Oracle Database Firewall allows unauthorised SQL traffic on the network to be monitored and blocked before reaching the database. Database Firewall for Security and Compliance Oracle Database Firewall monitors and enforces normal application behavior in order to avoid the increasingly sophisticated Data Centre attacks that can lead to unauthorised external access. The security control of Oracle Database Firewall helps to prevent malicious activity such as SQL injection and application bypass from reaching the database. Next-Generation Network-based Database Security The grammar of the SQL statements being...

Oracle Database / Oracle Database 12 c

ORACLE 12C : Extended Data Type

With the previous Oracle database release, long characters strings of more then 4000 bytes had to be handled using CLOB or LONG data types. Starting from Oracle 12c was introduced a new system parameter: MAX_STRING_SIZE. This parameter allows string data types to be much larger when the parameter is changed from its default value STANDARD to EXTENDED. New higher limits (in bytes) are available for following types: – VARCHAR2 – 32767 bytes – NVARCHAR – 32767 bytes – RAW – 32767 bytes To use extended version you need to set new initialization parameter MAX_STRING_SIZE and run sql script utl32k.sql. Set...

Oracle Database 12 c

ORACLE 12C : approx_count_distinct parameter

The APPROX_COUNT_DISTINCT function was added, but not documented, in Oracle 11g to improve the speed of calculating the number of distinct values when gathering statistics using the DBMS_STATS package. Oracle database 12c (12.1.0.2) now includes the function in the documentation, so we are free to use it in our applications as a supported SQL function. It returns approximate number of rows that contain distinct values of expression. It’s alternative to the COUNT (DISTINCT expr) function, which returns the exact number of rows that contain distinct values of expr. For processing large amounts of data it’s significantly faster than COUNT, with...

Oracle Database 12 c

New Feature IDENTITY Columns

In Oracle 12c when we create a table we can populate a column automatically via a system generated sequence by using the GENERATED AS ++ clause in the CREATE TABLE statement. We can use GENERATED AS IDENTITY with the ALWAYS, DEFAULT or DEFAULT ON NULL keywords and that will affect the way or when the identity column value is populated. By default the GENERATED AS IDENTITY clause implicitly includes the ALWAYS keyword i.e GENERATED ALWAYS AS IDENTITY. When the ALWAYS keyword is specified it is not possible to explicitly include values for the identity column in INSERT OR UPDATE SQL...

Oracle Database 12 c

Oracle 12c: Move datafile feature

Until the release 11g move a datafile was an operation very problematic; We had to put the tablespace offline, copy the datafile to the new destination and rename it : SQL> alter database rename datafile “A” to “B”; From Oracle release Oracle 12c, you can move a datafile from a mount point to another without having to put the tablespace offline . All this is done while the database is active. So with the command: alter database     move datafile     ‘/u01/app/oracle/oradata/FILE.dbf’  to     ‘/u02/app/oracle/oradata/ORADB12/FILE.dbf’; It is also possible to move a datafile from specific number that Oracle has assigned...

Oracle Database 12 c

ORACLE 12c – NAS new evolution

Oracle has announced the latest generation of Network-attached Storage or NAS system namely the Oracle ZFS Storage ZS4-4. ZFS Storage ZS4-4 doubles the performance over the previous version , allowing you to access the information they need to make strategic decisions for their business even more quickly . Oracle ZFS Storage ZS4-4 also provides a high-performance protection against breaches of security with detailed , simple and convenient encryption capabilities . SOME benefits: It reduces the volume of the storage, the complexity and cost; compresses data 10x to 50x and improves performance on average 5X Reduces manual setup and tuning of...

Oracle Database 12 c

Oracle 12c : New Feature – Privilege Analysis

In a common situation present in many database we find that some users have been granted more privileges than what was needed and these privileges , over time , have remained . This could be dangerous to the security of the data and the database itself . In Oracle 12c we have a package called DBMS_PRIVLEGE_CAPTURE through which we are able to identify the object privileges and unnecessary system that have been granted and revoke privileges that have not been used . The analysis of the privileges can be done at the database level , on a single role or...