One of the real nice new features in Oracle 12c Release 2 (12.2.0.1) is the ability to create an Oracle Data Guard Standby Database using DBCA (Database Configuration Assistant). This really does simplify the process of creating a standby database as well and automates a number of steps in the creation process which were earlier […]
The Oracle Database In-Memory 12c Release 2 New Features webinar conducted last week was well received by a global audience and feedback was positive. For those who missed the session you can download the slide deck from the link below. Feedback and questions are welcomed! 12.2_InMemory_new_features Please follow and like us:
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 […]
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 […]
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 […]
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. […]
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 […]
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 […]
Please follow and like us:
Please follow and like us:
Welcome to WordPress. This is your first post. Edit or delete it, then start blogging! Please follow and like us:
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
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, […]
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, […]
