Configure STATSPACK to monitor performance on Oracle Database

Actually Oracle includes a set of internal tools to capture and maintain history of database performance. This group of tools called “Automatic Workload Repository” (AWR from now) exists in any database from 10g. The big issue with AWR is the requirement of “Database Diagnostics Pack” license to access the information (this implies that this information […]

Read more "Configure STATSPACK to monitor performance on Oracle Database"

Connect to Oracle through a firewall

First some assumptions: You connect to a remote Oracle Server using TCP/IP The remote server/network is protected by a Firewall The connection not uses “Oracle Shared Server”, “Oracle Connection Manager” or “Resident Connection Pooling” (is a standard dedicated connection). These are lots of assumptions, but the vast majority of Oracle installations are agree with all […]

Read more "Connect to Oracle through a firewall"

Oracle character set basics

In this entry I try to explain some basic facts about character sets in Oracle Databases and the most current issues with them. The databases can store different types of information, numbers, dates, characters, raw data (data with a format know by the owner but not necessary by the database) among others, but internally all […]

Read more "Oracle character set basics"

Cluster Health Monitor Database size, or who is filling my clusterware volume?

Inside most installations of Oracle Clusterware 11g exists an “Berkeley DB” database used to store system performance data. This database also exists on the initial release of 12g ( database, and after that (from 12c patch1 or this “Berkeley DB” is replaced by an Oracle DB (called “Grid Infrastructure Management Repository”) This database is […]

Read more "Cluster Health Monitor Database size, or who is filling my clusterware volume?"