Oracle & PostgreSQL - Developer & Administrator

Your Personal Trainer for Oracle & PostgreSQL

Search This Blog

Shreyan Technology - Training Schedule (Oracle & PostgreSQL)

Register for FREE

Email This BlogThis!Share to X Share to Facebook Share to Pinterest

No comments:

Followers

About Me

suchitDBA

View my complete profile

Pageviews past week

Articles

Home
Connect with the author / Database Trainer
Shreyan Technology - Training Schedule (Oracle & PostgreSQL)
Tip of the Day - Oracle & PostgreSQL for Developer & Administrator
Create Pluggable Database (PDB) in 12c using SQL P...
Tablespace Usage Monitoring and Maintenance
How to Display line numbers in pl sql developer Ed...
Spool only data - no SQL Commands in the log file
Fun with UPDATE Statement
Syntax for Creating Table with Primary Key and For...
How to create a parent and Child Table in 2 differ...
PL/SQL Block to loop through a list of comma separ...
How to Change the location of Database Directories...
Important SQLs for DBAs
How to turn on Archivelog Mode
How to turn off Archivelog Mode
RMAN Command for Database Backup
How to Create a RMAN Catalog and register a databa...
How to change the DB ID of a database using NID ut...
How to simulate SQL execution with application Bin...
Sample PL/SQL Block to test DBMS_CYPTO package
Converting Between Physical Standby and Snapshot S...
How to Enable Active Data Guard Option
Different ways to get the Explain Plan for A SQL I...
SQL Plan Baseline - Initialization Parameters (Ora...
Run SQL Tuning Advisor Manually for a SQL ID
Load SQL Plan from Cusrsor Cache to SQL Plan Basel...
How to copy a specific Execution Plan for any SQL ...
How to Disable a SQL Plan from the Baseline
How to Disable Database Auto Task
ORA-27102: out of memory Error
EM 12c, EM 13c: How to Update DBSNMP Password and ...
Steps to relink Oracle Libraries
Commands to delete older files in Unix / Linux
top and pidstat command in Linux
Everyday Task Reference
Oracle DBA 19c / 23ai Performance Tuning Quiz
Introduction to Oracle RAC
Different ways to create Pluggable Database (PDB) in Oracle 19c
Creating PDB from Seed PDB (From Scratch)
Understanding Different Character Sets for our Database
Number Data Type in Oracle – Understanding Precision and scale
SQL Joins in Oracle (19c / 23ai) - A short explanation
How to Prevent displaying Query result on the screen in SQL* Plus
Spooling Query output to an Existing File in SQL* Plus
About login.sql in SQL* Plus
SET SQLPROMPT in SQL* Plus
SET TIME in SQL* Plus
SET TIMING in SQL* Plus
SET FEEDBACK ONLY SQL_ID in SQL* Plus
SQL Join Methods in Oracle
Gathering Table Stats in a PDB in Oracle
EXIT command in Oracle SQL*Plus
WHENEVER SQLERROR EXIT command in Oracle SQL*Plus
Create Pluggable Database (PDB) from scratch in Oracle 19c / 23ai
Startup Process for Pluggable Database (PDB) in Oracle 19c / 23ai
Saving Pluggable Database (PDB) startup State in Oracle 19c / 23ai
Common User in Oracle Multi-Tenant Database
Connecting to Pluggable Database with OS Authentication in Oracle 19c / 23ai (/ as sysdba)
Executing Oracle SQL script (with parameters) from OS (Unix / Windows) prompt
Oracle Goldengate - Two Architectures
Oracle Goldengate Microservices - Core Service Overview
Oracle Goldengate 19c topologies:
Extract process use cases in Oracle Goldengate 19c
Classic Vs. Integrated Extract process in Oracle Goldengate
Replicat Types in Oracle Goldengate 19c
One-time Oracle Database Setup for Oracle Goldengate 19c replication
PostgreSQL DB - Role Vs. User
PostgreSQL DB - List all Databases
Backup & Restore PostgreSQL DB with pg_dump Utility
Create Database in PostgreSQL DB
About Crontab
Oracle RMAN Backup Retention Policy
Oracle Goldengate Parameter File Rules
crsctl commands to check Cluster Status (Oracle RAC DB)
[ORACLE RAC DBA] - crsctl start / stop commands
[ORACLE RAC DBA] - SRVCTL command to stop & start Database / Instance
[ORACLE RMAN] - List Backup Commands
[Oracle DBA - Performance Tuning ] - Display Explain Plan with SET AUTOTRACE in SQL Plus
[ Oracle DBA - Performance Tuning ] - Important Views for Oracle DB Performance Tuning
[ Oracle DBA - Performance Tuning ] - Scripts to get SQL Performance Details
[ Oracle DB Performance Tuning ] - Scripts to generate AWR report in Command line
[Oracle ASM] Disk Group Redundancy Levels
[Oracle Performance Tuning] - SQL Plan Management (Overview)
Oracle Dataguard – Views to check the Status & Apply Lags
GB Vs GiB and TB Vs TiB - Complete Explanation
[ Oracle DB Wait Events Series ] - DB File Scattered REad Wait Event

Report Abuse

Simple theme. Powered by Blogger.

Search This Blog

Shreyan Technology - Training Schedule (Oracle & PostgreSQL)

No comments:

Post a Comment