Test Post

Test Post Test Post Test Post Test Post Test Post Test Post Test Post Test Post Test Post Test Post Test Post Test Post Test Post Test Post Test Post Test Post .Test Post Test Post Test Post Test Post Test Post Test Post Test Post Test Post Test Post Test Post Test Post Test Post Test Post Test Post Test Post Test Post .Test Post Test Post Test Post Test Post Test Post Test Post Test Post Test Post Test Post Test Post Test Post Test Post Test Post Test Post Test Post Test Post .Test Post Test Post Test Post Test […]

Oracle 12c new feature APPROX_COUNT_DISTINCT and FETCH FIRST ROWS

If we are dealing with large amounts of data and have to use queries to find count of distinct values of some particular column or group of columns, the new 12.1.0.2 feature APPROX_COUNT_DISTINCT function can be significantly faster than using the traditional COUNT (DISTINCT expr) function with marginal differences in the exact result. The examples […]

Oracle 12c 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 IDENTITY 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 […]

Oracle 12c In-Memory Database

While data warehouses do have their own place, most OLTP databases today are still used to run analytical and DSS type queries and workloads to support real-time decision-enabling information requirement which the business has. Designing a database to cater for this hybrid mix of OLTP and DSS workloads presents its own challenges to the DBA. […]

Featured Image Blog Post Example

Not only home variations or demos but fully created sites for you ready to publish on the net. More than 20+ ready to use sites created with research and dedication. Choose the right one and go online in 5 minutes. Specular is the last theme you will ever need to buy. Keep coming back to […]

New Standard Post Example Post

With a staff of 12 members, Codeless will provide the most powerful and real-time support you have ever tried. Our staff members are concentrating in helping our customers to solve and customize their sites. Five of them working everyday to ensure that Specular stays clean, with no bugs and up-to-date. The last and the most […]

Quote Post Type Example Post

Please follow and like us:

Gallery Post Type

Please follow and like us:

Video Post Type

Welcome to WordPress. This is your first post. Edit or delete it, then start blogging! Please follow and like us:

Business Single Post

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Etiam aliquam massa quis mauris sollicitudin commodo venenatis ligula commodo. Sed blandit convallis dignissim. Pellentesque pharetra velit eu velit elementum et convallis erat vulputate. Sed in nulla ut elit mollis posuere. Praesent a felis accumsan neque interdum molestie ut id massa. In hac habitasse platea dictumst. Nulla […]

Standard Single Post

Specular Blog Single Post

Oracle Database 12c New Feature – Data Redaction

Data Redaction is one of the new Advanced Security features introduced in Oracle Database 12c. It basically shields sensitive data from the application end users and this is done on the fly without any modification being done to the application. This is different to Oracle Data Masking where data is transformed using masking formats and […]

Creating an Oracle 12c Data Guard Active Standby Database

This note examines how to create an Oracle 12.1.0 physical standby Active Data Guard database using the RMAN DUPLICATE FROM ACTIVE command. We will be creating the data guard configuration in a 12c Container Database. Remember – in 12c Data Guard is set up at the Container level and not the individual Pluggable database level […]

Oracle 12c New Feature Heat Map and Automatic Data Optimization (ADO) – Part 2

In a previous post Oracle 12c New Feature Heat Map and ADO we had looked at the 12c new feature called Heat Map and ADO (Automatic Data Optimization) and how we were using compression level tiering policy to compress and relocate dormant or less active data to a low cost storage tier. In addition to […]

Oracle 12c New Feature – Heat Map and Automatic Data Optimization

One of the main goals of an ILM (Information Life Cycle) policy is to reduce the cost of storage, improve performance and access times for both current as well as archived data and retain data long enough so as to satisfy regulatory laws and statutes related to data preservation. As data grows rather than buy […]

Oracle 12c New Feature – Temporal Validity

The Temporal Validity feature adds a time dimension to each row in the table consisting of two date-time columns to denote validity of data. Data that is older or no longer valid or not yet valid can be hidden from queries and only active data returned by queries. In case of a very large table, […]

Oracle 12c new feature In-Database Archiving

Very often in our databases we have some very large tables which have a lot of historical and legacy data and the challenge is deciding what is old data and what is current data and even if we do identify the old data we do not need and have moved that data to tape storage, […]

Oracle12c database creation using DBCA

In an earlier post we had discussed the installation process of the Release 12.1 Oracle database software and highlighted a few differences we can get to notice in some of the screens. Let us now look at the creation of an Oracle 12c database using the Database Configuration Assistant DBCA and briefly discuss what is […]

Performing a 32 bit to 64 bit migration using the Transportable Database RMAN feature

This note describes the procedure used to perform a 32 bit to 64 bit conversion of an 11.2.0.3 database on the Linux platform. The RMAN CONVERT DATABASE command is used to automate the movement of an entire database from one platform (the source platform) to another (the destination platform). This is provided that the source […]

Database Administration

Add A Knowledge Base Question !