content top

PostgreSQL Conference Europe 2014

I attended to PostgreSQL Conference Europe 2014. It was held October 21-24 at Madrid. I do not know the exact number of attendees but there were some sessions that you can not find seat and have to listen while standing up on a corner. As an Oracle DBA, PostgreSQL is a different world to me. I tried to follow the DBA track and gather as much information as I can. Unfortunately the level of DBA tracks are not deep enough for me. The most topics are designed for developer or system admins who also manage PostgreSQL Databases as a side-mission. I feel like most attendees are developers and see that a database management system should manage itself with almost zero-maintenance. This is the same approach of Microsoft SQL Server users/developers. They see the database as a part of their development environment, and expect it to behave like a answering machine. Anyway there were still interesting sessions and watching the presentations of PostgreSQL Developers was a unique opportunity.

IMG_20141022_121150

Read More

Using EMCLI to Create Named Credentials

One of my blog readers asked me to write a sample EMCLI codes to create named credentials for Database. To be able to create a named credential, you need to know the target name (unless you create a global credential), target type and credential type associated with the target type. Let’s say I want to create a named credential for my database named “TESTDB”. First I need to login to our EM12c server, and list targets named “TESTDB”:

The % sign after the TESTDB means any target type (be careful about the colon (:) symbol between target name and target type). So we know that our TESTDB is an “oracle_database”. I’m sure you will memorize most of the target types after you start to work with EMCLI but I still prefer to check them before executing commands. Now we need to get the credential types (and their attributes) associated with “oracle_database”:

Read More

BBED Block Browser EDitor for Oracle 11g

BBED (Block Browser Editor) is a tool for Oracle internal use, and it helps you to read and manipulate data at the Oracle Database block level. No need to say that it’s very powerful and also extremely dangerous because you can corrupt data/header blocks. There’s an unofficial but very comprehensive manual for BBED. It’s written by Graham Thornton. You can download it as PDF: http://orafaq.com/papers/dissassembling_the_data_block.pdf

Before Oracle 11g, BBED object code is shipped but you need to compile it to be able to run it. On 11g, the required files to compile BBED is not shipped. So you need to copy the following files from an Oracle 10g home to Oracle 11g home:

Read More

Oracle TKPROF Hidden/Undocumented Parameters

While I was examining with tkprof, I noticed that there are 2 undocumented parameters (Oracle 11gR2): verbose and diag. Let’s take a look at them.

Verbose: If you set verbose=y, tkprof will provide some extra information on output files. It adds “SQL Text addres(s)” and “SQL Text Hash Value” lines for each query:

It also adds a summary part to the end of the output file:

Read More

Configuring Oracle SQL Developer for PostgreSQL

I see that some people wonder if Oracle SQL Developer can be used with PostgreSQL. I wrote a blog post to show how you can configure Oracle SQL Developer to connect Microsoft SQL Server and MySQL. You can use the same method to configure SQL Developer for PostgreSQL. First we need to download a compatible JDBC driver from PostgreSQL site. Latest version of SQL Developer uses JDK 1.7, so we can download the JDBC41 Postgresql Driver:

postgresjdbc

Then we open Oracle SQL Developer, open preferences, database section and third party JDBC driver.

Read More
Page 1 of 3012345...Last »
content top