Skip to content
Tuesday, February 07, 2023
Database Learners
Menu
  • About Database
  • Oracle
    • ASM
    • Data Pump
    • Backup and Recovery
    • Patching and Upgradation
    • Performance Tuning
    • Data Guard
    • Real Application Cluster
    • Golden Gate
    • PL/SQL
  • MySQL
  • PostgreSQL
  • MongoDB
  • MS SQL Server
  • SQL
  • Linux
  • About Me
  • Contact Us
  • Home
  • 2015

Year: 2015

Oracle Concepts – Find indexes for a table

14 April 201520 August 2020 Administrator

  See the indexes for a table
It is not unusual to wonder what indexes a specific table might have, and what columns in the table are assigned Read More…

Oracle : TKPROF simple steps

14 April 201531 July 2020 Administrator

1. Set the following parameters
TIMED_STATISTICS = TRUE
MAX_DUMP_FILE_SIZE = unlimited (also see metalink article 108723.1)
USER_DUMP_DEST = /oracleRead More…

SQLNET: How does Oracle Client connect with Oracle Server

14 April 201520 August 2020 Administrator

Lets first try to understand what is Oracle Server and what is Oracle Client: Oracle Database Server:
Oracle Database Server is usually a physical maRead More…

Installing Oracle Database 11g XE on Oracle Enterprise Linux (64-bit)

14 April 20157 August 2020 Administrator

Before we begin installing Oracle Database XE in Linux, we need to prepare
the environment by installing the required packages, setting kernel parametRead More…

Relational Database Design – Normalization

13 April 201520 August 2020 Administrator

It’s common for people new to relational databases to approach the design of the tables like they would a flat, Excel-like spreadsheet: to design the Read More…

Beginner’s guide to creating Tables in MySql

13 April 20154 August 2020 Administrator

The first thing that you will need is to download MySql. I am working with MySql version 5.0. You can download it from their site. After setting it uRead More…

MySQL Basics Everything you need to know to start using MySQL databases

13 April 20154 August 2020 Administrator

Introduction
This article describes all that you need to know to start working with MySQL database. Everything from the basic info on SQL, how to set Read More…

Monitoring MySQL using Nagios

13 April 20157 August 2020 Administrator

This tutorial will discuss the various ways using which you can effectively monitor your MySQL Database using Nagios.
Prerequisites: Nagios MonitorRead More…

Quick Start: Setup CentOS 7 as a LAMP Server

13 April 20157 August 2020 Administrator

In this tutorial, I’m going to show you simple steps using which you can setup your own LAMP (Linux-Apache-MySQL-PHP) on a CentOS 7 system.
PrerequisiRead More…

Quick Start: LAMP on Ubuntu 14.04

13 April 20157 August 2020 Administrator

Quick Start: 
LAMP on Ubuntu 14.04 Here’s a simple, easy to follow guide that will help you set up a fully functional “LAMP”: Linux (duuuuhhhRead More…

Posts navigation

Older posts

Recent Posts

  • How to Optimize MySQL Tables and Defragment to Recover Space
  • ORA-01031: Insufficient Privileges When Connect As Sysdba
  • Oracle RAC log files locations
  • Drop all tables in Oracle DB (Schema)
  • How to Determine If the Oracle Redo Log File Size Is a Problem

Categories

  • ASM (40)
  • Backup and Recovery (52)
  • Data Guard (36)
  • Data Pump (28)
  • DB Scripts (26)
  • General (1)
  • Golden Gate (7)
  • Interview Questions (24)
  • Linux (86)
  • MS SQL Server (8)
  • MySQL (120)
  • ORA-Errors (45)
  • Oracle (301)
  • Oracle 10g (19)
  • Oracle 11g (24)
  • Oracle 12c (9)
  • Oracle RAC (101)
  • Oracle XE (7)
  • Patching and Upgradation (19)
  • Performance Tuning (61)
  • PL/SQL (26)
  • RMAN (85)
  • SQL (32)

Visitors

  • 0
  • 40
  • 49,288

Reference Links:

  • https://docs.oracle.com/en/database/index.html
  • https://dev.mysql.com/doc/
  • https://docs.mongodb.com/manual/
  • https://docs.microsoft.com/en-us/sql/sql-server/?view=sqlallproducts-allversions
  • https://www.postgresql.org/docs/current/
@2021 databaselearners.com | Theme: BlogMagazine by Dinesh Ghimire.