Infrastructure Identity and Access Management(IAM)

IAM (Infrastructure Identity and Access Management), as the name suggests it is used to control an access to cloud resources. Which real user should have access to which compartment , network or tenancy and which type of access they should have is decided by configuring IAM. There are different components which helps you configure IAM […]

Read More

Session in killed state

Sometimes you see sessions does not wipe out immediately or you see “marked for kill” message and they stays in killed state. You can kill them using below query.

Read More

Networking components in Oracle Cloud Infrastructure(OCI)

The very first step in your OCI journey would be setting up a VCN(Virtual Cloud Network) in oracle cloud infrastructure. So lets be familiar with all networking components. 1. VCN ( Virtual Cloud Network) It is almost similar to the on-premise network we have with firewall rules and communication gateways. VCN resides in a single […]

Read More

Storage options in Oracle Cloud Infrastructure

Storage is an integral part of any cloud project life cycle. Oracle provides distinct storage options according to the need of data being accessed . You can either use option from “hot” storage class  if you want to access it frequently or you can use option from “cold”  storage class if you use it less […]

Read More

Compute in Oracle Cloud Infrastructure(OCI)

Compute is one of the key component in Oracle Cloud Infrastructure. Compute is a machine with Instance Type ,OCPUs(Oracle Compute Unit) , RAM , local disk , network bandwidth and number of VNICs you can attach to your instance. There are different types of Computes available in OCI. 1.Bare Metal Instance : In Bare Metal […]

Read More

Oracle Cloud Infrastructure(OCI) Overview

Oracle Cloud Infrastructure , as its name suggests provides you a full infrastructure to run your application. It is a set of cloud services that supports you to build and run an extensive range of services and applications with high availability , scalability and high performance. It provides you high performance of compute and storage […]

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