foalabs

How to increase PROCESSES,SESSIONS and TRANSACTIONS initialization parameter in Oracle Database Sessions : Sessions specify the number of connections that can served by oracle database at a time. This is equivalent to the number of concurrent users of the application. If your application has a lot of concurrent users then you need to increase the sessions in the oracle database. Processes : Processes run in the background of Oracle database to maximize performance and accommodate many users. Transaction : A transaction is a logical, atomic unit of work that contains one or more SQL statements. A transaction groups SQL statements so that they are either all committed, which means they are applied to the database, or all rolled back, which means they are undone from the database Steps: 1.    Login as sysdba     sqlplus / as sysdba     2. Check Current Setting of Parameters     sql> show parameter sessions     sql> show parameter pr...

Query to check current utilization of processes/sessions and max utilization in Oracle Database Script: select resource_name, current_utilization, max_utilization from v$resource_limit where resource_name in ('processes','sessions'); RESOURCE_NAME                  CURRENT_UTILIZATION MAX_UTILIZATION ------------------------------ ------------------- --------------- processes                                      208             400 sessions                                       216             420 If you like please follow and comment

Oracle Zero Downtime Migration ZDM|Installing|Migration to OCI Oracle Cloud Oracle customers are moving to Oracle Cloud rapidly and moving the workloads to OCI with minimum downtime is a real challenge. Here the ZDM tool from Oracle can be very helpful. It will help to move Data Workload to Oracle Cloud in various models with least downtime. Learn More on  https://www.oracle.com/database/technologies/rac/zdm.html ZDM will provide 1) Physical Online Method  2) Physical Offline Method  In this post I am going to show how to install an Oracle ZDM tool. Source Database: 12.1.0.2 Edition : Enterprise Edition DB Name: DEV DB Unique Name:  DEV_primy Target Database: 12.1.0.2 Edition : Enterprise Extreme Performance Edition DB Name: DEV121 DB Unique Name:  DEV121_stby Steps: 1)  I will create a separate VM instance with Linux 7 and 100 GB space on OCI. The steps are simple, just follow the screen shots. Once the VM is created , please connect and verify. I am ...

Setting up  SMTP using Email Delivery Service on Oracle Cloud (OCI) The world is moving to cloud and so Data loads , application are also getting migrated to cloud systems. Now lets says we are running an OEM monitoring tool and now we want to use a notification service from the Oracle Cloud. So we have a solution on OCI called as Oracle Cloud Infrastructure (OCI) Email Delivery. It is an email sending service and Simple Mail Transfer Protocol (SMTP) relay that provides a fast and reliable managed solution for sending both high volume bulk and transactional emails. I will explain in a simple ways how to setup this up. Steps: Login to you OCI console with a user which will be used for email delivery credentials. You can create a new user as well with required permission.  For this example I am using my primary user. 1) Create an SMTP credentials. Go to User settings>SMTP credentials> Generate SMTP credentials Make sure to save the SMTP credentials  2) Now lets do the...

Create a Database Standby (Data Guard)  on OCI Oracle Cloud for a DB System Database In one of my previous post I have created a 12c DB System on Oracle Cloud OCI . Now for that database I am going to create a Dataguard for that database. In OCI we need to have an Enterprise version to create a data guard. Steps: 1) Login to OCI console and go to Database Services. Select the Database and click on Data Guard Association. 2) But Wait ....!!! Before creating the dataguard, let's create a database image. Go to Database details and follow below screenshots. This image will be needed while creating the dataguard It takes some time to create the image. Validate that the database image is created. 3) Now we will create DG. Go to navigation as given in point 1 and follow as below. Give the same shape as primary database(not mandatory) and choose the image created in step 2. Click Next Click on Enable Data Guard It will take time to complete. Approx. 1 hr 25 mins  Process is running to...