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

Collections : Exceptions and Bulk Collect Exceptions 

Collections: Nestes Tables - Use of CAST , MULTISET , COLLECT and BULK_EXCEPTIONS

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 

Error : ORA-00054: resource busy and acquire with NOWAIT 

Error : ORA-02292 - integrity constraint (%s.%s) violated - child record found

ORA-01031: insufficient privileges due to missing GRANT with ADMIN option

TNS-12537: TNS:connection closed

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 

JSON : PL/SQL Object Types and Methods for JSON 

JSON : Select Level 1 and Level 2 data 

JSON : A JSON generator using SQL and PLSQL 

JSON : XML to JSON and JSON to XML 

JSON : Parsing a JSON object with Oracle PLSQL 

JSON : Parsing and updating a JSON object using PLSQL 

JSON : A generic JSON parser with update using Oracle PL/SQL 

JSON : A generic multi level JSON object parse and update script using PLSQL 

JSON : A generic JSON parser and JSON generator using a config table 

JSON : A generic JSON generator using a config table

Java

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

M

Mutating Trigger

Multitenant database: To create, start ,close and drop a pluggable database

Multitenant database: To unplug a PDB from source and plug into Target Database

Multitenant database: PDB Cloning

P

Pluggable Database : The Multenant Architecture

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

Pluggable database: PDB Cloning

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

PLSQL - Collections : Exceptions and Bulk Collect Exceptions 

PLSQL - Collections: Nestes Tables - Use of CAST , MULTISET , COLLECT and BULK_EXCEPTIONS

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