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 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
What Is a Control File? Every Oracle database has a control file. A control file is a small binary file
Managing the Online Redo Log Creating Online Redo Log Groups and Members Creating Online Redo Log Groups The following
SQL> CONN SYS/SYS AS SYSDBA Connected. SQL> set serveroutput on SQL> SQL> set linesize 121 SQL> SQL> DECLARE l_credit_card_no VARCHAR2(19)
FAST START FAILOVER (FSFO) CONFIGURATION USING FAR SYNC NODE AS OBSERVER IN DATAGUARD USING DGMGRL 1.For data guard DGMGRL
Step by Step Oracle Active Data Guard Far Sync RAC Active Data Guard Far Sync, a new capability with
1.First create the shell script mentioning all environmental variables adjusted to your environment. vi dataguard_dr_sync_check.sh #!/bin/bash cd /u01/app/oracle/shells for k
RMAN Incremental backup This backups only datafile blocks changed since specified previous backup. 1.This strategy could be followed to make
Automatic Storage Management (ASM) A.Overview of Automatic Storage Management (ASM) Automatic Storage Management (ASM) simplifies administration of Oracle related