SQL vs Pandas CheetSheet

Oracle to Postgresql Full Schema migration using python script

Oracle to PostgreSQL full Schema Migration using Python

GC Buffer Busy Waits in RAC: Finding Hot Blocks

Manual Upgrade 11gR2(11.2.0.4 only) or 12c database to 18c

USEFUL DB SCRIPTS

Configuring Logstash with Elasticsearch

Working with Elasticsearch

Integrating Hadoop and Elasticsearch

Using Microsoft PolyBase to query Big Data

Processing Twitter (JSON) Data in Oracle (12c External Table)

Optimizing NFS Performance [HDP NFS]

Offload Oracle Data to HDFS using RO Tablespaces

Creating Oracle External Table (12c) on HDFS using HDP NFS Gateway

Configuring NFS Gateway for HDFS [HDP]

enq: TM Contention Wait Events

Configure Hortonworks Hive ODBC Driver for Oracle HS

Query Teradata Presto from Oracle using ODBC Heterogeneous Gateway [RHEL 7]

Using HDP Zeppelin

Using Apache Phoenix on HDP

Working with HBase on HDP

Script to create query for killing culprit blocker session

Working with Talend for Big Data (TOSBD)

Analyzing/Parsing syslogs using Hive and Presto

Working with Apache Cassandra (RHEL 7)

Hortonworks - Using HDP Spark SQL

Installing/Configuring Hortonworks Data Platform [HDP]

Working with Apache Spark SQL

Installing/Configuring and working with Apache Kafka

Diagnostics: Fix Under replicated blocks [Ambari Dashboard]

Streaming Twitter Data by Flume using Cloudera Twitter Source

Streaming Twitter Data using Apache Flume

Building Teradata Presto Cluster

Working with PrestoDB Connectors

Installing/Configuring PrestoDB

Day to Day performance monitoring and troubleshooting

Running DB Health Check

Mapping a resource intensive OS Process to DB Process

Hadoop DFSAdmin Commands

TM - Row Lock Contention Wait Event

enq: TM - Contention

Recover the deleted file/folder in HDFS

Hive Streaming

Installing/Configuring and Working on Apache Sqoop

Apache PIG - a Short Tutorial

RMAN SCRIPT to format disk channel according to date

Using Hadoop Compression

Hive for Oracle Developers and DBAs - Part III

Hive for Oracle Developers and DBAs - Part II

Hive for Oracle Developers and DBAs - Part I

Forward syslog to Flume with rsyslog

Hive Installation and Configuration

Hadoop Administration: Accessing HDFS (File system & Shell Commands)

Procedure to receive emails of sessions blocked for more than 30 minutes

Hadoop Ecosystem - Quick Introduction

Big Data - The Bigger Picture

Manual role switch over in Data Guard Environment

Session Blocker detection and managing locks

Standby MRP needs old log sequence even after restore of incremental backup on standby

Recover OCR Vote without backup

DB Health Check

DB Monitoring scripts

Scripts to measure throughput

Measuring I/O per seconds in oracle

Dealing with Oracle locks

Track Amount of Redo Generation

Avamar customized backups

Query to find out log switch frequency and history

Database redo generation calculation

Quickly finding out reason of slowness on database

Manually registering archivelog on standby to resolve gaps

Backup and recovery using Avamar

Moving Audit Trail and Fine Grained Auditing Log Table to new tablespace

Global Cache Blocks Lost

Resolving Gap by refreshing standby from primay (Incremental level) without Incremental level 0 backup

Script to confirm last SCN and Standby Latest sync status

Resolving Gaps in Data Guard Apply Using Incremental RMAN Backup

RMAN Overall Progress

AMM to ASMM

Current top resource consuming SQLs

Who is blocking whome

Resolving Snapshot too old error of Undo Tablespace

Determining the Optimal Undo Retention Period

Single to Single Node Clone EBS R12.2

oracle ebs r12.1.3 virtual appliance configuration

How to change IP and subnet mask of Exadata database nodes and Storage cells

http://sameer-samspeaks.blogspot.com/2013/11/how-to-change-ip-and-subnet-mask-of.html

Auditing Account Lock and Unlock history

Tracking database users password change history

Oracle Fine Grained Auditing

How to track redo log generation

How to find correct SCN while recovering DB

Tracing SQL Statements

Monitoring Progress of a SQL Execution Plan

Seeing Execution Statistics for Currently Running SQL

How to properly use functions to avoid full table and index scan

Checking Flash Cache Size and Flash Cache Log location

QUERYING ATTRIBUTES OF GRID DISKS

Find out Storage Cell IP Adress

QUERYING PATH OF GRID DISKS

Working with locked objects

Using Segment Advisor

Function Based Indexes to avoid full table scan on data conversion in query

Location of adconfig.sh Backup Files

Advance Confguration Options in EBS R12

EBS Database Structure

Single to Multi Node Cloning of EBS R12

EBS R12.1 File System

EBS 12.1 Environment files and control scripts

Transportable tablespace

Flashback Data Archive (Oracle Total Recall)

FlashBack on RAC

Dropping a RAC database

RAC TO RAC Duplicate Database

Checking current SGA usage

Creating Responsibilities and Assigning to Users

Materialized Views

TUNING FULL TABLE SCANS

Dealing with lock contention

Working with SQL Tuning profiles

Fixing SPFILE parameter on ASM While database is closed

Oracle GoldenGate 11g Installation and configuration for DML and DDL

DBMS_CLOB Package usage

Automated script to create all tablespaces from existing database

Datapump Export to windows shared folder

C:\Users\OR-01>expdp ' / as sysdba' directory=remote full=y dumpfile=full.dmp logfile=full.log

Export: Release 11.2.0.3.0 - Production on Mon Aug 3 10:11:40 2015

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit
Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39002: invalid operation
ORA-39070: Unable to open the log file.
ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 536
ORA-29283: invalid file operation

######################################
Create a new directory with UNC naming e.g. \\192.168.26.11\rmanbackup

C:\Users\OR-01>sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Mon Aug 3 10:17:11 2015

Copyright (c) 1982, 2011, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

DBMS_SPACE.CREATE_TABLE_COST and DBMS_SPACE.CREATE_INDEX_COST for space planning

DataPump Internals

DBMS_APPLICATION_INFO

Automating SQL Tuning

Oracle Data Masking Pack

Transparent Data Encryption TDE

Oracle Data Redaction

Using AWR Reports

Running a Database Health Check

Resolving Open Cursor Errors

Monitoring Temporary Tablespace Usage

Managing Undo Tablespace

Monitoring Table Usage

Using Append Hint to speed up insert operations

Reseting High Water Mark of Oracle Table

Getting ROWID of a record in oracle table

Using Segment Space Advisor for segment space management and tuning

Using Explain Plan

Using SQL Tuning Advisor from command line

Killing Oracle Session from database and OS level

Monitoring Tablespace growth from sql

Tracking Cursors usage

How to find an Oracle Process which is consuming most of memory and CPU

Bulk vs Conventional data Loading in Oracle for Large tables

Patching RAC (Grid Plus Database) / Bundle Patch not full release

AutoConfig Usage

Using Service in Oracle RAC environment

How Oracle Cluster Starts

Configuring DG4ODBC

Stopping all cluster and database services and processes on a single node in RAC

Installing Oracle Spatial 11.2.0.4

Storing PDF Files inside Database

Relocating Voting disk and OCR from one disk group to another

SPFILE parameter in local node's pfile is automatically changed upon db startup

spfile in RAC / ASM created or restored under DB_UNKNOWN directory

Recovering a table from RMAN Backup in Oracle 12C database

Upgrading Oracle RAC 11.2.0.3 to 11.2.0.4 on Windows (GRID and Database)

How to get exact SCN for restore and recovery

Changes in 11gr2 regarding votedisk

checking exact path of oracle asm files

How to read a ASM Stamped disk to find voting disk availability without asm started

Checking properties of ASM Diskgroups

OCR Vote replacement in 11GR2

OCR Vote management in 11GR2 RAC

Coverting Single Instance to RAC using advance method

Restoring OCR from backup

Cluster Management (Starting and stopping clusterware and resources)

Exadata Cell Security Implementation

Listing Exadata Disks

Enabling SSL for EBSR12

Configuring jre on linux for firefox to run Forms

EBS processes startup and stop scripts

Committing Long running inserts after specific number of records

Checking free and used space of ASM Disk Groups

Configuring HP/UX for Oracle RAC Installation

DBMS_STAT

Identifying segment experiencing specific wait event

Creating ASM environment on personal computer and conversion from filesystem to ASM

Undocumented parameters in Oracle 11GR2

Versioning in ArcSDE

11GR2 RAC TO RAC DATA GUARD SETUP

Changes in .vmx file for Disk Sharing for ASM and RAC

Configuring NFS on Linux

Installing Patch 11.2.0.3 (Upgrade from 11.2.0.2 to 11.2.0.3)

Identifying Blocked and Blocking Sessions

Resolving Different waits

Examining Wait Events by Class

Examining Session Waits

Understanding Wait Class Events

Analyzing Wait Events

Identifying SQL Statements with the Most Waits

Checking DB Response Time

MANAGING ITERATIONS

PROCEDURE TO KILL HANGING SESSIONS

RESTORING INCREMENTAL RMAN BACKUP TO SAVE RESTORE TIME

Useful monitoring scripts

auding trigger

Index Creation Guide Lines

Estimated size of an index

Demonstation of performance gain using indexes

Auditing DML operation on tables

Compression for Tablespaces and Tables

Checking active transactions using v$transaction view

Deffered Segment allocation in 11gR2

Tuning data loading operations

Shrinking space of a table after deleting data

Table features for performance

Building a Database That Maximizes Performance

Finding Locks on TABLES

Recover and open the database if the archive log required for recovery is missing

Monitoring log on and log off activity

Adding New node to 11g R2 Cluster

Relocation SCAN and SCAN_LISTENER from one node to another

dbms_lock.sleep

adpatch: error while loading shared libraries: libclntsh.so.10.1: cannot open shared object file: No such file or directory

RAC DR Site implementation using EMC Replication Manager and SRDF

Uninstalling and cleaning Oracle RAC - Database plus cluster

Copy ASM Parameter file from asm to file system or from one filegroup to another using spcopy

copy and move files from asm to file system

Changing Maintenance mode and running ADPatch utility in EBS R12

Recreate grants and synonyms for APPS schema

Compile flexfields using ADADMIN utility

Compiling APPS Schema using ADADMIN utility

Checking missing Application files using AdAdmin UTILITY

ReLink EBS files using ADADMIN Utility

Recreating EBS Product files using ADADMIN utility

Trigger to receive emails of critical alerts on Oracle Database

Trigger to receive emails of critical alerts on Oracle Database

Trigger to receive emails of critical alerts on Oracle Database

Trigger to Log and Email critical errors

Access Control Lists --- Fine Grained Access Control in Oracle

Inserting an image in oracle database

RESTORE RMAN RAC BACKUP TO RAC ON NEW SERVER

Convert Single instance to RAC database

Rename database using NID utility

Creating ORACLE 11GR2 Physical Standby Database from active database using RMAN

Working with Indexes

Estimating the Size of an Index

Installing Database Gateway for MSSQL Server

RMAN Backup and Restore using AVAMAR

Installing Oracle 11g R2 RAC on Linux

Solaris 10 Installation

Installing Oracle 11g R2 RAC on Solaris 10

Adding and Configuring new network interface in Solaris 10

Changing Host Name in Solaris 10

Deleting obslete rman backup information from controlfile

Scheduling RMAN Batch job for backup

Restoring RMAN backup to new server

Server information

Backup Location for database

Deleting Old RMAN Backups from Netbackup Tape Media

Checking import progress from sqlplus

recovery using set until time

ORA-01775: looping chain of synonyms

ASM Auto Management of directories after archivelog deletion

Upgrading ArcSDE 9.3 or 9.3.1 Geodatabase to ArcSDE 10

Adding new redo logs to Oracle RAC on ASM

Creating Physical Standby using Data Guard Broker(DGMGRL)

CRSCTL and SRVCTL commands usage

CRS-0222 and CRS-2640 while removing RAC diskgroup

Dropping unmounted diskgroup from RAC Database

Oracle RAC Management at a Glance

Incomplete Recovery by RMAN from TAPE (ASM) to Single Instance.

Library cache pin

Finding locks on tables

Killing Blocking sessions

Creating duplicate database using rman backup

SIMPLE RMAN BACKUP SCRIPT

Configuring TAF

Checking scan health using dig utility on windows

Checking RMAN backup progress

RMAN Script for database backup on RAC

Changing SPFILE parameters in Oracle RAC Cluster

List of srvctl command options

OCR and Voting Disk Backup and restore

RMAN Script for incremental level 0 backup of database plus archivelogs and controlfile

Simple RMAN Backup Script

RMAN script to spool log to a file and automate run using Solaris cron job

Restoring Rman backup on a different node with different backup directory structures and different database directory structures

Adding New Node to Oracle 11gR2 RAC

addNode.sh on 11gR2 RAC hangs indefinitely

Removing a Node from RAC 11GR2

Cloning EBusiness Suite R12 using Rapid Clone

Files used in configuring network interface in solaris

Oracle 11g R2 installation on Solaris 10 x64

Oracle 11g R2 / ArcSDE installation on Sun Solaris 10 x64

Using 32bit ArcSDE with 64bit Oracle on 64bit Windows 2003 Server

Oracle Database SGA limitations on 32bit windows