Skip to main content
EraAzi.com

EraAzi.com

Leading and Trusted IT Solutions

  • Groups
  • Store
  • People
  • More
  • Search
  • Sign up
  • Log in

Search form

Featured on this site

PostgreSQL Performance Tuning

Razi Abuzar's picture

Blog entry created Wed, 11/22/2017 - 22:26 by Razi Abuzar Featured blog

Performance Tuning:

Below are the parameters and their details which can have a significant effect on the performance of your database.

  • Razi Abuzar's blog
  • 1 comment
  • Log in or register to post comments

The steps to remove fragmentation in tables in Oracle database

Razi Abuzar's picture

Blog entry created Mon, 10/16/2017 - 03:51 by Razi Abuzar Featured blog

There are several ways of removing fragmentation in oracle database:

  1. Export and Import
  2. Moving the tables to a different tablespace and then back to old tablespace.
  3. Moving the tables to same tablespace.

You may choose any of the options but moving tables may require you to check space requirements

Not to implement the 3rd option we have two ways :

Method 1- through direct SQL queries.
Method 2- through bash script.

  • Razi Abuzar's blog
  • Log in or register to post comments

Installing PostgresQL on Linux from yum repository

Razi Abuzar's picture

Blog entry created Thu, 10/05/2017 - 00:26 by Razi Abuzar Featured blog

Step1: add user as below:

 

adduser postgres

Step2: Create Directory

mkdir –p /the/directory/for/data

Step3: yum install postgres*

Step4: initdb –D / the/directory/for/data

  • Razi Abuzar's blog
  • Log in or register to post comments

IT layoffs: A major concern

Kimi Mahajan's picture

Blog entry created Tue, 07/11/2017 - 10:23 by Kimi Mahajan Featured blog

With recent job cuts becoming the headlines of major newspapers these days, it is important to know the reasons for the major downfall of IT market.

  • Kimi Mahajan's blog
  • 2 comments
  • Log in or register to post comments

Online Exam PHP

Razi Abuzar's picture

Blog entry created Wed, 05/03/2017 - 12:32 by Razi Abuzar Featured blog

Go to online exam

  • Razi Abuzar's blog
  • Log in or register to post comments

Oracle Database Architecture

Razi Abuzar's picture

Blog entry created Sat, 02/25/2017 - 04:02 by Razi Abuzar Featured blog

Oracle Database Architecture.

Database: It is a system to organize, store and retrieve data.

Relational database: It is that which allows linking tables in a database. This can be manipulate and accessed by SQL (Structured query language), It is to stop data duplication and enforcing data integrity by relating or sharing columns between two tables in a database.

Program Languages: SQL, PL/ SQL, JAVA

  • Razi Abuzar's blog
  • Log in or register to post comments

Basic Level Oracle Interview Questions

Razi Abuzar's picture

Blog entry created Sat, 02/18/2017 - 01:55 by Razi Abuzar Featured blog

1)    Go through Oracle Architecture.

2)     How the query parsing will happen. Need to explain completely. Refer in youtube Key:Oracle architerture less than 10min its 4min video

  • Razi Abuzar's blog
  • Log in or register to post comments

The Concepts and Architecture of Oracle Goldengate

Razi Abuzar's picture

Blog entry created Thu, 02/16/2017 - 20:40 by Razi Abuzar Featured blog

Oracle Goldengate supports the data replication across various database platforms. The Goldengate replication topology includes the capture and transfer of the extracted data from the source database to the destination database.

Oracle Goldengate topologies are described in the below diagram:

Goldengate Topologies

• Uni-directional: Data is replicated in one direction from source to target database.

  • Razi Abuzar's blog
  • Log in or register to post comments

Written English test for Service Desk L1 and DC OPS L1 Interview.

Razi Abuzar's picture

Blog entry created Sat, 11/26/2016 - 20:11 by Razi Abuzar Featured blog

The written test includes the questions grammar related to common usage of English language in the day to day life and corporate world. To prepare for this please prepare the following topics:

Common Mistakes in spoken language.

  • Verbs
  • Auxiliary Verbs
  • Gerund
  • perfect undertanding of Tenses.

Please refer to the below link for the book:

Learn English Grammar

  • Razi Abuzar's blog
  • Log in or register to post comments

Sonam Gupta Slaps Ravi with a defamation case for writing “Sonam Gupta Bewafa hai” and reveals the story as to why she married another man.

Razi Abuzar's picture

Blog entry created Mon, 11/21/2016 - 15:58 by Razi Abuzar Featured blog

  • Razi Abuzar's blog
  • Log in or register to post comments

English Grammar

Razi Abuzar's picture

Blog entry created Tue, 11/08/2016 - 21:33 by Razi Abuzar Featured blog

Underneath is the English Grammar book:

Esomar.pdf

PDF iconEsomar.pdf

 

  • Razi Abuzar's blog
  • Log in or register to post comments

The HTML meta tags for social media share, like Google+, Facebook, twitter etc.

Razi Abuzar's picture

Blog entry created Thu, 09/15/2016 - 17:50 by Razi Abuzar Featured blog

When you share a link of a web page, the social media like Facebook, Google etc. captures an image from the webpage. This may happen in a random manner but if you want to let the social media know how to display your page information, the below code has to be formatted dynamically or statically hard coded in the head of html, for social media to crawl and understand your data:

  • Razi Abuzar's blog
  • Log in or register to post comments

The lost innocence

Kimi Mahajan's picture

Blog entry created Tue, 07/05/2016 - 23:39 by Kimi Mahajan Featured blog

  • Kimi Mahajan's blog
  • 1 comment
  • Log in or register to post comments

MANUAL UPGRADE OF ORACLE DATABASES 10G, 11G TO 12C VERSION

Razi Abuzar's picture

Blog entry created Fri, 06/03/2016 - 15:26 by Razi Abuzar Featured blog

  1. Oracle databases of versions 10.2.0.5, 11.1.07 & 11.2.0.2 or higher can be directly upgraded to 12c version. All others need an indirect upgrade.
  2. Prior to upgrade take a cold backup of the source database.
  • Razi Abuzar's blog
  • Log in or register to post comments

B Tech Admissions

Commons Groups: Group contributor count and topics

4 contributors

When you start thinking about your career and start thinking to become an engineer here is the place where you can get expert advice from Engineers of reputed Institutes from all over the world. Ask them about the branch you should choose, the criteria of judging the college you are going to take admission in. 

Recent content

Expert advice for B Tech and MBA admissions in India as to how do you choose the best Engineering/ Management College
Students with PCM (Physics,...

Recent contributors

Kimi Mahajan
BTech Admissions
Rumi Khawar
Razi Abuzar
more

User login

Or log in with...

EraAzi.com

Copyright © EraAzi.com 2013-2016