Home
About Us
Contact us
Disclaimer
Privacy Policy
Navigation Bar
Oracle Developer
Date Functions
Oracle Date and Timestamp
Some more Date Functions
Queries
Dynamic Queries
Method 4 Dynamic SQL
Util Queries
Utility Queries
Utility Queries - II
To search a Query or Text String from all_source
Types of Queries
Types of Queries
PL/SQL
Mutating Trigger Error
Functions
PL/SQL Profiling
To profile a PL/SQL Procedure
Collections
Collections : Example of Associative Array with LIMIT clause
Collections : Example of Associative Array with PLS_VARCHAR2 and PLS_INTEGER
Collections : Methods and Exceptions
Collections: Nestes Tables - Use of CAST and MULTISET
Writing query output to excel
Oracle Script to write any SQL query output to excel
Oracle script to write to multiple sheets in the same excel file
To create a listener process in oracle using PLSQL
Oracle XML DB
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
XMLDB: XML to HTML with XSL stylesheet
XMLDB : DBUriType
XMLDB : XML Functions continued ...
XMLElement, XMLAttributes, XMLAgg, XMLForest - Examples
JSON in Oracle
Working with JSONs in Oracle
PL/SQL Object Types and Methods for JSON
Oracle JSON : Select Level 1 and Level 2 data
A JSON generator using SQL and PLSQL
XML to JSON and JSON to XML
Parsing a JSON object with Oracle PLSQL
Parsing and updating a JSON object using PLSQL
A generic JSON parser with update using Oracle PL/SQL
A generic multi level JSON object parse and update script using PLSQL
A generic JSON parser and JSON generator using a config table
A generic JSON generator using a config table
Common Oracle Errors
Resource busy and acquire with NOWAIT
ORA-01031: Insufficient privileges due to missing GRANT with ADMIN option
TNS-12537: TNS:connection closed : Resolved & ORA-01555: snapshot too old:
Exception Handling
Oracle Exception Handling Methods
Archiving
Reclaim tablespace size after a large table delete
Data Archiving in Oracle
Archiving a generic solution - Part 1
Archiving a generic solution - Part 2
Archiving a generic solution - Part 3
Archiving a generic solution - Part 4
Archiving a generic solution - Part 5
Archiving a generic solution - Part 6 - Deploy and Test
Archiving - Case Study for optimizing disk space utilization with archiving
Archiving : Changes for data replication
Archiving : A case study for data replication
Data Replication : Using Change Notification and DBMS_SCHEDULER as a LISTENER
Oracle DBA
Multitennant Database
To create, start ,close and drop a pluggable database
Unplug a PDB from source and Plug into Target Database
PDB Cloning
RAC
Oracle 11g RAC on Linux - Basic Architecture and Installation Guide
Adding a new Shared disk group in RAC in VM Workstation 10
How scan listener works in RAC
Oracle 11g RAC Kernel Parameters Explained
Oracle 11g RAC Kernel Parameters Explained - II
RMAN
Create RMAN recovery catalog and RMAN full database backup
To restore a database with an RMAN backup after the database has been dropped
Restore a full rman packup of a database on another server
Oracle database cold backup - NOARCHIVELOG mode
Oracle Database cold backup - ARCHIVELOG mode
Dataguard
Oracle Dataguard Architecture and Concepts
Oracle Dataguard physical standby setup steps
Oracle Dataguard Broker
Dataguard Broker - Steps
Dataguard - Switchover and Failover
Dataguard Checks Queries
AWR
Introduction to AWRs
AWR : The Load Profile
AWR : Instance Efficiency and Shared Pool Statistics
AWR : Analysis of top Wait Events : DB File sequential read
DBA Configurations
To add a Listener
To Configure a New Listener Other Than Default
To Configure a New Listener using NETCA
To restore a linux backup on a windows machine
Tablespaces and datafile operations
Flashback
Oracle Flashback Query and Flashback table
Oracle Data Handling Solutions
Advanced Queues
Oracle Advanced queues
Oracle Advanced Queues : Propogation of data between two databases
Change Notification
Oracle change notification
Performance Tuning
Utility scripts
Scripts for gathering statistics
Performance Tuning - Balancing File I/O
Indexes in Oracle
Utility Scripts
Long running queries and table locks : Killing such sessions or taking the plans and tuning them
Oracle script to get Table Indexes and Constraints and Index/Constraint column positions
Oracle Tablespace Free and Used Space
DBMS_SCHEDULER : To run a process asynchronously
Certifications
1ZO-082 : Question Set 1
1ZO-082 : Question Set 2
1ZO-082 : Question Set 3
1ZO-082 : Question Set 4
1ZO-082 : Question Set 5
1ZO-083 : Question Set 1
1ZO-083: Question Set 2
1ZO-083
Installations
Oracle Linux 8.9 Installation of VM 17
Format a USB drive which is not getting detected
Oracle 21c Express Edition - setup and installation
Install Oracle Database 21c on Oracle Linux 8.9Install Oracle Database 21c on Oracle Linux 8.9
Knowledge Base
Oracle Architecture
Oracle Net
Oracle Database Buffer Cache
Working of ASM
PDB
The Multitenant Architecture
Oracle Queries
Oracle Join Methods
Troubleshooting
Internet not working even though the wi-fi setting shows that it is connected to your network
Linux
Utility Scripts
Shell scripting one liners using sed and awk
Basic Arrary usage in shell scripts
Group functions using AWK
Grouping functions using AWK
Scripts to search files in subdirectories, reverse lines and Interchange column positions
Networking
Connect two linux machines with ethernet cable or a LAN crossover cable
Steps to connect from window desktop to a linux server
Oracle Dewdrops
Dewdrops 2024
Dewdrops May 2024
Dewdrops Jun 2024
Dewdrops Jul 2024
Dewdrops Aug 2024
Dewdrops Sep 2024
Dewdrops Oct 2024
Dewdrops Nov 2024
Dewdrops Dec 2024
Dewdrops 2025
Dewdrops Jan 2025
Dewdrops Feb 2025
Dewdrops Mar 2025
Dewdrops Apr 2025
Dewdrops May 2025
Dewdrops Jun 2025
Dewdrops Jul 2025
Newsletters
The Oracle History
Newsletters 2024
Oracle News Jul 2024
Oracle News Aug 2024
Oracle News Sep 2024
Oracle News Oct 2024
Oracle News Nov 2024
Oracle News Dec 2024
Newsletters 2025
Oracle News Jan 2025
Oracle News Feb` 2025
Oracle News Mar 2025
Oracle News Apr 2025
Oracle News May 2025
Oracle News Jun 2025
Oracle News Jul 2025
Others
Java
Project Resume - Summary
Project Resume Download
Sunday, June 21, 2020
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
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
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
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment