web analytics

Data, data everywhere 

Twitter LinkedIn RSS
magnify
Home Archive for category "Database administration"
formats

Using the debugger in Oracle 12c SQL Developer

One of the significant features of Oracle’s SQL Developer client is the built-in debugger for PL/SQL stored objects: PL/SQL stored procedures, stored functions, and triggers. In this tutorial we describe how to use the SQL Developer 4.1.0 debugger with an Oracle 12.0.1 server. Setting up the correct permissions and authorizations so that development staff can

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
No Comments  comments 
formats

Configuring Transparent Data Encryption (TDE) with Oracle 12c

I am currently building a Java EE 7 application that will utilize an Oracle 12c database for persistent storage. Because some of the data is sensitive, I decided to enable Oracle’s Transparent Data Encryption (TDE) feature, so that I could encrypt particular columns to guard against disclosure of this sensitive data either through the theft

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
No Comments  comments 
formats

What exactly is thread deadlock?

Performance testing is a key component of system testing, since a non-performant application is often viewed as just as poor as an application that contains other varieties of defects. Care and attention are required to ensure that even simple processes will not cause contention in a production environment – and sometimes these issues are difficult

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
No Comments  comments 
formats

Configuration of Oracle 12c – part deux

In this second article regarding the installation and configuration of Oracle 12c, I’ll discuss the server’s memory configuration and the settings chosen for the default installation. Again, I’m working with Oracle 12c Enterprise Edition Release 12.1.0.1.0 – 64-bit on Windows 7. Like many, I accepted all of the default configuration options when installing Oracle 12c

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
No Comments  comments 
formats

Configuration of Oracle 12c – part un

Oracle 12c represents a fairly dramatic departure from Oracle 11g in terms of setup and configuration of the server on personal workstations. The 12c release was released in 2013, but I had delayed its adoption due primarily to a lack of available reference texts. With that issue now rectified, it’s time to “take the plunge”

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
1 Comment  comments 
formats

Schema design tools are a tough challenge

Recently I was in Lausanne, Switzerland at EPFL, acting as one of the examiners for Ioannis Alagiannis’ PhD thesis defence. Yannis is a student of Natassa Ailamaki, whose work in database systems I’ve long admired. Yannis’ thesis surrounded issues surrounding NoDB – the idea of having a DBMS perform query processing over raw data files,

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
No Comments  comments 
formats

Surrogate identifiers

This past week in my INFO2080 Systems Design class we began discussing database implementations and I made several points about surrogate keys, their formats, and their generation. I had published these thoughts in an article just over four years ago; here it is again. This blog entry is copyright by Sybase, Inc., an SAP Company,

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
1 Comment  comments 
formats

Disk failures in the real world

Further to my previous article regarding disk corruption, below is another article originally published on my Sybase blog that outlined some results from Remzi Arpaci-Dusseau’s group at Wisconsin on the characteristics of failures with commodity disk hardware. This blog entry is copyright by Sybase, Inc., an SAP Company, and first appeared on Glenn Paulley’s Sybase

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
No Comments  comments 
formats

Surrogate identifiers

This semester I’m teaching a course entitled “Application programming with Oracle” and one of the things I want to stress to my students is the interdependency between design decisions and database application performance. Early in the term we are looking at database design tradeoffs, and those discussions reminded me of this blog post from 2008,

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
1 Comment  comments