OutOfMemoryError:Java Heap Space on OEM 12c Agent

Sometimes we face issues like OEM agent 12c crashed and found the below error messages on gcagent.log[/agent_inst/sysman/log/gcagent.log]. Cause: When an OEM agent collects metrics data, it uses java memory. If it does not have access to the required amount of java memory which is specified in the configuration, the OEM agent may crash. Solution: 1- […]

Read More

Exchange Subpartition in Oracle

We can exchange subpartition in oracle the same way we exchange partition.Let’s see few examples. 1.Exchange subpartition of *-Hash partitioned table : Here I took example of List-Hash Partitioning method. 2.Exchange subpartition of *-Range Partitioned table : Here I took example of List-Range partitioning method. 3.Exchange subpartition of *-List partitioned table : Here I took […]

Read More

Exchange Partition of *-List and *-Range Partition

1.Exchange Partition of *-List Partition Here I took example of Range-List partitioning method. 2.Exchange Partition of *-Range Partitioned table : Here I took example of Range-Range partitioning method. Thank you for giving your valuable time to read the above information. If you want to be updated with all our articles send us the Invitation or […]

Read More

Exchanging a Partition of an Interval Partitioned Table

Let’s create Interval-Partitioned table and exchange partitions. Step 1 : Create Interval Partitioned Table Let’s insert some records in TRAN_ALL table. I have staging table which has some records . Let’s create one table using structure of above table with which we can exchange partition of TRAN_ALL table. Let’s exchange partition : Thank you for […]

Read More

Virtual Column Partitioning in Oracle

Oracle 11g came up with concept of Virtual Column which is created with expression. Which does not stores data physically rather it calculates at run time and give us output when we fetch using query. We saw different types of partitioning in previous posts, today we will see how we can partition the table using […]

Read More

Read-Only Partitions in Oracle

Read-Only partitions are of benefits 1.When you are working in Data-Warehouse environment there must be many partitions which are not updated frequently you can add those partitions to read-only state and then add those partitions to read-only tablespace. These read-only tablespace can help you take your RMAN backup faster as read-only tablespace can be avoided […]

Read More

Interval-* Composite Partitioned Tables

In my previous composite partitioning in oracle article I saw example of various types of composite partitioning methods. In addition to that post today we will see composite partitioning with INTERVAL partitioning type. To read about previous composite partitioning : In Interval-* composite partitioning method we will see Interval-Range , Interval-List , Interval-Hash. 1.Create a […]

Read More

Modify Partitioned Table to Non-partitioned Table

In previous post we saw modifying non-partitioned table into partitioned one.Today we will see how we can convert partitioned table into non-partitioned table. To read non-partitioned table to partitioned table: Step 1 : Lets check first table is partitioned one. Step 2 : To convert partitioned table to non-partitioned one we need to take backup […]

Read More

Adding Table Partition in Oracle

Here we will see examples to add partition in all different types of partitioning methods. 1.Add Partition in Range-Partitioned table¬† 2.Add Partition in Hash-Partitioned table 3.Add Partition in List-partitioned table 4.Add Partition in Interval-Partitioned table We can’t simply add partition in interval-partitioned table. But to add partition we can LOCK the last partition that will […]

Read More

Merging Table Partitions in Oracle

In previous post I wrote about splitting single partition into two or more partitions. In this post we will see how we can merge two or more partitions into single partition and can reduce the overhead of managing multiple partitions. To read split partitions Here we will see example of merging different types of partiitons. […]

Read More