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…
Leggi tutto
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…
Leggi tutto
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…
Leggi tutto
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…
Leggi tutto
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…
Leggi tutto
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.…
Leggi tutto
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…
Leggi tutto
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…
Leggi tutto
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…
Leggi tutto
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…
Leggi tutto
Commenti recenti