Today we are going to work on the steps used for Resize the online Redo Logfiles. Let’s follow the steps:- Single Instance: 1. First, see the size of the current logs: sqlplus /nolog SQL> connect / as sysdba SQL> select group#, bytes, status from v$log; GROUP# BYTES STATUS ———- ———- —————- 1 1048576 INACTIVE 2 […]
Category: ORACLE DATABASE
How to clone Oracle Binaries
Today we are going to work on the steps which are used to clone Oracle Binaries. Sometimes we install Oracle software by using a utility such as tar to copy an existing installation of the Oracle binaries to a different server. Installing Oracle with an existing copy of the binaries is a two-part process Copy […]
How to set IDLE TIME in Oracle Database
Today we are going to explore the steps which we use for set IDLE TIME in Oracle Database. Let’s follow the steps. Step1:- connect as sysdba user SQL> conn /as sysdba SQL> sho parameter resource_limit NAME TYPE VALUE ———————————— ———– —————————— resource_limit boolean FALSE Step2:- Change the resource parameter to true SQL> alter system set […]
How to configure Shared server mode
Today we are going to explore the steps to use for configure Shared server mode. Let’s follow the steps. We need to set the init parameters SQL>alter system set shared_servers=5; SQL>alter system set max_dispatchers=10 scope=spfile;; SQL>alter system set shared_server_sessions=5 scope=spfile;; SQL>alter system set circuits=300 scope=spfile;; SQL>alter system set dispatchers=”(protocol=TCP)(dispatchers=3)(connections=100)” scope=spfile; Now client tnsfile should be […]
Apply latest PSU (Jan 2020) on Oracle Home
In this article we will apply the latest PSU applied to Database Home. Latest Patch : Database Jan 2020 Release Update : 12.2.0.1.200114 (30593149) We need to initially download the desired PSU and My Oracle Support compatible OPatch utility (support.oracle.com). Doc ID 2118136.2 -> Quick References to Patch Numbers for Database / GI PSU, SPU (CPU), […]
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 […]
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 […]
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 […]
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-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 […]