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

Collections : Example of Associative Array with LIMIT clause

Collections: Example of Associative Array with PLS_VARCHAR2 and PLS_INTEGER

D

Database Buffer Cache 

Database Buffer Cache Tuning

Date and Timestamp in Oracle

Date Functions - Continued ...

Dynamic SQL : Method 4

E

Exception Handling Methods  

Equi Joins 

F

Flashback Query and Flashback table 

Functions

I

Installation

Install Oracle Database 21c on Oracle Linux 8.9

J

JSON : Working with JSONs in Oracle

Java

Relationship between a Web Application and the ServletContext
Using Servlets to retrieve HTTP data from browser

M

Mutating Trigger

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

PLQL : Functions

PLSQL : To profile a PL/SQL Procedure

PLSQL - Collections : Example of Associative Array with LIMIT clause

PLSQL : Collections: Example of Associative Array with PLS_VARCHAR2 and PLS_INTEGER

Q

Queries 1 : Useful queries used in day to day development

Queries II : Useful queries used in day to day development

Queries III - To search a query from all_source

Queries IV - Types of Queries

Queries V - Types of Queries : II 

Queries VI - The Oracle CASE Statement

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

Struts : Building your first Struts application

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