Making Oracle simple for you!

Simplifying DBA learning by sharing knowledge with professionals across the globe

Oracle hr schema script - Create hr schema

I was working on a database connected via SQL developer and could not find HR schema. I wanted to create the HR schema using SQL queries. I used below scripts one by one and create the schema with the SYS user: STEP 1: SCRIPT TO CREATE THE HR USER Execute below script using sys user SET ECHO...

READ MORE

15 Things Junior DBA Must Know

This blog post is a quick summary of How to become a DBA course - A 100% free course which speaks about everything you need to become an Oracle DBA. Learning SQL is just not enough to become an Oracle DBA. You need much more skills and learn other things to crack your first job interview. In...

READ MORE

How to plan database creation

Database creation process involves several operating system files to work together. You create database only once and later on keep on adding more data files. Before you can simply go ahead and start creating your database in real-time, you must know the database planning tasks. Recommended...

READ MORE

How to find fresher DBA jobs?

One of the best part about being an Oracle DBA is - Database ownership! As a DBA, you actually own the database. That being said, one big question arises - which company would handover critical databases to a fresher? To be honest with you, there are not enough opportunities for fresher DBAs....

READ MORE

Oracle Transportable Tablespace

Assume that you have a schema (IQS) on production server and you want to import the schema into test server. The ideal approach would be to perform entire schema export and import using data pump. Right! Let us add some complexity – What if IQS schema size is 200 GB and all of IQS schema objects...

READ MORE

Zero downtime ASM diskgroup migration to another SAN storage

This blog post is part of our video course Oracle RAC DBA video course. Enroll into the course today to start learning oracle rac online. In your environment, you might require to migrate ASM disks from one storage to another storage. The activity is very simple and straight forward. You can...

READ MORE

MySQL Installation on Linux

This article demonstrates MySQL installation on Oracle Enterprise Linux 6.5 version. Installation of MySQL Make sure you are able to connect internet via virtual machine. Try to ping google.com and proceed with installation of MySQL 5.6 # yum install mysql mysql-server -y Start mysql service...

READ MORE

How to increase memory_target in oracle

Before you can increase memory in oracle database, you must first understand four oracle memory parameters which govern the instance: SGA_TARGET and SGA_MAX_SIZE MEMORY_TARGET and MEMORY_MAX_TARGET SGA_TARGET and SGA_MAX_SIZE Important: If you set MEMORY_TARGET, they oracle will perform...

READ MORE

How to find ASM disks mapping to physical disks

When you work in a RAC environment with a list of ASM disks, sometimes you might want to figure out which ASM disk is mapped to which physical device. Below is a simple script that will help you find out ASM disks that are mapped to Linux...

READ MORE

How to find golden gate process memory usage

Each and every Golden Gate process takes approx 25 - 50 MB of memory or sometimes more depending upon the transactions. Here is one script which will help you find the total memory usage on source and target server. This script is written for linux #!/bin/bash ############################### #...

READ MORE