ALL POSTS

Making Existing SQLPLUS Scripts 12c and Container DB (PDB) Compatible

Oracle 12c introduces new catalog features including CDB_ dictionary views (which include a CON_ID column) superseding the DBA_ views that most DBA sqlplus scripts are based upon. However, existing DBA sqlplus scripts can easily be modified using just a few simple sqlplus techniques to be compatible with 11g, as well as all types of 12c…

fsfreeze in Linux

The fsfreeze command, is used to suspend and resume access to a file system. This allows consistent snapshots to be taken of the filesystem. fsfreeze supports Ext3/4, ReiserFS, JFS and XFS. A filesystem can be frozen using following command: # /sbin/fsfreeze -f /data Now if you are writing to this filesystem, the process/command will be…

Ingest a Single Table from Microsoft SQL Server Data into Hadoop

Introduction This blog describes the best-practice approach in regards to the data ingestion from SQL Server into Hadoop. The case scenario is described as under: Single table ingestion (no joins) No partitioning Complete data ingestion (trash old and replace new) Data stored in Parquet format Pre-requisites This example has been tested using the following versions: Hadoop…

OpenTSDB and Google Cloud Bigtable

Data comes in different shapes. One of the these shapes is called a time series. Time series is basically a sequence of data points recorded over time. If, for example, you measure the height of the tide every hour for 24 hours, then you will end up with a time series of 24 data points….

OEM 12c Silent Installation

“What’s for lunch today?”, said the newly born ready to run Red Hat 6.4 server. “Well, I have an outstanding 3-course meal of OEM12c installation. For the appetizer, a light and crispy ASM 12c, DB 12c with patching for the main and desert, and to cover everything up, OEM 12c setup and configuration”, replied  the DBA who…

Page 4 of 284« First Page...23456...10...Last Page »