One of my favourite new features in Oracle Database 12c is the ability to perform partition maintenance operations on multiple partitions. This means we can now add, drop, truncate and merge multiple partitions in one operation, and can split a single partition into more than two partitions also in just (more...)
The following examples use the SUPPLIER2 database schema which is used in the Oracle University OBI EE training courses.
How to handle NULLs in a Pivot Table column
Sometimes you want to be able to display a value in a pivot table column even though there is no value in (more...)
1. Why ?
2. What is it ?
3. How ?
1. Why ?
The main idea of the 'grid' is to share resources, to make better use of storage, CPU and memory. If a database administrator wishes to implement this idea, he or she must consolidate many databases to one database. One of (more...)
ACFS Replication, new features in 188.8.131.52 enables replication of Oracle ACFS file systems across the network to a remote site, providing disaster recovery capability for the file system.
For this demonstration, I used the practice environment provided for the course “Oracle Grid Infrastructure 11g: Manage Clusterware and (more...)
Traffic director is one of the latest load balancer software, released by
In fact its a fast, reliable, scalable and very easy manageable solution, for HTTP, HTTPS, TCP traffic for backend application and HTTP servers.
I have used the latest version of both traffic director, and weblogic 12c, to (more...)