Saturday Mar 15, 2014

sql*plus command history on Linux

RLWRAP is your friend

A customer of mine has complained about the inability to easily grab a previously submitted command in sql*plus.

Refrain from migrating the platform you are on, and use rlwrap.

  1. install the OS package "rlwrap" available in your linux distro
  2. define the following bash function in your .bash_profile
sp () {
  rlwrap sqlplus ${@:-/nolog}
}


Enjoy using sp instead of sqlplus!

Wednesday Mar 12, 2014

Alert summary, a simple and improvable tool

A simple awk script to summarize the content of your database's alert.log.[Read More]

Friday Mar 07, 2014

Ten questions to answer when thinking of logical data replication

Logical database replication may be an eagerly required "toy" in your organization. The success of new reporting applications, (near) real time data distribution and processing and so forth may heavily depend on it - and take it for granted.

This isn't surprising at all: data is supposed to appear and steadily kept current. Vendors, including Oracle, claim they are able to provide very efficient, near real time and even heterogeneous instruments to achieve this result.

With such a variety of replication solutions you have plenty of time to evaluate how strong is your concept of logical replication (and its implications), how your organization is ready to maintain it and make sure nobody will point a finger at you when it breaks.

Have a look at the following 10 simple questions and have some additional fun before playing with technology!

[Read More]

Hello world!

The first post on this blog!

About

Enrico Brambilla is an Oracle Core Technology Expert, member of Oracle Consulting. He has worked with over a hundered big and small customers across the years, gathering thoughts to share about Database, e-BS, Exadata, GoldenGate and more - not "just" technology.

Search

Categories
Archives
March 2014 »
SunMonTueWedThuFriSat
      
1
2
3
4
5
6
8
9
10
11
13
14
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
     
Today