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
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
Technology
All about table and constraints in Oracle
CREATING ORACLE DATABASE OBJECTS CREATING TEMPORARY TABLES SQL>CREATE GLOBAL TEMPORARY TABLE TEMP_EMP (EMPNO NUMBER,ENAME VARCHAR2(10)) CREATING ONE TABLE
security
DBMS_CRYPTO example
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)
Dataguard
FAST START FAILOVER (FSFO) CONFIGURATION USING FAR SYNC NODE AS OBSERVER IN DATAGUARD USING DGMGRL
FAST START FAILOVER (FSFO) CONFIGURATION USING FAR SYNC NODE AS OBSERVER IN DATAGUARD USING DGMGRL 1.For data guard DGMGRL
Dataguard
Step by Step Oracle Active Data Guard Far Sync RAC
Step by Step Oracle Active Data Guard Far Sync RAC Active Data Guard Far Sync, a new capability with