Index

A

Archiving

Data Archiving in Oracle 

Archiving - A generic solution - Part 6 - Deploy and Test

Awr

Introduction to AWRs

AWR : The Load Profile

AWR : Instance Efficiency Percentages, Shared Pool

AWR : Analysis of top Wait Events : DB File sequential read

C

Certifications

1Z0-082 - Question Set 1

1Z0-083 - Question Set 1

D

Database Buffer Cache 

Database Buffer Cache Tuning

Date and Timestamp in Oracle

E

Exception Handling Methods  

Equi Joins 

F

Flashback Query and Flashback table 

I

Installation

Install Oracle Database 21c on Oracle Linux 8.9

J

Working with JSONs in Oracle

P

Pluggable Database : The Multenant Architecture

Pluggable Database : Steps to create, start, close and drop a pluggable database

Performance Tuning : Script to gather schema table statistics 

Performance Tuning - Balancing File I/O 

Performance Tuning - Indexes in Oracle

R

RAC

Oracle 11gR2 2-node RAC on VMware Workstation 8

RMAN: Open database with missing datafile and Rman recovery catalog creation

RMAN: Restore a database with RMAN backup after dropping the database

RMAN: Restore a full rman packup of a database on another server

RMAN: Oracle database cold backup - NOARCHIVELOG mode

RMAN: Oracle Database cold backup - ARCHIVELOG mode

S

SCSI Controller

X

XMLDB

Oracle XML DB - An Example

To Store and Select XML Data

XMLDB : Examples of using getClobVal, getStringVal and getNumberVal

XMLDB: Convert xml file into equivalent relational dataset

XML to HTML with XSL stylesheet

XMLDB : DBUriType

XMLDB : XML Functions continued ...

XMLElement, XMLAttributes, XMLAgg, XMLForest - Examples

God's Word for the day

Many kings have to sit on the ground,

  but one who was never thought of has worn a crown

Many rulers have been utterly disgraced

  and the honored have been handed over to others

Sirach 11:5-6

No one can serve two Masters, 

    For a slave will either hate the one and love the other

Or be devoted to the one, and despise the other

    You cannot server GOD and wealth.

Mathew 6:24