Create new mount point using LVM in RHEL 7
First install gdisk utility (you may use old fdisk utility if LUN/drive size is less than 2 TB) -bash-4.1$ yum […]
Linux
Dataguard
Monitor steps for Logical Standby Database
1.V$LOGSTDBY_PROCESS displays dynamic information about what is happening to the Data Guard log apply services. This view is helpful when
Dataguard
Logical Standby Database setup step by step from RAC to Single Instance in 11g
LOGICAL STANDBY DATABASE STEP BY STEP Primary DB: CLRVMS (ip:10.3.248.5 and 10.3.248.8) Logical Standby DB: CLRVMS_B(ip:10.3.248.129) Please check
Backup and Recovery, General DBA
FLASHBACK DATABASE AND QUERIES
FLASHBACK FEATURES Purging the Recycle Bin purge table sales.woodscrews; purge index sales.woodscrews_pk_idx; purge tablespace sales; purge recyclebin;
General DBA
Network configuration listener and tnsnames in oracle
Oracle Network Configuration =========================== In its most basic form, Oracle uses three files (listener.ora, tnsnames.ora & sqlnet.ora) for network configuration.
General DBA
Memory and Process in Oracle generic note
MEMORY MANAGEMENT 11g ===================== http://blog.tanelpoder.com/2007/08/21/oracle-11g-internals-part-1-automatic-memory-management/ PGA+SGA=MEMORY_TARGET what are the shared memory IDs for my instance $ sysresv corresponding SysV SHM
PLSQL for DBA
PLSQL Reference for DBA
PLSQL Reference for DBA PL/SQL stands for Procedural Language/SQL.PL/SQL extends SQL by adding control Structures found in other procedural language.PL/SQL
General DBA
control files in general
What Is a Control File? Every Oracle database has a control file. A control file is a small binary file
General DBA
Redo log in general
Managing the Online Redo Log Creating Online Redo Log Groups and Members Creating Online Redo Log Groups The following
Technology
Materialized View Example
ORASOA side: create table tab1(c1 char(10),c2 char(10),c3 char(10)); begin for i in 1..10000 loop insert into